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

Commit Graph

  • 78ce809216 Postpone pg_timezone_initialize() until after creation of postmaster.pid, since it can take a fair amount of time and this can confuse boot scripts that expect postmaster.pid to appear quickly. Move initialization of SSL library and preloaded libraries to after that point, too, just for luck. Per reports from Tony Caduto and others. Tom Lane 2005-10-20 20:05:45 +00:00
  • c9de6b922e Document the behavior of GRANT/REVOKE in cases where the privilege is held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago. Tom Lane 2005-10-20 19:18:01 +00:00
  • 01145f963f Prevent core dump in contrib version of autovacuum when a table has been dropped. Per report from daveg (not his patch, though). Tom Lane 2005-10-20 16:14:47 +00:00
  • 09290098c5 Prevent core dump in contrib version of autovacuum when a table has been dropped. Per report from daveg (not his patch, though). Tom Lane 2005-10-20 16:14:39 +00:00
  • 7218aab7a2 Adjust not-too-sane calculation of DDD value for to_char(interval). Per gripe from Chris Matheson. Tom Lane 2005-10-20 15:59:46 +00:00
  • 8130cbce96 Clean up md5.c to make it clearer that it is a frontend-and-backend module. Don't rely on backend palloc semantics; in fact, best to not use palloc at all, rather than #define'ing it to malloc, because that just encourages errors of omission. Bug spotted by Volkan YAZICI, but I went further than he did to fix it. Tom Lane 2005-10-20 13:54:08 +00:00
  • a5bd1d357a Make \d order a table's check constraints by constraint name instead of the text of the constraint condition. Per Chris K-L, though I didn't use his patch exactly. Tom Lane 2005-10-20 05:15:09 +00:00
  • 52e98f8415 Don't convert debug/notice/warning messages into errors just because they occur inside error processing. This is a back-port of a logic change already present in 8.0. Partial fix for bug#1976 --- doesn't cure the wrong-encoding problem, but at least stops it from causing unintended ERRORs. Tom Lane 2005-10-20 01:31:50 +00:00
  • fd5efffc15 Back-patch fix for proper labeling of whole-row Datums generated from subquery results. Tom Lane 2005-10-19 22:51:26 +00:00
  • d9cb48786e Better solution to the problem of labeling whole-row Datums that are generated from subquery outputs: use the type info stored in the Var itself. To avoid making ExecEvalVar and slot_getattr more complex and slower, I split out the whole-row case into a separate ExecEval routine. Tom Lane 2005-10-19 22:30:30 +00:00
  • 07908c9c37 Ensure that the Datum generated from a whole-row Var contains valid type ID information even when it's a record type. This is needed to handle whole-row Vars referencing subquery outputs. Per example from Richard Huxton. Tom Lane 2005-10-19 18:18:33 +00:00
  • 32fcfcdbd6 Fix oversight in recent changes to enable the 'physical tlist' optimization for subquery and function scan nodes: we can't just do it unconditionally, we still have to check whether there is any need for a whole-row Var. I had been thinking that these node types couldn't have any system columns, which is true, but that loop is also checking for attno zero, ie, whole-row Var. Fix comment to not be so misleading. Per test case from Richard Huxton. Tom Lane 2005-10-19 17:31:20 +00:00
  • b33a732264 Improve trace_sort code to also show the total memory or disk space used. Per request from Marc. Tom Lane 2005-10-18 22:59:37 +00:00
  • 48f3d77858 replace use of predefined perl vars $a and $b with $x and $y - per Greg Sabino Mullane Andrew Dunstan 2005-10-18 22:53:54 +00:00
  • a33fadfd6d Add an entry to the discussion of regression test failures about the possibility of a failure due to stack overflow when max_stack_depth is not set properly for the platform. Tom Lane 2005-10-18 21:43:33 +00:00
  • 220f2a7d15 Code review for regexp_replace patch. Improve documentation and comments, fix problems with replacement-string backslashes that aren't followed by one of the expected characters, avoid giving the impression that replace_text_regexp() is meant to be called directly as a SQL function, etc. Tom Lane 2005-10-18 20:38:58 +00:00
  • 800af89004 Code review for spi_query/spi_fetchrow patch: handle errors sanely, avoid leaking memory. I would add a regression test for error handling except it seems eval{} can't be used in unprivileged plperl :-( Tom Lane 2005-10-18 17:13:14 +00:00
  • 056eb1412c When a cursor is opened using dblink_open, only start a transaction if there isn't one already open. Upon dblink_close, only commit the open transaction if it was started by dblink_open, and only then when all cursors opened by dblink_open are closed. The transaction accounting is done individually for all named connections, plus the persistent unnamed connection. Joe Conway 2005-10-18 02:55:49 +00:00
  • c62b29a603 Fix several contrib makefiles that failed in VPATH builds, particularly when not using gcc (which has slightly nonstandard inclusion rules). Tom Lane 2005-10-18 01:30:49 +00:00
  • 23836fb1fb A few trivial code cleanups motivated by reading warnings generated by a recent HP C compiler. Mostly, get rid of useless local variables that are assigned to but never used. Tom Lane 2005-10-18 01:06:24 +00:00
  • d330f1554d Clean up libpq's pollution of application namespace by renaming the exported routines of ip.c, md5.c, and fe-auth.c to begin with 'pg_'. Also get rid of the vestigial fe_setauthsvc/fe_getauthsvc routines altogether. Tom Lane 2005-10-17 16:24:20 +00:00
  • 8ffdcbf23b Add note that some versions of OS X require SHMMAX to be an exact multiple of 4096. Also add comment explaining why we don't suggest using /etc/sysctl.conf to avoid needing to edit /etc/rc. Tom Lane 2005-10-16 21:22:12 +00:00
  • 649e74bf90 Add space after description. Bruce Momjian 2005-10-16 18:26:00 +00:00
  • 98d5f4e574 kerberos error message: localhost -> server hostname Bruce Momjian 2005-10-15 21:27:19 +00:00
  • ad148c4154 Suppress warnings on platforms where fprintf is a macro (eg, recent Fedora). This was already done by somebody for the core flex files, but these contrib files seem to have been missed. Tom Lane 2005-10-15 20:37:36 +00:00
  • b562639561 Fix bogus error test in get_ti_Oid(). Tom Lane 2005-10-15 20:28:59 +00:00
  • 0631059c9c Fix unportable struct initializations. Tom Lane 2005-10-15 20:24:00 +00:00
  • 2c19629f93 Remove a long comment from cvs.sgml -- AFAICS this is no longer useful, or at any rate doesn't belong as a comment in a random SGML file. Neil Conway 2005-10-15 20:15:48 +00:00
  • fc8f4bac0e Fix assorted typos in the documentation, and use American spelling rather than British. Patch from Michael Fuhr. Neil Conway 2005-10-15 20:12:33 +00:00
  • e4cd186608 Fix thinko in pg_read_file: testing for negative result is not the way to determine whether fread() failed. Tom Lane 2005-10-15 19:47:09 +00:00
  • 6faa334bef Update 'supported platforms' list with current buildfarm results. Tom Lane 2005-10-15 17:59:38 +00:00
  • d62616e6ca Fix kerberos description: localhost -> server hostname. Bruce Momjian 2005-10-15 15:29:24 +00:00
  • 1dc3498251 Standard pgindent run for 8.1. Bruce Momjian 2005-10-15 02:49:52 +00:00
  • 790c01d280 Update pgindent typedef list. Bruce Momjian 2005-10-15 02:14:22 +00:00
  • 1d2e0e6d3e Merge some user-submitted suggestions for improvement into the documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs. Neil Conway 2005-10-15 01:47:12 +00:00
  • 1b5cd6dcdc Fix typo. Alvaro Herrera 2005-10-15 01:15:33 +00:00
  • abd3f43b4c Fix syslog bug: if any messages are emitted to write_syslog before the facility has been set, the facility gets set to LOCAL0 and cannot be changed later. This seems reasonably plausible to happen, particularly at higher debug log levels, though I am not certain it explains Han Holl's recent report. Easiest fix is to teach the code how to change the value on-the-fly, which is nicer anyway. I made the settings PGC_SIGHUP to conform with log_destination. Tom Lane 2005-10-14 20:53:56 +00:00
  • f620098dc8 fix nonsensical summary row on example Andrew Dunstan 2005-10-14 20:48:18 +00:00
  • 0fa322a14e Pass a strdup'd ident string to openlog(), to ensure that reallocation of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog. Tom Lane 2005-10-14 16:41:41 +00:00
  • a4baf229a4 Pass a strdup'd ident string to openlog(), to ensure that reallocation of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog. Tom Lane 2005-10-14 16:41:28 +00:00
  • 98658dd404 Pass a strdup'd ident string to openlog(), to ensure that reallocation of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog. Tom Lane 2005-10-14 16:41:13 +00:00
  • 4aa0d70fb7 Pass a strdup'd ident string to openlog(), to ensure that reallocation of GUC memory doesn't cause us to start emitting a bogus ident string. Per report from Han Holl. Also some trivial code cleanup in write_syslog. Tom Lane 2005-10-14 16:41:02 +00:00
  • a93bf4503f Allow times of 24:00:00 to match rounding behavior: Bruce Momjian 2005-10-14 11:47:57 +00:00
  • e257f28db0 [ Backpatch to 7.4.X.] Bruce Momjian 2005-10-14 01:50:58 +00:00
  • 7df6dfdda7 [ Backpatch to 8.0.X.] Bruce Momjian 2005-10-14 01:50:23 +00:00
  • dbc214f7e6 Add documentation mentioning that there are separate regression tests for the PL languages and for contrib. Tom Lane 2005-10-13 23:41:07 +00:00
  • 412734767a Improve documentation about CREATEROLE privilege. Tom Lane 2005-10-13 23:26:00 +00:00
  • 35c8983371 Fix uppercase TRUE/FALSE that are WIN32 stuffl. Bruce Momjian 2005-10-13 23:22:11 +00:00
  • 186bbaab06 Update regression output for new prepare transaction error messages. Bruce Momjian 2005-10-13 23:12:04 +00:00
  • 2d8e3d1d71 Make stack_base_ptr non-static, for PL/Java. Bruce Momjian 2005-10-13 22:57:27 +00:00
  • 1d028537a2 This makes the error messages for PREPARE TRANSACTION, COMMIT PREPARED etc. match the docs, which talk about "transaction identifier" not "gid" or "global transaction identifier". Bruce Momjian 2005-10-13 22:55:55 +00:00
  • 5aae047e23 Update krb_server_name to document that a missing entry defaults to 'localhost'. Bruce Momjian 2005-10-13 22:55:19 +00:00
  • f91370cd2f Update documentation to reflect the new ALTER OWNER rules for all affected types of objects. Tom Lane 2005-10-13 22:44:51 +00:00
  • a9980ec37b Describe the behavior of the SQL_ASCII encoding more accurately. Tom Lane 2005-10-13 21:43:43 +00:00
  • 6f9cb4eb43 Adjust the discussion of triggers to more clearly guide people in the direction of writing triggers in a procedural language, rather than C. Per discussion. Tom Lane 2005-10-13 21:09:38 +00:00
  • 8ac386226d The patch updates the documentation to reflect the fact that higher values of client_min_messages (fatal + panic) are valid and also fixes a slight issue with how psql tried to display error messages that aren't sent to the client. Bruce Momjian 2005-10-13 20:58:42 +00:00
  • 4784794279 Enable threaded python builds on freebsd5, per report from Jim C. Nasby Bruce Momjian 2005-10-13 20:40:04 +00:00
  • 12ee2b98ce Turn off list of tables, figures, and examples. Peter Eisentraut 2005-10-13 20:10:03 +00:00
  • a0fc05aa6e Go back to emitting path names with forward slashes on Windows. I'm not clear on what the double-backslash idea was intended to fix, but it breaks at least mingw GNU Make. Per report from Thomas Hallgren. Tom Lane 2005-10-13 17:58:44 +00:00
  • 84cc9a4bb3 Back out this because of fear of changing error strings: Bruce Momjian 2005-10-13 17:57:57 +00:00
  • 90c22c9206 This makes the error messages for PREPARE TRANSACTION, COMMIT PREPARED etc. match the docs, which talk about "transaction identifier" not "gid" or "global transaction identifier". Bruce Momjian 2005-10-13 17:57:17 +00:00
  • 6d62338d5e Rewording, use the more common multi-threaded/single-threaded. Bruce Momjian 2005-10-13 17:55:18 +00:00
  • 8fc0aa4cca Clarify causes of possible mismatch between Win32 libraries and applications that use FILE pointers. Bruce Momjian 2005-10-13 17:46:18 +00:00
  • 165565cd94 Some additional doc changes based around compression of page images in WAL and the interaction of the new full_page_writes parameter with PITR. Bruce Momjian 2005-10-13 17:32:42 +00:00
  • 3af21fa568 Mark xslt_process() as volatile. Bruce Momjian 2005-10-13 16:10:14 +00:00
  • 32e6c2a160 Use get_progname() in backend main.c, rather than port-specific hack that is too fragile. Bruce Momjian 2005-10-13 15:37:14 +00:00
  • 203015ebdd Fix small oversight in recent patch to add more CREATE-FUNCTION-time syntax checking to plpgsql: check_sql_expr() wasn't being called by make_select_stmt(), so that there was no SQL syntax check for SELECT statements. Tom Lane 2005-10-13 15:34:19 +00:00
  • 40e1b30f63 Change xpath_table() and xslt_process() from IMMUTABLE to STABLE. Bruce Momjian 2005-10-13 14:58:33 +00:00
  • 7d43349ab5 Fix capitalization of example. Bruce Momjian 2005-10-13 14:44:58 +00:00
  • c10dba2fe3 Remove an antiquated comment. Neil Conway 2005-10-13 06:24:05 +00:00
  • 689c815b09 Add a comment describing the requirement that pointers into shared memory that is protected by a spinlock must be volatile, per recent discussion. Neil Conway 2005-10-13 06:17:34 +00:00
  • 4a6dcf0322 Update trigger demo to reflect new trigger ordering. Bruce Momjian 2005-10-13 02:23:12 +00:00
  • 3d50e107ad Remove extra <para> Bruce Momjian 2005-10-13 02:00:09 +00:00
  • 249f07b8c6 Update: Bruce Momjian 2005-10-13 01:23:49 +00:00
  • 1e9a6ba5e6 Don't try to remove duplicate OR-subclauses in create_bitmap_subplan and make_restrictinfo_from_bitmapqual. The likelihood of finding duplicates seems much less than in the AND-subclause case, and the cost much higher, because OR lists with hundreds or even thousands of subclauses are not uncommon. Per discussion with Ilia Kantor and andrew@supernews. Tom Lane 2005-10-13 00:06:46 +00:00
  • 23e2f9ebf7 Fix spelling error, per Michael Fuhr. Tom Lane 2005-10-12 23:19:22 +00:00
  • adc58f145c Remove item: Bruce Momjian 2005-10-12 22:39:35 +00:00
  • 10f14e6e0d Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would mark the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug. Tom Lane 2005-10-12 17:18:45 +00:00
  • 5c05d165af Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would mark the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug. Tom Lane 2005-10-12 17:18:31 +00:00
  • 00de66a3b4 Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would mark the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug. Tom Lane 2005-10-12 17:18:15 +00:00
  • e952ae1268 Fix longstanding bug found by Atsushi Ogawa: _bt_check_unique would mark the wrong buffer dirty when trying to kill a dead index entry that's on a page after the one it started on. No risk of data corruption, just inefficiency, but still a bug. Tom Lane 2005-10-12 17:18:03 +00:00
  • fa72121594 Fix another recently-changed place that was messing with spinlock- protected data structures and not using a volatile pointer for same. Tom Lane 2005-10-12 16:55:59 +00:00
  • 07eeb9d109 Do all accesses to shared buffer headers through volatile-qualified pointers, to ensure that compilers won't rearrange accesses to occur while we're not holding the buffer header spinlock. It's probably not necessary to mark volatile in every single place in bufmgr.c, but better safe than sorry. Per trouble report from Kevin Grittner. Tom Lane 2005-10-12 16:45:14 +00:00
  • 6b97e437ca Add warning about plperl nested named subroutines Bruce Momjian 2005-10-12 14:28:33 +00:00
  • 0a28eb4622 No longer needed: Bruce Momjian 2005-10-12 14:06:46 +00:00
  • 4aebb5ad55 Rearrange: Bruce Momjian 2005-10-12 13:41:08 +00:00
  • d5310ca920 Done: Bruce Momjian 2005-10-12 13:39:51 +00:00
  • 87a67d186b Add: Bruce Momjian 2005-10-12 13:39:21 +00:00
  • 4102640683 Update keywords table for 8.1. Peter Eisentraut 2005-10-12 09:45:29 +00:00
  • 752290207d Add description: Bruce Momjian 2005-10-12 03:26:38 +00:00
  • 368f0b28f3 Add: Bruce Momjian 2005-10-12 02:57:42 +00:00
  • e4aa5be90c Add: Bruce Momjian 2005-10-11 23:55:10 +00:00
  • 9fa7ba3041 must commit *after* autoconf, not before REL8_1_0BETA3 PostgreSQL Daemon 2005-10-11 23:27:46 +00:00
  • 5f470ad491 update to beta3 before tagging ... PostgreSQL Daemon 2005-10-11 23:26:43 +00:00
  • 25a5b740cd Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser. Neil Conway 2005-10-11 23:00:39 +00:00
  • 592ca3cf06 Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser. Neil Conway 2005-10-11 22:59:11 +00:00
  • 6f8236f1b5 Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser. Neil Conway 2005-10-11 22:58:15 +00:00
  • 96a83d8807 Release notes up to date as of today. Tom Lane 2005-10-11 21:17:11 +00:00
  • a72ee09090 Add infrastructure for making spins_per_delay variable depending on whether we seem to be running in a uniprocessor or multiprocessor. The adjustment rules could probably still use further tweaking, but I'm convinced this should be a win overall. Tom Lane 2005-10-11 20:41:32 +00:00
  • 9907b9775b Don't use a non-locked pre-test of the spinlock on x86_64 machines. The pre-test has been shown to be a big loss on Opterons and at best a wash on EM64T. Tom Lane 2005-10-11 20:01:30 +00:00