hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-27 02:58:34 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 26d6054128 That was a typo in my comment before the code (the nutshell descriptions after the code are correct). Only shmmax needs to be multiples of the page size (at least, that's how I interpret the Darwin code). Bruce Momjian 2006-03-04 03:47:29 +00:00
  • 295615a6ca This patch fixes this warning. Bruce Momjian 2006-03-03 23:59:14 +00:00
  • b7a870ccc7 Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. Bruce Momjian 2006-03-03 23:54:52 +00:00
  • e57415c507 Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. Bruce Momjian 2006-03-03 23:49:21 +00:00
  • ef3f7c3f74 Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. Bruce Momjian 2006-03-03 23:49:12 +00:00
  • decdaf3592 Improve pg_dump and psql to use libpq's newer COPY support routines, instead of the old deprecated ones. Volkan Yazici, with some editorializing by moi. Tom Lane 2006-03-03 23:38:30 +00:00
  • 0b1b010c12 Fixes for Win32-client only compiles. Bruce Momjian 2006-03-03 23:11:48 +00:00
  • 43e9bab94a Rename Online Backup to Continuous Archiving. Bruce Momjian 2006-03-03 22:02:08 +00:00
  • 69c539b535 Update ipcclean to use try 'id' first for root check. Bruce Momjian 2006-03-03 21:52:47 +00:00
  • bf8337b8af Update ipcclean to use try 'id' first for root check. Bruce Momjian 2006-03-03 21:52:37 +00:00
  • 28edbdb7be Add workaround so MSVC doesn't try to load strings.h, which it doesn't have. This happens when MSVC uses pg_config.h generated by MinGW. Bruce Momjian 2006-03-03 21:35:46 +00:00
  • 523adeb111 Teach PQcmdTuples() that a COPY command tag might contain a row count, and tighten up its sanity checking of the tag as a safety measure. Volkan Yazici. Tom Lane 2006-03-03 20:57:32 +00:00
  • 502e9aefdc Clarify macro layout for win32 IMPORT. Bruce Momjian 2006-03-03 20:52:36 +00:00
  • f4a4755734 Done: Bruce Momjian 2006-03-03 20:43:00 +00:00
  • c776fba1e1 Done: Bruce Momjian 2006-03-03 20:37:29 +00:00
  • 023570f5e3 Make the COPY command return a command tag that includes the number of rows copied. Backend side of Volkan Yazici's recent patch, with corrections and documentation. Tom Lane 2006-03-03 19:54:10 +00:00
  • 4e086f7cb5 Dept. of second thoughts: rejigger the TRUNCATE ... CASCADE patch so that relations are still checked for permissions etc as soon as they are opened. The original form of the patch could hold exclusive lock for a long time on relations that the user doesn't even have permissions to access, let alone truncate. Tom Lane 2006-03-03 18:25:14 +00:00
  • 7a88571f03 In ipcclean, check LOGNAME only if USER is not set. Bruce Momjian 2006-03-03 16:49:30 +00:00
  • a6add72ac3 In ipcclean, check LOGNAME only if USER is not set. Bruce Momjian 2006-03-03 16:49:21 +00:00
  • 587bc81887 Fix a typo. Neil Conway 2006-03-03 04:31:07 +00:00
  • 984a6ced3e Add CASCADE option to TRUNCATE. Joachim Wieland Tom Lane 2006-03-03 03:30:54 +00:00
  • 2a0ba3f8dd Add: Bruce Momjian 2006-03-03 03:13:04 +00:00
  • 2c620740bd Appended is a small documentation patch that adds a note to the CREATE ROLE page, based on what Tom Lane told me here: Bruce Momjian 2006-03-03 03:06:17 +00:00
  • b35440eae8 Appended is a small documentation patch that adds a note to the CREATE ROLE page, based on what Tom Lane told me here: Bruce Momjian 2006-03-03 03:06:05 +00:00
  • 66eccb466e Add: Bruce Momjian 2006-03-03 02:38:57 +00:00
  • d65b4e30f0 Add: Bruce Momjian 2006-03-03 02:18:09 +00:00
  • 6839bc95d4 Add comment about localized month names for to_date and to_timestamp. Bruce Momjian 2006-03-03 02:17:30 +00:00
  • 9a506a6257 Arrange to call AbsorbFsyncRequests every so often while performing a checkpoint in the bgwriter. This forestalls overflow of the fsync request queue, which is not fatal but causes considerable performance degradation when it occurs (because backends then have to do their own fsyncs). Per patch from Itagaki Takahiro, modified a little bit by me. Tom Lane 2006-03-03 00:02:02 +00:00
  • f0bfc02001 Remove unnecessary lo_lseek call in lo_open. Apparently there was once a need for it back in the neolithic era, but it's certainly dead code in any PG release we would recognize as such. Since it forces an additional network round trip to the backend, getting rid of it should provide some small performance improvement for large-object-using clients. Tom Lane 2006-03-02 21:56:14 +00:00
  • 69f69808c5 Fix ancient error in large objects usage example: overwrite() subroutine was opening with INV_READ flag and then writing. Prior to 8.1 the backend did not reject this, but now it does. Tom Lane 2006-03-02 21:49:19 +00:00
  • 56aa84a69c Fix ancient error in large objects usage example: overwrite() subroutine was opening with INV_READ flag and then writing. Prior to 8.1 the backend did not reject this, but now it does. Tom Lane 2006-03-02 21:49:09 +00:00
  • 0138fb8697 Repair oidvectorrecv and int2vectorrecv, which I broke while changing them to use array_recv :-(. Per report from Tim Kordas. Tom Lane 2006-03-02 21:13:11 +00:00
  • 9356877bba Repair oidvectorrecv and int2vectorrecv, which I broke while changing them to use array_recv :-(. Per report from Tim Kordas. Tom Lane 2006-03-02 21:13:04 +00:00
  • 5e4bf929b3 Update OS X shared memory documentation for 10.3.9 and later to use /etc/sysctl.conf. Bruce Momjian 2006-03-02 20:30:33 +00:00
  • 487b7f5de3 Update OS X shared memory documentation for 10.3.9 and later to use /etc/sysctl.conf. Bruce Momjian 2006-03-02 20:30:21 +00:00
  • 3fb582c3bc Backpatch to 8.1.X. Already applied to CVS HEAD. Bruce Momjian 2006-03-02 19:40:29 +00:00
  • 006bd450fe Mark tsearch2 item as Tom's, not Teodor's. Bruce Momjian 2006-03-02 19:35:14 +00:00
  • 33a84bb306 Mark tsearch2 item as Tom's, not Teodor's. Bruce Momjian 2006-03-02 19:34:43 +00:00
  • 989d94a171 Update TODO.detail/qsort. Bruce Momjian 2006-03-02 19:21:05 +00:00
  • 8da308036d Update TODO.detail/qsort. Bruce Momjian 2006-03-02 19:20:44 +00:00
  • 38c4fe87ac Significantly improve ranking: 1) rank_cd now use weight of lexemes 2) rank_cd and rank can use any combination of normalization methods: no normalization normalization by log(length of document) -----/------- by length of document -----/------- by number of unique word in document -----/------- by log(number of unique word in document) -----/------- by number of covers (only rank_cd) Teodor Sigaev 2006-03-02 19:07:19 +00:00
  • 85fa9f516c Update TODO.detail/qsort. Bruce Momjian 2006-03-02 18:20:25 +00:00
  • 1fa33539ab Add to TODO.detail for qsort. Bruce Momjian 2006-03-02 18:18:13 +00:00
  • f79df7fcc9 Add: Bruce Momjian 2006-03-02 18:18:00 +00:00
  • b3c47b1e5e Fix possible crash at transaction end when a plpgsql function is used and then modified within the same transaction. The code was using a linked list of active PLpgSQL_expr structs, which was OK when it was written because plpgsql never released any parse data structures for the life of the backend. But since Neil fixed plpgsql's memory management, elements of the linked list could be freed, leading to crash when the list is chased. Per report and test case from Kris Jurka. Tom Lane 2006-03-02 05:34:17 +00:00
  • fa7f6ff0db Fix possible crash at transaction end when a plpgsql function is used and then modified within the same transaction. The code was using a linked list of active PLpgSQL_expr structs, which was OK when it was written because plpgsql never released any parse data structures for the life of the backend. But since Neil fixed plpgsql's memory management, elements of the linked list could be freed, leading to crash when the list is chased. Per report and test case from Kris Jurka. Tom Lane 2006-03-02 05:34:12 +00:00
  • 181f55e5fb Fix up pg_dump to emit shell-type definitions at the proper time, to make use of the recently added ability to create a shell type explicitly. Tom Lane 2006-03-02 01:18:26 +00:00
  • 305fcb7aa4 Woops: also update the alternative "expected" files for contrib/cube's regression tests to account for the new error message wording. It seems today is not my day... Neil Conway 2006-03-01 23:00:56 +00:00
  • 15516c5f0b Update FAQ_DEV text file. Bruce Momjian 2006-03-01 22:25:36 +00:00
  • 8fe61f0d86 Update text file. Bruce Momjian 2006-03-01 22:24:51 +00:00
  • 88a4314bb1 Update patch generation instructions. Bruce Momjian 2006-03-01 22:23:49 +00:00
  • 711c38398e Update patch generation instructions. Bruce Momjian 2006-03-01 22:23:14 +00:00
  • 485541a3aa Update the expected regression test results to account for the changes to error messages I made yesterday -- thanks to Andrew Dunstan for reporting this, and my apologies for missing it the first time. Neil Conway 2006-03-01 21:09:32 +00:00
  • e559dba846 Update Japanese FAQ, backpatched to 8.1.X. Bruce Momjian 2006-03-01 20:31:56 +00:00
  • 0cb0ec9ed9 Update Japanese FAQ, backpatched to 8.1.X. Bruce Momjian 2006-03-01 20:31:29 +00:00
  • 0d9742f99a Attached is a patch that replaces a bunch of places where StringInfos are unnecessarily allocated on the heap rather than the stack. If the StringInfo doesn't outlive the stack frame in which it is created, there is no need to allocate it on the heap via makeStringInfo() -- stack allocation is faster. While it's not a big deal unless the code is in a critical path, I don't see a reason not to save a few cycles -- using stack allocation is not less readable. Neil Conway 2006-03-01 06:51:01 +00:00
  • 8e5a10d46c This patch makes the error message strings throughout the backend more compliant with the error message style guide. In particular, errdetail should begin with a capital letter and end with a period, whereas errmsg should not. I also fixed a few related issues in passing, such as fixing the repeated misspelling of "lexeme" in contrib/tsearch2 (per Tom's suggestion). Neil Conway 2006-03-01 06:30:32 +00:00
  • 6853e34132 Add pg_service.conf documentation for libpq. Bruce Momjian 2006-03-01 00:23:33 +00:00
  • 87fa10a426 Add pg_service.conf documentation for libpq. Bruce Momjian 2006-03-01 00:23:21 +00:00
  • e24cea8be5 Fix typo in comment. Neil Conway 2006-02-28 23:38:13 +00:00
  • 8e68d78390 Allow the syntax CREATE TYPE foo, with no parameters, to permit explicit creation of a shell type. This allows a less hacky way of dealing with the mutual dependency between a datatype and its I/O functions: make a shell type, then make the functions, then define the datatype fully. We should fix pg_dump to handle things this way, but this commit just deals with the backend. Tom Lane 2006-02-28 22:37:27 +00:00
  • 7f19339cca Back out libpq changes for service --- not ready yet. Bruce Momjian 2006-02-28 22:35:35 +00:00
  • b04d19f230 Fix PG_VERSION_NUM for different awk -F handling. Bruce Momjian 2006-02-28 22:34:24 +00:00
  • c979afb7e0 Fix PG_VERSION_NUM awk -F parameter. Bruce Momjian 2006-02-28 21:59:19 +00:00
  • 2b8afe6193 Tweak the error message emitted when a void-returning PL/Python function does not return None, per suggestion from Tom. Neil Conway 2006-02-28 20:56:14 +00:00
  • 87daae1143 Allow PL/Python functions to return void, per gripe from James Robinson (I didn't use his patch, however). A void-returning PL/Python function must return None (from Python), which is translated into a void datum (and *not* NULL) for Postgres. I also added some regression tests for this functionality. Neil Conway 2006-02-28 20:03:52 +00:00
  • c6b6f7ad64 Add: Bruce Momjian 2006-02-28 19:48:03 +00:00
  • 03024ca5a1 Add PG_VERSION_NUM for use by 3rd party applications wanting to test the backend version in C using > and < comparisons. Bruce Momjian 2006-02-28 16:41:21 +00:00
  • d2c555ee53 Teach nodeSort and nodeMaterial to optimize out unnecessary overhead when the passed-down eflags indicate they can. Simon Riggs and Tom Lane Tom Lane 2006-02-28 05:48:44 +00:00
  • 2c0ef9777c Extend the ExecInitNode API so that plan nodes receive a set of flag bits indicating which optional capabilities can actually be exercised at runtime. This will allow Sort and Material nodes, and perhaps later other nodes, to avoid unnecessary overhead in common cases. This commit just adds the infrastructure and arranges to pass the correct flag values down to plan nodes; none of the actual optimizations are here yet. I'm committing this separately in case anyone wants to measure the added overhead. (It should be negligible.) Tom Lane 2006-02-28 04:10:28 +00:00
  • 7f4f42fa10 Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in particular get rid of single quotes around language names and old WITH () construct. Peter Eisentraut 2006-02-27 16:09:50 +00:00
  • fe83b3ebc6 contrib uninstall scripts Peter Eisentraut 2006-02-27 12:54:39 +00:00
  • d46fbef386 Add mention that tid perhaps someday should be output as a record. Bruce Momjian 2006-02-27 01:41:16 +00:00
  • 909ca1407c Improve sorting speed by pre-extracting the first sort-key column of each tuple, as per my proposal of several days ago. Also, clean up sort memory management by keeping all working data in a separate memory context, and refine the handling of low-memory conditions. Tom Lane 2006-02-26 22:58:12 +00:00
  • e1f06d8057 Fix a few minor typos in comments in PL/Perl. Neil Conway 2006-02-26 22:26:39 +00:00
  • 52d010d857 Done: Bruce Momjian 2006-02-26 21:22:47 +00:00
  • 41cba49e95 Implement the <> operator for the tid type. Original patch from Mark Kirkwood, minor improvements by Neil Conway. The regression tests have been updated and the catversion has been bumped. Neil Conway 2006-02-26 18:36:23 +00:00
  • c5e0415a28 Minor SGML work: add some more hyperlinks, where appropriate. Neil Conway 2006-02-26 03:20:46 +00:00
  • 4d39c6bcf5 Fix typo in comment. Neil Conway 2006-02-26 02:23:41 +00:00
  • f33d3bc0bf TODO updates: Neil Conway 2006-02-26 01:21:57 +00:00
  • e6917b1255 Remove ora2pg; now available at <http://www.samse.fr/GPL/ora2pg/>. Peter Eisentraut 2006-02-25 19:18:58 +00:00
  • 305c82e6bb Add intervals: Bruce Momjian 2006-02-25 16:34:52 +00:00
  • 3952eecd4a Fix computation of sample table size. Bruce Momjian 2006-02-25 04:30:06 +00:00
  • 8c71af130c Fix computation of sample table size. Bruce Momjian 2006-02-25 04:28:54 +00:00
  • 8e8972832a Remove duplicate: Bruce Momjian 2006-02-25 03:40:14 +00:00
  • 032858216c Backpatch FAQ changes to 8.1.X. Bruce Momjian 2006-02-24 15:00:48 +00:00
  • 0915d370f5 Remove mention of MIN/MAX() not using indexes. Bruce Momjian 2006-02-24 14:59:54 +00:00
  • 39825338b4 Mention that the archive history file has the wal start/stop file names. Bruce Momjian 2006-02-24 14:03:11 +00:00
  • eb8f9cc066 Mention that the archive history file has the wal start/stop file names. Bruce Momjian 2006-02-24 14:03:01 +00:00
  • 268c1b6077 The Makefile was invoking perl scripts as ./script.pl. This fails when the script is not executable as UCS_to_most.pl is in CVS. It also won't pick up any custom setting of the perl version/location to use. This patch calls perl scripts like $(PERL) $(srcdir)/script.pl. Peter Eisentraut 2006-02-24 13:25:44 +00:00
  • 2b695717a7 Make restricted_exec feature for Windows more robust by using the environment to pass the flag instead of the command line - some implementations of getopt fail if getopt arguments are present after non-getopt arguments. Andrew Dunstan 2006-02-24 02:02:41 +00:00
  • b5fe16d09f make initdb -U username work as advertised; back out bogus patch at rev 1.42 and supply real fix for problem it tried to address. Andrew Dunstan 2006-02-24 00:55:49 +00:00
  • 400606f3a8 make initdb -U username work as advertised; back out bogus patch at rev 1.42 and supply real fix for problem it tried to address. Andrew Dunstan 2006-02-24 00:55:27 +00:00
  • 77e7b8923c make initdb -U username work as advertised; back out bogus patch at rev 1.42 and supply real fix for problem it tried to address. Andrew Dunstan 2006-02-24 00:54:27 +00:00
  • 05d2a7256e Fix vacuumlo to avoid unnecessary use of backslash in search pattern. Per Michael Fuhr. Tom Lane 2006-02-23 22:34:07 +00:00
  • f87d4875e9 Fix vacuumlo to avoid unnecessary use of backslash in search pattern. Per Michael Fuhr. Tom Lane 2006-02-23 22:33:59 +00:00
  • 737651f6be Cleanup the usage of ScanDirection: use the symbolic names for the possible ScanDirection alternatives rather than magic numbers (-1, 0, 1). Also, use the ScanDirection macros in a few places rather than directly checking whether `dir == ForwardScanDirection' and the like. Per patch from James William Pye. His patch also changed ScanDirection to be a "char" rather than an enum, which I haven't applied. Neil Conway 2006-02-21 23:01:54 +00:00
  • 6f96c539ed Fix old pg_dump oversight: default values for domains really need to be dumped by decompiling the typdefaultbin expression, not just printing the typdefault text which may be out-of-date or assume the wrong schema search path. (It's the same hazard as for adbin vs adsrc in column defaults.) The catalogs.sgml spec for pg_type implies that the correct procedure is to look to typdefaultbin first and consider typdefault only if typdefaultbin is NULL. I made dumping of both domains and base types do that, even though in the current backend code typdefaultbin is always correct for domains and typdefault for base types --- might as well try to future-proof it a little. Per bug report from Alexander Galler. Tom Lane 2006-02-21 18:01:41 +00:00
  • 3666260ffd Fix old pg_dump oversight: default values for domains really need to be dumped by decompiling the typdefaultbin expression, not just printing the typdefault text which may be out-of-date or assume the wrong schema search path. (It's the same hazard as for adbin vs adsrc in column defaults.) The catalogs.sgml spec for pg_type implies that the correct procedure is to look to typdefaultbin first and consider typdefault only if typdefaultbin is NULL. I made dumping of both domains and base types do that, even though in the current backend code typdefaultbin is always correct for domains and typdefault for base types --- might as well try to future-proof it a little. Per bug report from Alexander Galler. Tom Lane 2006-02-21 18:01:32 +00:00
  • a386cd7806 Adjust probe for getaddrinfo to cope with macro-ized definitions, such as Tru64's. Per previous discussion. Tom Lane 2006-02-21 06:07:10 +00:00