hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-04-10 00:10:09 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • a9f18b97ba Adjust join_1.out to match Windows behavior for new mergejoin regression test, per Dave Page and buildfarm. Perhaps we will need a join_2 instead, but for the moment assume that this test tracks the other diffs. Tom Lane 2006-03-19 01:19:55 +00:00
  • 381cb046ed Adjust join_1.out to match Windows behavior for new mergejoin regression test, per Dave Page and buildfarm. Perhaps we will need a join_2 instead, but for the moment assume that this test tracks the other diffs. Tom Lane 2006-03-19 01:19:42 +00:00
  • efef460028 The call to DNSServiceRegistrationCreate in postmaster.c does incorrect byte-swapping on the port number which causes the call to fail on Intel Macs. Neil Conway 2006-03-18 22:10:44 +00:00
  • a6e40d9f42 The call to DNSServiceRegistrationCreate in postmaster.c does incorrect byte-swapping on the port number which causes the call to fail on Intel Macs. Neil Conway 2006-03-18 22:10:14 +00:00
  • e78be57d19 The call to DNSServiceRegistrationCreate in postmaster.c does incorrect byte-swapping on the port number which causes the call to fail on Intel Macs. Neil Conway 2006-03-18 22:10:11 +00:00
  • a5dba02359 The call to DNSServiceRegistrationCreate in postmaster.c does incorrect byte-swapping on the port number which causes the call to fail on Intel Macs. Neil Conway 2006-03-18 22:09:58 +00:00
  • 8bf221b09b Fix bug introduced into mergejoin logic by performance improvement patch of 2005-05-13. When we find that a new inner tuple can't possibly match any outer tuple (because it contains a NULL), we can't immediately skip the tuple when we are in NEXTINNER state. Doing so can lead to emitting multiple copies of the tuple in FillInner mode, because we may rescan the tuple after returning to a previous marked tuple. Instead, proceed to NEXTOUTER state the same as we used to do. After we've found that there's no need to return to the marked position, we can go to SKIPINNER_ADVANCE state instead of SKIP_TEST when the inner tuple is unmatchable; this preserves the performance improvement. Per bug report from Bruce. I also made a couple of cosmetic code rearrangements and added a regression test for the problem. Tom Lane 2006-03-17 19:38:21 +00:00
  • b3358e2642 Fix bug introduced into mergejoin logic by performance improvement patch of 2005-05-13. When we find that a new inner tuple can't possibly match any outer tuple (because it contains a NULL), we can't immediately skip the tuple when we are in NEXTINNER state. Doing so can lead to emitting multiple copies of the tuple in FillInner mode, because we may rescan the tuple after returning to a previous marked tuple. Instead, proceed to NEXTOUTER state the same as we used to do. After we've found that there's no need to return to the marked position, we can go to SKIPINNER_ADVANCE state instead of SKIP_TEST when the inner tuple is unmatchable; this preserves the performance improvement. Per bug report from Bruce. I also made a couple of cosmetic code rearrangements and added a regression test for the problem. Tom Lane 2006-03-17 19:38:12 +00:00
  • 5094f99830 Document long names for format options (plain, tar, custom). They already worked and someone asked about them, so we might as well document them. Peter Eisentraut 2006-03-17 16:02:47 +00:00
  • 0941a8901b Fixed bug 2330: Wrong error code in case of a duplicate key Michael Meskes 2006-03-17 15:46:13 +00:00
  • 92f5bfcc0f Fix invalid use of #if within a macro, per Laurenz Albe. Also try to make the LDAP code's error messages look like they were written by someone who had heard of our style guidelines. Tom Lane 2006-03-16 18:11:17 +00:00
  • 2316013961 Clean up representation of function RTEs for functions returning RECORD. The original coding stored the raw parser output (ColumnDef and TypeName nodes) which was ugly, bulky, and wrong because it failed to create any dependency on the referenced datatype --- and in fact would not track type renamings and suchlike. Instead store a list of column type OIDs in the RTE. Tom Lane 2006-03-16 00:31:55 +00:00
  • 5981b9d03e Fix typo in pgcvslog, used == instead of =. Bruce Momjian 2006-03-15 03:24:17 +00:00
  • 1349839c3c It seems the YYLLOC_DEFAULT macro recommended by the Bison 1.875 manual just doesn't work with Bison 2.0 ... fix it ... Tom Lane 2006-03-14 23:03:20 +00:00
  • 35b5509782 Missed this file in previous commit :-( Tom Lane 2006-03-14 22:50:46 +00:00
  • 20ab467d76 Improve parser so that we can show an error cursor position for errors during parse analysis, not only errors detected in the flex/bison stages. This is per my earlier proposal. This commit includes all the basic infrastructure, but locations are only tracked and reported for errors involving column references, function calls, and operators. More could be done later but this seems like a good set to start with. I've also moved the ReportSyntaxErrorPosition logic out of psql and into libpq, which should make it available to more people --- even within psql this is an improvement because warnings weren't handled by ReportSyntaxErrorPosition. Tom Lane 2006-03-14 22:48:25 +00:00
  • 48fb696753 Fix a number of syntax errors in contrib modules' uninstall scripts. Most of the changes add the mandatory USING clause to DROP OPERATOR CLASS statements. DROP TYPE is now DROP TYPE CASCADE; without CASCADE a DROP TYPE fails due to the circular dependency on the type's I/O functions. The DROP FUNCTION statements for the I/O functions have been removed, as DROP TYPE CASCADE removes them automatically. Patch from Michael Fuhr. Neil Conway 2006-03-13 18:04:58 +00:00
  • 4a85bf3eaf Remove Christof Petig copyright. He already approved removal from an include file in the same area,. Bruce Momjian 2006-03-11 16:57:44 +00:00
  • 98d42c2450 Remove copyright notices from Jan (per author approval), and those files derived from Jan's. Bruce Momjian 2006-03-11 16:43:22 +00:00
  • f3d99d160d Add CVS tag lines to files that were lacking them. Bruce Momjian 2006-03-11 04:38:42 +00:00
  • 7992d0fbca Remove a few places that attempted to define INT_MAX, SCHAR_MAX, and similar constants if they were not previously defined. All these constants must be defined by limits.h according to C89, so we can safely assume they are present. Neil Conway 2006-03-11 01:19:22 +00:00
  • c65ab0bfa9 Recent changes in memory management in tuplesort.c had a problem: the case where we run low on array slots before we run low on memory is much more probable than I had thought, and so it's important to treat each tape fairly in that case. To fix this, track per-tape slot allocations just like we track per-tape space allocation. Also, in the FINALMERGE code path avoid scanning all the input tapes when we really only need to read from one. This should fix poor behavior with very large work_mem as exhibited by Stefan Kaltenbrunner. I didn't do anything about putting an upper bound on the number of tapes, but maybe we should still consider that. Tom Lane 2006-03-10 23:19:00 +00:00
  • d777a57133 Add a CHECK_FOR_INTERRUPTS() in _bt_buildadd(). This fixes problem with not responding to query cancel during the last stage of btree index creation. Tom Lane 2006-03-10 20:18:25 +00:00
  • 9f6192490e Add a CHECK_FOR_INTERRUPTS() in _bt_buildadd(). This fixes problem with not responding to query cancel during the last stage of btree index creation. Tom Lane 2006-03-10 20:18:15 +00:00
  • 0ebf1cc834 Implement 4 new aggregate functions from SQL2003. Specifically: var_pop(), var_samp(), stddev_pop(), and stddev_samp(). var_samp() and stddev_samp() are just renamings of the historical Postgres aggregates variance() and stddev() -- the latter names have been kept for backward compatibility. This patch includes updates for the documentation and regression tests. The catversion has been bumped. Neil Conway 2006-03-10 20:15:28 +00:00
  • ab812ef326 Remove unintened change to pg_proc.h. Bruce Momjian 2006-03-10 19:12:51 +00:00
  • 497b5ad928 Make $PostgreSQL CVS tags consistent for SGML files. Bruce Momjian 2006-03-10 19:10:50 +00:00
  • ea8eeb4ca7 Fix order of linking of libxslt and libxml2, per Dave Page. Tom Lane 2006-03-10 15:40:06 +00:00
  • effecebad1 Fix order of linking of libxslt and libxml2, per Dave Page. Tom Lane 2006-03-10 15:39:53 +00:00
  • 7d84d3ec1c Fix order of linking of libxslt and libxml2, per Dave Page. Tom Lane 2006-03-10 15:39:42 +00:00
  • 98ab0c96dd Add a CHECK_FOR_INTERRUPTS() to the loop in ExecMakeTableFunctionResult. Otherwise you can't cancel queries like select ... from generate_series(1,1000000). Tom Lane 2006-03-10 01:51:34 +00:00
  • bbfa1c39a1 Add a CHECK_FOR_INTERRUPTS() to the loop in ExecMakeTableFunctionResult. Otherwise you can't cancel queries like select ... from generate_series(1,1000000). Tom Lane 2006-03-10 01:51:23 +00:00
  • 5931737571 Remove Jan Wieck's name from copyrights, and put in standard boilerplate, with approval of author. Bruce Momjian 2006-03-09 21:29:38 +00:00
  • 0a5c6fadf4 Remove somebody's flight of fancy about an UPDATE with ORDER BY and LIMIT. Tom Lane 2006-03-08 22:59:17 +00:00
  • 66fc528d99 Remove somebody's flight of fancy about an UPDATE with ORDER BY and LIMIT. Tom Lane 2006-03-08 22:59:09 +00:00
  • 4c0efd3ae2 Remove Christof Petig copyright on include file, per author request. Bruce Momjian 2006-03-08 22:00:27 +00:00
  • c8cd76de28 Tweak trace_sort code to show the merge order (number of active input tapes) for each merge step. This will give us some idea of how effective the merge distribution algorithm is. Tom Lane 2006-03-08 16:59:03 +00:00
  • d233ec299c Update pltcl expected file for E''. Bruce Momjian 2006-03-08 08:00:35 +00:00
  • c574106a66 Adjust plpython for escape_string_warning. Bruce Momjian 2006-03-08 04:01:29 +00:00
  • bc0be355c8 Adjust PL regression tests for escape_string_warning. Bruce Momjian 2006-03-08 03:58:53 +00:00
  • daab4a101f Update /contrib regression tests for escape_string_warning. Bruce Momjian 2006-03-08 03:51:52 +00:00
  • 43ceb3d449 Further examination of ltsReleaseBlock usage shows that it's got a performance issue during regular merge passes not only the 'final merge' case. The original design contemplated that there would never be more than about one free block per 'tape', hence no need for an efficient method of keeping the free blocks sorted. But given the later addition of merge preread behavior in tuplesort.c, there is likely to be about work_mem worth of free blocks, which is not so small ... and for that matter the number of tapes isn't necessarily small anymore either. So we'd better get rid of the assumption entirely. Instead, I'm assuming that the usage pattern will involve alternation between merge preread and writing of a new run. This makes it reasonable to just add blocks to the list without sorting during successive ltsReleaseBlock calls, and then do a qsort() when we start getting ltsGetFreeBlock() calls. Experimentation seems to confirm that there aren't many qsort calls relative to the number of ltsReleaseBlock/ltsGetFreeBlock calls. Tom Lane 2006-03-07 23:46:24 +00:00
  • 8db05ba411 Repair old performance bug in tuplesort.c/logtape.c. In the case where we are doing the final merge pass on-the-fly, and not writing the data back onto a 'tape', the number of free blocks in the tape set will become large, leading to a lot of time wasted in ltsReleaseBlock(). There is really no need to track the free blocks anymore in this state, so add a simple shutoff switch. Per report from Stefan Kaltenbrunner. Tom Lane 2006-03-07 19:06:50 +00:00
  • e6107da53c Turn off zero_damaged_pages in the right place (ie, in the autovac process not in the postmaster) and with the right GucSource (needs to be a nontransactional source since we've not started an xact yet). Tom Lane 2006-03-07 17:32:22 +00:00
  • 8d51c276ca Use SetConfigOption() to turn off "zero_damaged_pages" in autovacuum. Bruce Momjian 2006-03-07 03:03:09 +00:00
  • 79d25cf775 Back out comment update about sighup, original was accurate. Bruce Momjian 2006-03-07 03:01:22 +00:00
  • ce1106d2fa Properly set "escape_string_warning" to default to true. Bruce Momjian 2006-03-07 02:54:23 +00:00
  • fb51ad3419 Make all our flex and bison files use %option prefix or %name-prefix (respectively) to rename yylex and related symbols. Some were doing it this way already, while others used not-too-reliable sed hacks in the Makefiles. It's all nice and consistent now. Tom Lane 2006-03-07 01:03:12 +00:00
  • 012abebab1 Remove the stub support we had for UNION JOIN; per discussion, this is not likely ever to be implemented seeing it's been removed from SQL2003. This allows getting rid of the 'filter' version of yylex() that we had in parser.c, which should save at least a few microseconds in parsing. Tom Lane 2006-03-07 01:00:19 +00:00
  • 48cf295742 'make clean' should NOT remove *~ files. Tom Lane 2006-03-07 00:48:07 +00:00
  • 135fe1899d SGML typo fix. Bruce Momjian 2006-03-06 22:54:14 +00:00
  • d694bd812a Default to ON for 8.2, as announced in the release notes: Bruce Momjian 2006-03-06 22:52:10 +00:00
  • 1c02144731 Done though the second is default so off in 8.2: Bruce Momjian 2006-03-06 22:51:20 +00:00
  • d69b163247 Attached is the new patch. To summarize: Bruce Momjian 2006-03-06 22:49:17 +00:00
  • 19c21d115d Enable standard_conforming_strings to be turned on. Bruce Momjian 2006-03-06 19:49:20 +00:00
  • a9c1047ebd Update comment on how sighup signal affects postgresql.conf reload. Bruce Momjian 2006-03-06 18:38:11 +00:00
  • a0af608adc * Stephen Frost (sfrost@snowman.net) wrote: > I've now tested this patch at home w/ 8.2HEAD and it seems to fix the > bug. I plan on testing it under 8.1.2 at work tommorow with > mod_auth_krb5, etc, and expect it'll work there. Assuming all goes > well and unless someone objects I'll forward the patch to -patches. > It'd be great to have this fixed as it'll allow us to use Kerberos to > authenticate to phppgadmin and other web-based tools which use > Postgres. Bruce Momjian 2006-03-06 17:59:42 +00:00
  • 526f773d2f * Stephen Frost (sfrost@snowman.net) wrote: > I've now tested this patch at home w/ 8.2HEAD and it seems to fix the > bug. I plan on testing it under 8.1.2 at work tommorow with > mod_auth_krb5, etc, and expect it'll work there. Assuming all goes > well and unless someone objects I'll forward the patch to -patches. > It'd be great to have this fixed as it'll allow us to use Kerberos to > authenticate to phppgadmin and other web-based tools which use > Postgres. Bruce Momjian 2006-03-06 17:59:30 +00:00
  • 357cc01e57 This patch adds native LDAP auth, for those platforms that don't have PAM (such as Win32, but also unixen without PAM). On Unix, uses OpenLDAP. On win32, uses the builin WinLDAP library. Bruce Momjian 2006-03-06 17:41:44 +00:00
  • ebdc35822d Add: Bruce Momjian 2006-03-06 17:10:31 +00:00
  • 2abf8c7719 Update item. Bruce Momjian 2006-03-06 15:21:42 +00:00
  • d2eb1d12a0 Add for Win32: Bruce Momjian 2006-03-06 15:19:45 +00:00
  • 07408e841d Add WSACancelBlockingCall TODO.detail item. Bruce Momjian 2006-03-06 15:19:19 +00:00
  • e166574a1d Add for ecpg: Bruce Momjian 2006-03-06 15:13:38 +00:00
  • 5e3bcac1d9 Fix psql history handling so 'execute' backslash commands (\g) remain as part of the multi-line query. Bruce Momjian 2006-03-06 15:09:04 +00:00
  • 2f01703f90 Update: Bruce Momjian 2006-03-06 05:22:31 +00:00
  • 1ad126314f Add: Bruce Momjian 2006-03-06 05:16:21 +00:00
  • 4c63b1f88e Prevent autovacuum from zeroing damaged pages. Bruce Momjian 2006-03-06 05:14:19 +00:00
  • 7d40942a27 in the docs, the function "ascii(text)" is described as returning "ASCII code of the first character of the argument" Bruce Momjian 2006-03-06 04:53:50 +00:00
  • ca8f27998a In psql, save history of backslash commands used in multi-line statements before the multi-line statement, rather than inside the multi-line statement. Bruce Momjian 2006-03-06 04:45:21 +00:00
  • 99114a2473 Per recent discussion on -hackers, we should sometimes reorder the columns of the grouping clause to avoid redundant sorts. The optimizer is not currently capable of doing this, so this patch implements a simple hack in the analysis phase (transformGroupClause): if any subset of the GROUP BY clause matches a prefix of the ORDER BY list, that prefix is moved to the front of the GROUP BY clause. This shouldn't change the semantics of the query, and allows a redundant sort to be avoided for queries like "GROUP BY a, b ORDER BY b". Neil Conway 2006-03-05 21:34:34 +00:00
  • f9520ac110 Add: Bruce Momjian 2006-03-05 18:28:46 +00:00
  • 5d723d05c0 Prepared queries for PLPerl, plus fixing a small plperl memory leak. Patch and docs from Dmitry Karasik, slightly editorialised. Andrew Dunstan 2006-03-05 16:40:51 +00:00
  • f2f5b05655 Update copyright for 2006. Update scripts. Bruce Momjian 2006-03-05 15:59:11 +00:00
  • e096406c05 Update to 2006. Bruce Momjian 2006-03-05 15:21:45 +00:00
  • 5173b1a40f Done: Bruce Momjian 2006-03-05 15:16:58 +00:00
  • 3923f08ca0 Check for "msys" so it doesn't use 'con' by checking for an evironment variable. Bruce Momjian 2006-03-05 05:33:47 +00:00
  • a643385eaf Check for "msys" so it doesn't use 'con' by checking for an evironment variable. Bruce Momjian 2006-03-05 05:33:19 +00:00
  • a4a6ee4a5d Check for "msys" so it doesn't use 'con' by checking for an evironment variable. Bruce Momjian 2006-03-05 05:33:12 +00:00
  • 5fde861375 Improve STRINGS_H macro test for MSVC extensions. Bruce Momjian 2006-03-05 04:43:57 +00:00
  • c1bb2877b2 Improve OS X shared-memory documentation: fix typos and provide a usable example of /etc/sysctl.conf contents. Tom Lane 2006-03-05 03:50:44 +00:00
  • 5b8ac71042 Support include directives in postgresql.conf. Patch by Joachim Wieland, somewhat reworked for clarity and portability. Tom Lane 2006-03-04 22:19:31 +00:00
  • 60d3c9fdf4 Declare the arguments of AllocateFile() as const char *, not char *. This is consistent with the standard definition of fopen(). Tom Lane 2006-03-04 21:32:47 +00:00
  • 2689abf078 Incorporate a couple of recent tuplesort.c improvements into tuplestore.c. In particular, ensure that enlargement of the memtuples[] array doesn't fall foul of MaxAllocSize when work_mem is very large, and don't bother enlarging it if that would force an immediate switch into 'tape' mode anyway. Tom Lane 2006-03-04 19:30:12 +00:00
  • 53bbc47c2b Prevent lazy_space_alloc from making requests that exceed MaxAllocSize, per report from Stefan Kaltenbrunner. Tom Lane 2006-03-04 19:09:23 +00:00
  • 20bdc71369 Prevent lazy_space_alloc from making requests that exceed MaxAllocSize, per report from Stefan Kaltenbrunner. Tom Lane 2006-03-04 19:09:09 +00:00
  • 80cadb303c Prevent sorting from requesting a SortTuple array that exceeds MaxAllocSize; we'll go over to disk-based sort if we reach that limit. This fixes Stefan Kaltenbrunner's observation that sorting can suffer an 'invalid memory alloc request size' failure when sort_mem is set large enough. It's unfortunately not so easy to fix in 8.1 ... Tom Lane 2006-03-04 19:05:06 +00:00
  • 3134e61557 Minor teak. Tatsuo Ishii 2006-03-04 12:37:01 +00:00
  • 342fae3dc5 Minor teak. Tatsuo Ishii 2006-03-04 12:35:08 +00:00
  • 52c4e32d5f Tighten up SJIS byte sequence check. Now we reject invalid SJIS byte sequence such as "0x95 0x27". Patches from Akio Ishida. Tatsuo Ishii 2006-03-04 12:32:59 +00:00
  • ecd635c755 Tighten up SJIS byte sequence check. Now we reject invalid SJIS byte sequence such as "0x95 0x27". Patches from Akio Ishida. Tatsuo Ishii 2006-03-04 12:09:47 +00:00
  • c5167b794a Tighten up SJIS byte sequence check. Now we reject invalid SJIS byte sequence such as "0x95 0x27". Patches from Akio Ishida. Tatsuo Ishii 2006-03-04 11:54:02 +00:00
  • 8ccc7dfaf1 Tighten up SJIS byte sequence check. Now we reject invalid SJIS byte sequence such as "0x95 0x27". Patches from Akio Ishida. Tatsuo Ishii 2006-03-04 11:10:44 +00:00
  • b3d0442ab3 Tighten up SJIS byte sequence check. Now we reject invalid SJIS byte sequence such as "0x95 0x27". Patches from Akio Ishida. Also update copyright notice. Tatsuo Ishii 2006-03-04 10:57:35 +00:00
  • 18bc9ea561 Add: Bruce Momjian 2006-03-04 05:02:03 +00:00
  • 3bce31f613 > gettimeofday.c:35: warning: integer constant is too large for "long" > type Bruce Momjian 2006-03-04 04:44:07 +00:00
  • f1d7f80c1a > It doesn't say that only the listed commands acquire ACCESS EXCLUSIVE, > just that certain commands do. TRUNCATE isn't shown. Bruce Momjian 2006-03-04 04:41:36 +00:00
  • ba89cae454 Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Bruce Momjian 2006-03-04 04:31:05 +00:00
  • cff68063de Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Bruce Momjian 2006-03-04 04:30:51 +00:00
  • 64e7c8a951 Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Bruce Momjian 2006-03-04 04:30:41 +00:00