summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2005-04-20Fix mis-display of negative fractional seconds in interval values forTom Lane
--enable-integer-datetimes case. Per report from Oliver Siegmar.
2005-04-14Don't try to constant-fold functions returning RECORD, since the optimizerTom Lane
isn't presently set up to pass them an expected tuple descriptor. Bug has been there since 7.3 but was just recently reported by Thomas Hallgren.
2005-03-26Prevent to_char(interval) from dumping core on month-related formatsTom Lane
when a zero-month interval is given. Per discussion with Karel.
2005-02-08Back-patch Neil's four additional buffer overrun checks.Tom Lane
2005-01-30Stamp release 7.3.9.Tom Lane
2005-01-27Check that aggregate creator has the right to execute the transitionTom Lane
functions of the aggregate, at both aggregate creation and execution times.
2005-01-27Backpatch fix for buffer overrun in parsing refcursor parameters toNeil Conway
REL7_3_STABLE.
2005-01-26Back-patch 8.0 version of plperl_hash_from_tuple() into prior releasesTom Lane
to fix failure to cope with quote marks in field values; not to mention that it is shorter and faster. Per report from Charles Haron.
2005-01-24Disallow LOAD to non-superusers. Per report from John Heasman.Tom Lane
2005-01-23The result of a FULL or RIGHT join can't be assumed to be sorted by theTom Lane
left input's sorting, because null rows may be inserted at various points. Per report from Ferenc Lutischá¸n.
2005-01-11interval_out failed to mention 'ago' for negative intervals in SQL andTom Lane
GERMAN datestyles. Ancient bug reported by Terry Lee Tucker.
2004-12-17array_map failed to insert correct result type in an empty array.Tom Lane
Per example from Florian Pflug.
2004-11-18Back-patch fix for ALTER DATABASE failing to flush pg_database changesTom Lane
to disk right away. This is just a one-liner change rather than trying to use FlushRelationBuffers().
2004-11-17Fix off-by-one memory allocation, as reported by Rod Taylor. AlsoTom Lane
avoid repalloc'ing twice when once is sufficient.
2004-10-22Stamp release 7.3.8.REL7_3_8Tom Lane
2004-10-22Prevent pg_ctl from being run as root. Since it uses configuration filesTom Lane
owned by postgres, doing "pg_ctl start" as root could allow a privilege escalation attack, as pointed out by iDEFENSE. Of course the postmaster would fail, but we ought to fail a little sooner to protect sysadmins unfamiliar with Postgres. The chosen fix is to disable root use of pg_ctl in all cases, just to be confident there are no other holes.
2004-10-13Repair possible failure to update hint bits back to disk, perTom Lane
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00464.php. I plan a more permanent fix in HEAD, but for the back branches it seems best to just touch the places that actually have a problem.
2004-10-13Fix breakage in hashjoin from recent backpatch of left-join bug fix.Tom Lane
(That's what I get for not testing the back branches *before* committing.)
2004-09-17Hashed LEFT JOIN would miss outer tuples with no inner match if the joinTom Lane
was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug.
2004-08-15Stamp 7.3.7.Tom Lane
2004-08-11Fix failure to guarantee that a checkpoint will write out pg_clog updatesTom Lane
for transaction commits that occurred just before the checkpoint. This is an EXTREMELY serious bug --- kudos to Satoshi Okada for creating a reproducible test case to prove its existence.
2004-04-05Translation updatesPeter Eisentraut
2004-04-05Translation updatesPeter Eisentraut
2004-03-02Always schema-qualify the name of a function referenced in CREATE CAST.Tom Lane
The former coding failed if the cast function was not in the pg_catalog schema. How'd this escape detection?
2004-03-02Brand 7.3.6.REL7_3_6Tom Lane
2004-02-24Don't crash when a rowtype argument to a plpgsql function is NULL.Tom Lane
Per report from Chris Campbell.
2004-02-05Back-patch fix for ReadOffset with off_t wider than int.Tom Lane
2004-02-02Avoid generating invalid character encoding sequences in make_greater_string.Tom Lane
Not sure how this mistake evaded detection for so long.
2004-02-01Fix text_position to not scan past end of source string in multibyteJoe Conway
case, per report from Korea PostgreSQL Users' Group. Copied from Tom Lane's 7.4 branch patch.
2004-01-26Repair incorrect order of operations in GetNewTransactionId(). We mustTom Lane
complete ExtendCLOG() before advancing nextXid, so that if that routine fails, the next incoming transaction will try it again. Per trouble report from Christopher Kings-Lynne.
2004-01-14Revert ill-starred change of 13-Feb-02: it appeared to fix a problem ofTom Lane
incorrect permissions checking, but in fact disabled most all permissions checks for view updates. This corrects problems reported by Sergey Yatskevich among others, at the cost of re-introducing the problem previously reported by Tim Burgess. However, since we'd lived with that problem for quite awhile without knowing it, we can live with it awhile longer until a proper fix can be made in 7.5.
2003-12-07Repair indexed bytea like operations, and related selectivityJoe Conway
functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php
2003-12-02Brand 7.3.5.REL7_3_5Tom Lane
2003-12-01Force zero_damaged_pages to be effectively ON during recovery from WAL,Tom Lane
since there is no need to worry about damaged pages when we are going to overwrite them anyway from the WAL. Per recent discussion.
2003-11-30Back-patch fix to check vartypmod when matching PlannerParamVar entries.Tom Lane
This should prevent some obscure cases of 'variable not in subplan target lists', although actual failures have only been reported against 7.4 in which the bug is much easier to trigger.
2003-11-30Back-patch fix to cause stats processes to detach from shared memory,Tom Lane
so that they do not prevent the postmaster from deleting the shmem segment during crash recovery.
2003-11-30Make PQescapeBytea and byteaout consistent with each other, andJoe Conway
octal escape all octets outside the range 0x20 to 0x7e. This fixes the problem pointed out by Sergey Yatskevich here: http://archives.postgresql.org/pgsql-bugs/2003-11/msg00140.php
2003-10-31Back-patch removal of unnecessary inclusion of <crypt.h>, so thatTom Lane
7.3.5 will build out-of-the-box on Solaris.
2003-10-31Moved the recently added test for foreign key disabled by rewriteJan Wieck
rule into the rule.sql since it affects the latter if run in paralell. Jan
2003-10-31Fix for possible referential integrity violation when a qualified ON INSERTJan Wieck
rule split the query into one INSERT and one UPDATE where the UPDATE then hit's the just created row without modifying the key fields again. In this special case, the new key slipped in totally unchecked. Jan
2003-10-30Support for qualified type names in PL/Tcl's spi_prepare command.Jan Wieck
This is not 100% backward compatible as formerly a double quoted type name containing a dot could be used. But I don't think may people use dot's in the name of user defined types. Jan
2003-10-28Don't choke when the handler for a procedural language is located inTom Lane
the pg_catalog schema. Per bug report some months back from Jochem van Dieten.
2003-10-20It is possible for ResolveNew to be used to insert a sublink into aTom Lane
subquery that didn't previously have one. We have traditionally made the caller of ResolveNew responsible for updating the hasSubLinks flag of the outermost query, but this fails to account for hasSubLinks in subqueries. Fix ResolveNew to handle this. We might later want to change the calling convention of ResolveNew so that it can fix the outer query too, simplifying callers. But I went with the localized fix for now. Per bug report from J Smith, 20-Oct-03.
2003-10-02When dumping CREATE INDEX, must show opclass name if the opclass isn'tTom Lane
in the schema search path. Otherwise pg_dump doesn't correctly dump scenarios where a custom opclass is created in 'public' and then used by indexes in other schemas.
2003-09-29[ Patch applied only to 7.3.X.]Bruce Momjian
Hi There's a bug in the clusterdb script where it looks like the arguments to the psql command are being passed in the wrong order, so it fails when you run it on a database that is not on localhost. Here's the output from the command: 133 anands-Computer:bin/scripts> clusterdb -h wooster -U rr granada psql: warning: extra option wooster ignored psql: warning: extra option -U ignored psql: warning: extra option rr ignored psql: warning: extra option -F: ignored psql: warning: extra option -P ignored psql: warning: extra option format=unaligned ignored psql: warning: extra option -t ignored psql: warning: extra option -c ignored psql: warning: extra option SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM pg_user WHERE usename=current_user) ignored psql: FATAL: user "-h" does not exist I'm attaching a patch that fixes the problem. The diff was run on postgresql 7.3.4 Thanks a lot. Anand Ranganathan
2003-09-28Backpatched changes for rules when casts are dumped according toJan Wieck
discussion on hackers. Jan
2003-09-23_SPI_cursor_operation forgot to check for failure return fromTom Lane
_SPI_begin_call. Per gripe from Tomasz Myrta.
2003-09-17Back-patch fix for plpython problems with dropped table columns;Tom Lane
per bug report from Arthur Ward, who also tested this patch.
2003-09-03Back-patch the other part of Karel's formatting bug fix.Tom Lane
2003-09-03Repair problems with to_char() overrunning its input string.Tom Lane
From Karel Zak.
generated by cgit v1.2.3 (git 2.46.0) at 2025-09-06 01:05:36 +0000