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

Commit Graph

  • 95af2633c3 Add mention to update FAQ item on most recent release to RELEASE_CHANGES. Bruce Momjian 2005-11-05 01:38:44 +00:00
  • 56f68ed907 Backpatch FAQ's for 8.0.X. Bruce Momjian 2005-11-05 01:36:42 +00:00
  • 75a429463a Update FAQ for most recent release as 8.1. Bruce Momjian 2005-11-05 01:35:18 +00:00
  • 9ba4c42401 Yet another supported-platforms update. Tom Lane 2005-11-05 00:04:04 +00:00
  • fd68553860 Editorial review for partitioning/constraint exclusion documentation. Tom Lane 2005-11-04 23:53:18 +00:00
  • 58d6316d50 Improve description of constraint_exclusion variable. Tom Lane 2005-11-04 23:50:30 +00:00
  • 8959e9b9d3 Translation updates Peter Eisentraut 2005-11-04 23:31:12 +00:00
  • 39dfbe5791 Spellchecking run, final cleanups Peter Eisentraut 2005-11-04 23:14:02 +00:00
  • 1630571a04 Update release notes for 8.1. Bruce Momjian 2005-11-04 22:21:33 +00:00
  • 6ec1ec6684 Remove a gratuitous string difference (does not affect translations). Peter Eisentraut 2005-11-04 22:19:04 +00:00
  • 9e1843c7ee Fix logical error in option description. Peter Eisentraut 2005-11-04 22:18:26 +00:00
  • 6d8476ab3b Ensure that we only create one ConsoleCtrlHandler per psql process, so as to avoid performance issues and possible ultimate crash on long psql scripts. Per Merlin Moncure. Tom Lane 2005-11-04 18:35:51 +00:00
  • af331e2526 Ensure that we only create one ConsoleCtrlHandler per psql process, so as to avoid performance issues and possible ultimate crash on long psql scripts. Per Merlin Moncure. Tom Lane 2005-11-04 18:35:40 +00:00
  • 081ed99b1e We haven't seen any agreement emerge as to what is causing AIX 5.3 ML3 to fail to successfully build the release candidates. Bruce Momjian 2005-11-04 18:16:50 +00:00
  • c3d8de0907 Disregard superuserness when checking to see if a role GRANT would create circularity of role memberships. This is a minimum-impact fix for the problem reported by Florian Pflug. I thought about removing the superuser_arg test from is_member_of_role() altogether, as it seems redundant for many of the callers --- but not all, and it's way too late in the 8.1 cycle to be making large changes. Perhaps reconsider this later. Tom Lane 2005-11-04 17:25:15 +00:00
  • e47ea0566c Update supported-platforms list. Tom Lane 2005-11-04 16:15:20 +00:00
  • 03381695c6 Avoid referring to a specific version of the SQL standard except where necessary, and be careful to refer to the right version where it is useful to do so. This partially reverts an ill-considered search and replace from a few months ago. Tom Lane 2005-11-04 02:56:31 +00:00
  • 60945aaf41 Fix a couple of missed None -> DestNone in comments. Tom Lane 2005-11-03 21:35:57 +00:00
  • 66294e13fb Fix one overlooked ocurrence of "None" in EXEC_BACKEND block. Alvaro Herrera 2005-11-03 20:02:50 +00:00
  • 6812abb673 Fix incorrect header size macros Teodor Sigaev 2005-11-03 18:16:31 +00:00
  • 0c1a3f94c6 Fix incorrect header size macros Teodor Sigaev 2005-11-03 18:15:47 +00:00
  • fb30ac54e6 Thinking further, it seems we had better also copy down resorigtbl/resorigcol to ensure that SubqueryScan elimination doesn't change the behavior of reporting of original column sources. Tom Lane 2005-11-03 17:45:29 +00:00
  • abf293e155 Fix the recently-added code that eliminates unnecessary SubqueryScan nodes from a finished plan tree. We have to copy the output column names (resname fields) from the SubqueryScan down to its child plan node; else, if this is the topmost level of the plan, the wrong column names will be delivered to the client. Per bug #2017 reported by Jolly Chen. Tom Lane 2005-11-03 17:34:03 +00:00
  • 902377c465 Rename the members of CommandDest enum so they don't collide with other uses of those names. (Debug and None were pretty bad names anyway.) I hope I catched all uses of the names in comments too. Alvaro Herrera 2005-11-03 17:11:40 +00:00
  • 76c9ac8ebb Translation updates. Alvaro Herrera 2005-11-03 17:00:54 +00:00
  • da9fc25909 pgcrypto documentation polishing from Marko Kreen, and a small amount of copy-editing from myself. Tom Lane 2005-11-03 02:54:07 +00:00
  • 8bd1cbb86d Some minor improvements to the CE docs. Also fix a bit of SGML markup elsewhere. Neil Conway 2005-11-03 00:51:43 +00:00
  • 237afd453f Fix longstanding race condition in transaction log management: there was a very narrow window in which SimpleLruReadPage or SimpleLruWritePage could think that I/O was needed when it wasn't (and indeed the buffer had already been assigned to another page). This would result in an Assert failure if Asserts were enabled, and probably in silent data corruption if not. Reported independently by Jim Nasby and Robert Creager. Tom Lane 2005-11-03 00:23:57 +00:00
  • 74f224fad4 Fix longstanding race condition in transaction log management: there was a very narrow window in which SimpleLruReadPage or SimpleLruWritePage could think that I/O was needed when it wasn't (and indeed the buffer had already been assigned to another page). This would result in an Assert failure if Asserts were enabled, and probably in silent data corruption if not. Reported independently by Jim Nasby and Robert Creager. Tom Lane 2005-11-03 00:23:50 +00:00
  • 09048b95e7 Fix longstanding race condition in transaction log management: there was a very narrow window in which SimpleLruReadPage or SimpleLruWritePage could think that I/O was needed when it wasn't (and indeed the buffer had already been assigned to another page). This would result in an Assert failure if Asserts were enabled, and probably in silent data corruption if not. Reported independently by Jim Nasby and Robert Creager. Tom Lane 2005-11-03 00:23:43 +00:00
  • 99d48695d4 Fix longstanding race condition in transaction log management: there was a very narrow window in which SimpleLruReadPage or SimpleLruWritePage could think that I/O was needed when it wasn't (and indeed the buffer had already been assigned to another page). This would result in an Assert failure if Asserts were enabled, and probably in silent data corruption if not. Reported independently by Jim Nasby and Robert Creager. Tom Lane 2005-11-03 00:23:36 +00:00
  • ced9dd3699 Add Tomoaki Sato to pgbench changes in release notes. Bruce Momjian 2005-11-02 14:08:43 +00:00
  • eddcd492fe Add some documentation for constraint exclusion and basic partitioning. From Simon Riggs; cleanup and editorialization by Neil Conway. Neil Conway 2005-11-01 23:19:05 +00:00
  • b524cb36ac Make an editorial pass over the reference pages. Tom Lane 2005-11-01 21:09:51 +00:00
  • 0622b1d738 Provide a --no-locale option for pg_regress and a corresponding NOLOCALE=1 setting for the regression makefile, allowing Windows users to force locale settings since Windows does not get its locale from the environment. Andrew Dunstan 2005-11-01 15:32:52 +00:00
  • cad0e824a0 Provide a --no-locale option for pg_regress and a corresponding NOLOCALE=1 setting for the regression makefile, allowing Windows users to force locale settings since Windows does not get its locale from the environment. Andrew Dunstan 2005-11-01 15:09:11 +00:00
  • 37a4232a0c Update supported-platforms entry for Tru64. Tom Lane 2005-10-31 21:12:35 +00:00
  • ee72793a91 Mention in the docs that temporary/non-temp tables can not share referential integrity relationships. Bruce Momjian 2005-10-31 18:13:52 +00:00
  • 1dd6bd19fa Add sanity check of query Teodor Sigaev 2005-10-31 13:47:09 +00:00
  • 90456d1303 Update supported-platforms list. Tom Lane 2005-10-30 19:21:42 +00:00
  • d8247b0f50 tag it for rc1 REL8_1_0RC1 PostgreSQL Daemon 2005-10-30 05:06:03 +00:00
  • 9c67981683 Fix psql ref typo. Bruce Momjian 2005-10-30 03:01:49 +00:00
  • 9ee0a7df50 Fix some allocation size calculation errors that would cause pgbench to fail with large test scripts. Tom Lane 2005-10-29 19:38:07 +00:00
  • 4a57a4575a Update a couple of obsolete comments. Tom Lane 2005-10-29 18:39:17 +00:00
  • 9b0a164833 Translation updates Peter Eisentraut 2005-10-29 00:41:37 +00:00
  • 07bb9f086b Message corrections Peter Eisentraut 2005-10-29 00:31:52 +00:00
  • a7335a3401 Update supported-platforms list. Tom Lane 2005-10-28 20:01:40 +00:00
  • 65a99590ab Fix broken markup. Tom Lane 2005-10-28 20:00:03 +00:00
  • a037926295 Reorder code so that we don't have to hold a critical section while reserving SLRU space for a new MultiXact. The original coding would have treated out-of-disk-space as a PANIC condition, which is unnecessary. Tom Lane 2005-10-28 19:00:19 +00:00
  • a7de22d8d5 Clean up AIX build to avoid 'duplicate symbol' warnings, by moving use of postgres.imp file into BE_DLLLIBS macro. This makes the AIX build work more like the Windows and Darwin builds, which have similar requirements to mention a backend library when linking shared libraries that will be dynamically loaded into the backend. Tom Lane 2005-10-28 17:32:22 +00:00
  • 1986ca5ce5 Fix race condition in multixact code: it's possible to try to read a multixact's starting offset before the offset has been stored into the SLRU file. A simple fix would be to hold the MultiXactGenLock until the offset has been stored, but that looks like a big concurrency hit. Instead rely on knowledge that unset offsets will be zero, and loop when we see a zero. This requires a little extra hacking to ensure that zero is never a valid value for the offset. Problem reported by Matteo Beccati, fix ideas from Martijn van Oosterhout, Alvaro Herrera, and Tom Lane. Tom Lane 2005-10-28 17:27:29 +00:00
  • 21b748e76a 1 Fix problem with lost precision in rank with OR-ed lexemes 2 Allow tsquery_in to input void tsquery: resolve dump/restore problem with tsquery Teodor Sigaev 2005-10-28 13:05:06 +00:00
  • fbff2e9607 Remove mention that \x doesn't affect backslash commands. Bruce Momjian 2005-10-28 02:39:07 +00:00
  • 97b8013db5 Add an ifneq to avoid make warning on AIX --- there is a separate rule for postgres: on line 86, and line 43 shouldn't be used. Noted while looking at kookaburra buildfarm results. Tom Lane 2005-10-27 20:45:29 +00:00
  • fbbe00242d Tweak buffer manager so that 'internal' accesses to a buffer do not advance its usage_count. This includes writes of dirty buffers triggered by bgwriter, checkpoint, or FlushRelationBuffers, as well as various corner cases that really ought not count as accesses to the page. Should make for some marginal improvement in the quality of our decisions about when to recycle buffers. Per suggestion from ITAGAKI Takahiro. Tom Lane 2005-10-27 17:07:58 +00:00
  • bc93b3741d Update: Bruce Momjian 2005-10-27 14:16:05 +00:00
  • befc607dee Add: Bruce Momjian 2005-10-27 14:07:29 +00:00
  • 6859d8c141 Add mention that .pgpass localhost matches tcp and unix domain sockets. Bruce Momjian 2005-10-27 13:53:41 +00:00
  • 0849955f3a Add mention of errfinish. Bruce Momjian 2005-10-27 13:48:14 +00:00
  • 3332e38189 Disable expanded mode only for \d tablename, not for all backslash commands. Per complaint that \df+ is clearer in expanded mode. Bruce Momjian 2005-10-27 13:34:47 +00:00
  • 69f16b562a Add comment documenting actual failure case of using interval_justify_hours in timestamp subtraction. TODO already has text description. Bruce Momjian 2005-10-27 02:45:22 +00:00
  • 807da29cf3 Add items from Tom: Bruce Momjian 2005-10-27 02:33:31 +00:00
  • 4a309defb4 Add info about using rsync to make base backups. Per report from Jeff Frost, it may be necessary to ignore specific exit codes. Tom Lane 2005-10-26 20:42:35 +00:00
  • fc5894bf77 Adjust parser so that POSTQUEL-style implicit RTEs are stored with inFromCl true, meaning that they will list out as explicit RTEs if they are in a view or rule. Update comments about inFromCl to reflect the way it's now actually used. Per recent discussion. Tom Lane 2005-10-26 19:21:55 +00:00
  • c3d56155d4 Properly update the 'group' flatfile when modifying the user, in case they were added to a group. Also fix visibility of our own changes when creating the group file. This fixes: Bruce Momjian 2005-10-26 13:43:28 +00:00
  • 8f03406ee9 Update AIX FAQ, backpatch. Bruce Momjian 2005-10-26 13:20:47 +00:00
  • 7d9ff58b22 Rename config section headings. Bruce Momjian 2005-10-26 12:55:07 +00:00
  • aaaacf0f6c Fix longstanding bug that would sometimes let the planner generate a bad plan for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier. Tom Lane 2005-10-25 20:30:52 +00:00
  • fcd978c57d Fix longstanding bug that would sometimes let the planner generate a bad plan for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier. Tom Lane 2005-10-25 20:30:45 +00:00
  • 15b46f121f Fix longstanding bug that would sometimes let the planner generate a bad plan for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier. Tom Lane 2005-10-25 20:30:35 +00:00
  • ddb4015ec0 Fix longstanding bug that would sometimes let the planner generate a bad plan for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier. Tom Lane 2005-10-25 20:30:30 +00:00
  • 62cfa0f75c Add: Bruce Momjian 2005-10-25 18:50:56 +00:00
  • 602007842c Convert explanation of interval change into something resembling grammatical English, and fix the incorrect example. Tom Lane 2005-10-25 17:54:30 +00:00
  • 6a9b93a0e1 Remove justify_hours call from interval_mul and interval_div, and make some small stylistic improvements in these functions. Also fix several places where TMODULO() was being used with wrong-sized quotient argument, creating a risk of overflow --- interval2tm was actually capable of going into an infinite loop because of this. Tom Lane 2005-10-25 17:13:07 +00:00
  • c78f3039f2 Small grammar correction. Tom Lane 2005-10-25 15:47:51 +00:00
  • 25777f6fd3 Fix Windows setitimer() emulation to not depend on delivering an APC to the main thread. This allows removal of WaitForSingleObjectEx() calls from the main thread, thereby allowing us to re-enable Qingqing Zhou's CHECK_FOR_INTERRUPTS performance improvement. Qingqing, Magnus, et al. Tom Lane 2005-10-25 15:15:16 +00:00
  • b83547201f Update 24 hours/1 day distinction in release notes. Bruce Momjian 2005-10-25 15:12:22 +00:00
  • 9ee8b9fd38 Change trace_sort to output to the log, rather than the user's terminal. Bruce Momjian 2005-10-25 13:47:08 +00:00
  • 352a7841bf Update the URL for "The Hitch-Hiker's Guide to Evolutionary Computation". Bruce Momjian 2005-10-25 13:38:09 +00:00
  • 404bc385d1 IBM has addressed the socket address storage issue as of AIX 5.3 maintenance level 5300-03; the following patch adds documentation to FAQ_AIX. Bruce Momjian 2005-10-24 22:30:35 +00:00
  • 9507b56031 Add: Bruce Momjian 2005-10-24 18:08:52 +00:00
  • 42b689aed4 More forcefully recommend MD5 over crypt authentication. Bruce Momjian 2005-10-24 15:49:54 +00:00
  • 24fa8746ae Fix incorrect wording about function failure time on unsafe ops - these are now caught by the validator. And a small visit from the perl style police: check the return value from open(). Andrew Dunstan 2005-10-24 15:39:50 +00:00
  • 819159709f I have applied the following patch to document PQinitSSL() and PQregisterThreadLock(). Bruce Momjian 2005-10-24 15:38:37 +00:00
  • 18feafcc59 Ensure that a plpgsql LOOP with an empty body still executes at least one CHECK_FOR_INTERRUPTS() call, so that you can control-C out of the loop. Reported by Merlin Moncure. Tom Lane 2005-10-24 15:10:22 +00:00
  • 7d3ab8ac55 A bit of minor copy-editing. Tom Lane 2005-10-23 19:29:49 +00:00
  • 55337e40b3 I've confirmed 8.1beta4 passes regression tests on all hardware platforms of RHEL 4. Update supported-platforms list accordingly. Tom Lane 2005-10-23 18:30:49 +00:00
  • 106388fbe8 update configure and bugtemplate for beta 4 ... REL8_1_0BETA4 PostgreSQL Daemon 2005-10-22 22:46:33 +00:00
  • c3a7b0577b Add a note about GNU tar's propensity to complain if a file changes while tar is copying it. This behavior is unhelpful when taking a base backup. Per gripe from Pallav Kalva back in April. Tom Lane 2005-10-22 22:09:49 +00:00
  • f72a342fb7 Copy-editing for recent documentation changes relevant to WAL, full_page_writes, etc. Tom Lane 2005-10-22 21:56:07 +00:00
  • 6d6c3722fb Make code for selecting default WAL sync method less confusing. Tom Lane 2005-10-22 20:27:17 +00:00
  • 96b85f1ccb Fix documentation to specify the correct range of timezone offsets for type time with time zone, ie, +/- 13:59 not +/- 12:00. Also some minor wording improvements. Tom Lane 2005-10-22 19:33:57 +00:00
  • 4d20df3c78 Temporarily disable Qingqing's Windows signal processing patch, so that WaitForSingleObjectEx is always called by CHECK_FOR_INTERRUPTS. This should be reinstated but the setitimer() emulation will have to be redesigned first. Tom Lane 2005-10-22 17:09:48 +00:00
  • 63aa492466 Fix typo. Alvaro Herrera 2005-10-22 14:44:35 +00:00
  • 188c52497d minor code cleanup - replace useless struct timezone argument to gettimeofday with NULL in a few places, making it consistent with usage elsewhere. Andrew Dunstan 2005-10-22 14:27:29 +00:00
  • 6aad07d270 Improve performance of CHECK_FOR_INTERRUPTS() macro on Windows by not doing a kernel call unless there's some evidence of a pending signal. This should bring its performance on Windows into line with the Unix version. Problem diagnosis and patch by Qingqing Zhou. Minor stylistic tweaks by moi ... if it's broken, it's my fault. Tom Lane 2005-10-21 21:43:46 +00:00
  • fdff883aca Clean up autovacuum documentation, which was a bit out of sync with what the code actually does, and needed copy-editing anyway. Also take the opportunity to expand the section on routine reindexing. Tom Lane 2005-10-21 19:39:08 +00:00
  • 9fc24f2bf6 Fix EXPLAIN ANALYZE bug noted by Wiebe Cazemier: although we were properly advancing the CommandCounter between multiple sub-queries generated by rules, we forgot to update the snapshot being used, so that the successive sub-queries didn't actually see each others' results. This is still not *exactly* like the semantics of normal execution of the same queries, in that we don't take new transaction snapshots and hence don't see changes from concurrently committed commands, but I think that's OK and probably even preferable for EXPLAIN ANALYZE. Tom Lane 2005-10-21 16:43:33 +00:00
  • ef3b7cd328 Add an implicit cast from varchar to regclass, so that existing code of the form nextval('foo'::varchar) doesn't break. Per gripe from Jean-Pierre Pelletier. Initdb forced :-( Tom Lane 2005-10-21 15:45:06 +00:00
  • 5aad28a104 Add missing PQinitSSL and PQregisterThreadLock to exports.txt. Tom Lane 2005-10-21 15:21:21 +00:00