summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2003-04-04Back-patch changes to validate page header fields immediately afterTom Lane
reading in any page. Also back-port the zero_damaged_pages boolean that determines what to do about it.
2003-04-03Repair incorrect checking of grouped/ungrouped variables in the presenceTom Lane
of unnamed joins; per pghackers discussion 31-Mar-03.
2003-04-02Fix buffer overrun in to_ascii(), per report from Guido Notari.Tom Lane
2003-03-31Please, apply patch for contrib/ltree to current CVS and 7.3.2Bruce Momjian
CHANGES Mar 28, 2003 Added finctions index(ltree,ltree,offset), text2ltree(text), ltree2text(text) Teodor Sigaev
2003-03-31TestConfiguration returns int, not bool. This mistake is relativelyTom Lane
harmless on signed-char machines but would lead to core dump in the deadlock detection code if char is unsigned. Amazingly, this bug has been here since 7.1 and yet wasn't reported till now. Thanks to Robert Bruccoleri for providing the opportunity to track it down.
2003-03-30Properly document default value of log_min_error_statement in postgresql.conf.Bruce Momjian
2003-03-30Backpatch SSL return value changes.Bruce Momjian
2003-03-29[ Backpatch to 7.3.X.]Bruce Momjian
typing error in src/backend/libpq/be-secure.c ??? Long Description In src/backend/libpq/be-secure.c: secure_write on SSL_ERROR_WANT_WRITE call secure_read instead secure_write again. May be is this a typing error? Sergey N. Yatskevich (syatskevich@n21lab.gosniias.msk.ru)
2003-03-27Fix bogus coding of SET DEFAULT ri triggers ... or at least make it lessTom Lane
bogus than it was. Per bug report from Adrian Pop.
2003-03-27GetTupleForTrigger must use outer transaction's command counter for timeTom Lane
qual checking, not GetCurrentCommandId. Per test case from Steve Wolfe.
2003-03-25fixed problem where information from previous updates was leaking into ↵Dave Cramer
subsequent updates patch from Shawn Green, slightly modified
2003-03-25added DISTINCT to the query to get cross reference. This is required when ↵Dave Cramer
two columns in a table are both foreign keys to another table. From Peter Royal proyal@pace2020.com
2003-03-25fixed problem where information from previous updates was leaking into ↵Dave Cramer
subsequent updates patch from Shawn Green
2003-03-24New build numberBarry Lind
2003-03-24Backport fix for parsing acls (didn't correctly interpret null acl to meanBarry Lind
table owner has privs) Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2003-03-23Band-aid patch for Shraibman's 'out of free buffers' bug: disable theTom Lane
keys_are_unique optimization introduced in 7.3. A better fix will appear in 7.4, but I think back-patching it is too risky for the stable branch.
2003-03-23Tweak selectivity and related routines to cope with domains. Per reportTom Lane
from Andreas Pflug.
2003-03-20The attatched patch fixes a memory error with contrib/dbmirror/pending.cBruce Momjian
when running it with older(Pre 7.3.x) versions of Postgresql. Backpatched to 7.3.X. Steven Singer
2003-03-19Backport patch to work around a server bug. Server incorrectly handles theBarry Lind
following: select 1; commit; set autocommit true; If this is submitted in one call to the server (the select 1 doesn't start a new transaction like it should), however if the select 1 is sent as a separate call then it works correctly. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
2003-03-18Applied translation fixesBarry Lind
Modified Files: Tag: REL7_3_STABLE errors_zh_TW.properties
2003-03-14pg_dumpall failed on groups having no members. Per report fromTom Lane
Nick Eskelinen.
2003-03-14Backport fix for parsing \n in updateable result sets to 7.3 branchBarry Lind
Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-03-14Repair incorrect prorettype entry for timestamptz_izone. Can't forceTom Lane
initdb in the 7.3 branch, but we can at least make it right for people who install 7.3.3 from scratch.
2003-03-14Backport batch update error message improvements to 7.3 branchBarry Lind
Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/util/PSQLException.java
2003-03-14Prevent infinite loop in ln_var() due to roundoff error.Tom Lane
Per report from Dave Marin.
2003-03-13GROUP BY got confused if there were multiple equal() GROUP BY items.Tom Lane
This bug has been latent since 7.0 or maybe even further back, but it was only exposed when parse_clause.c stopped suppressing duplicate items (see its rev 1.96 of 18-Aug-02).
2003-03-09pg_restore failed to restore blobs if -X disable-triggers is specified.Tom Lane
2003-03-08Back ported patches from head to 7.3 branch (fixes for NPE in result set ↵Barry Lind
absolute() and NPE when logging enabled) Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/util/PSQLException.java
2003-03-06Tweak dependency code to suppress NOTICEs generated by new method forTom Lane
cleaning out temp namespaces. We don't really want the server log to be cluttered with 'Drop cascades to table foo' every time someone uses a temp table...
2003-03-06Add missing --globals-only (long form of -g).Tom Lane
2003-03-05Repair bug reported by Laurent Perez: bad plan generated when UPDATE orTom Lane
DELETE of an inheritance tree references another inherited relation. This bug has been latent since 7.1; I'm still not quite sure why 7.1 and 7.2 don't manifest it (at least, they don't crash on a simple test case).
2003-03-03Prevent clustering on incomplete indexes: partial indexes are verboten,Tom Lane
as are non-amindexnulls AMs unless first column is attnotnull.
2003-03-02Repair memory leak introduced by recent change to make SPI return aTom Lane
tupdesc even with zero tuples returned: some plpgsql routines assumed they didn't need to do SPI_freetuptable() after retrieving no tuples.
2003-02-27Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zoneTom Lane
is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897.
2003-02-27Back patch bug fix to quote function.D'Arcy J.M. Cain
2003-02-24Backport a fix from 7.4 to 7.3 to better handle case in updateable result sets.Barry Lind
This backports part of the fix made in version 1.11. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-02-23If a shutdown request comes in while we're still starting up, don'tTom Lane
service it until after we execute SetThisStartUpID(). Else shutdown process will write the wrong SUI into the shutdown checkpoint, which seems likely to be trouble --- although I've not quite figured out how significant it really is.
2003-02-21Repair nasty oversight in bt_split: if the index is temporary, we weren'tTom Lane
updating the left-link from the split page's right sibling. This could result in backwards index scans missing some entries. Same bug exists in HEAD, will be patched later.
2003-02-20Fix timestamptz_in so that parsing of 'now'::timestamptz gives rightTom Lane
answer when SET TIMEZONE has been done since the start of the current transaction. Per bug report from Robert Haas. I plan some futher cleanup in HEAD, but this is a low-risk patch for the immediate issue in 7.3.
2003-02-19Back patch for GUC client_encoding variable not being handledTatsuo Ishii
correctly. However the patch for PostgresPollingStatusType() is not included to avoid 7.3 libpq vs. pre-7.3 backend compatibility problem. See following thread for more details. Subject: [HACKERS] client_encoding directive is ignored in postgresql.conf From: Tatsuo Ishii <t-ishii@sra.co.jp> Date: Wed, 29 Jan 2003 22:24:04 +0900 (JST)
2003-02-19Please apply patches for contrib/ltree.Bruce Momjian
ltree_73.patch.gz - for 7.3 : Fix ~ operation bug: eg '1.1.1' ~ '*.1' ltree_74.patch.gz - for current CVS Fix ~ operation bug: eg '1.1.1' ~ '*.1' Add ? operation Optimize index storage Last change needs drop/create all ltree indexes, so only for 7.4 Teodor Sigaev
2003-02-18Async_NotifyHandler must save and restore ImmediateInterruptOK. FixesTom Lane
known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query.
2003-02-14Fix SPI result logic for case where there are multiple statements of theTom Lane
same type in a rule. Per bug report from Pavel Hanak.
2003-02-14Update FAQ's in head and 7.3.X.Bruce Momjian
2003-02-13Repair incorrect indexing for atttypmod, per Brad McLean.Tom Lane
2003-02-13Result of lo_read() is int, not size_t. Per Oleg Drokin.Tom Lane
2003-02-13Parser was dropping foreign-key constraints on the floor if present inTom Lane
an ALTER TABLE ADD COLUMN command. Per bug #896.
2003-02-13Repair rule permissions-checking bug reported by Tim Burgess 10-Feb-02:Tom Lane
the table(s) modified by the original query would get checked for the type of write permission needed by a rule query.
2003-02-13Prevent timetz2tm() from scribbling on its input in HAVE_INT64_TIMESTAMP case.Tom Lane
2003-02-13> > They work the same as table constraints with in-line declaration (noBruce Momjian
> > comma). > > OK. But the documentation implies there is a comma, so it should probably > get chenged then. Yes, it should. (attached) [ Backpatched to 7.3.X too.] Rod Taylor