summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2005-08-26Back-patch fixes for problems with VACUUM destroying t_ctid chains too soon,Tom Lane
and with insufficient paranoia in code that follows t_ctid links. This patch covers the 7.3 branch.
2005-08-16Reject operator names >= NAMEDATALEN characters. These will not workTom Lane
anyway, and in assert-enabled builds you are likely to get an assertion failure. Backpatch as far as 7.3; 7.2 seems not to have the problem.
2005-07-18Fix bogus backslash sequences, per Kris Jurka.Tom Lane
2005-07-18MemSet() must not cast its pointer argument to int32* until after it hasTom Lane
checked that the pointer is actually word-aligned. Casting a non-aligned pointer to int32* is technically illegal per the C spec, and some recent versions of gcc actually generate bad code for the memset() when given such a pointer. Per report from Andrew Morrow.
2005-07-17Adjust alter_table regression test to avoid conflicts with rangefuncsTom Lane
and prepare tests, which cause intermittent failures in parallel test mode. Back-port of fix originally applied to 8.0 and 7.4 branches; the problems do not appear to exist in 7.2 branch but they do occur in 7.3. Per buildfarm results.
2005-07-16Mark the geometry regression test as an ignorable failure in the pre-7.4Tom Lane
branches. Per discussion, this seems saner than trying to maintain last-significant-digit regression test outputs for all supported platforms.
2005-07-14Fix mis-backport of libpq memory leak fix. Per Michael Fuhr.Tom Lane
2005-07-13Fix libpq memory leak during PQreset() --- closePGconn() was notTom Lane
freeing all transient state of the PGconn object.
2005-07-08Make libpq_gettext save and restore errno in a Windows-compatible way.Tom Lane
Also, back-patch fix into back branches.
2005-06-25Fix ancient memory leak in index_create(): RelationInitIndexAccessInfoTom Lane
was being called twice in normal operation, leading to a leak of one set of relcache subsidiary info. Per report from Jeff Gold.
2005-06-20plpgsql's exec_assign_value() freed the old value of a variable beforeTom Lane
copying/converting the new value, which meant that it failed badly on "var := var" if var is of pass-by-reference type. Fix this and a similar hazard in exec_move_row(); not sure that the latter can manifest before 8.0, but patch it all the way back anyway. Per report from Dave Chapeskie.
2005-06-14The random selection in function linear() could deliver a value equal to maxTom Lane
if geqo_rand() returns exactly 1.0, resulting in failure due to indexing off the end of the pool array. Also, since this is using inexact float math, it seems wise to guard against roundoff error producing values slightly outside the expected range. Per report from bug@zedware.org.
2005-06-11Fix bug in MIC -> EUC_JP conversion. Per Atsushi Ogawa.Tatsuo Ishii
2005-06-05Code for SET/SHOW TIME ZONE with a fixed-interval timezone was notTom Lane
prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin.
2005-06-02Push enable/disable of notify and catchup interrupts all the way downTom Lane
to just around the bare recv() call that gets a command from the client. The former placement in PostgresMain was unsafe because the intermediate processing layers (especially SSL) use facilities such as malloc that are not necessarily re-entrant. Per report from counterstorm.com.
2005-05-31Add test to WAL replay to verify that xl_prev points back to the previousTom Lane
WAL record; this is necessary to be sure we recognize stale WAL records when a WAL page was only partially written during a system crash.
2005-05-29expandRTE and get_rte_attribute_type mistakenly always imputed typmod -1Tom Lane
to columns of an RTE that was a function returning RECORD with a column definition list. Apparently no one has tried to use non-default typmod with a function returning RECORD before.
2005-05-25Fix previous patch to exprTypmod.Tatsuo Ishii
2005-05-24Inserting 5 characters into char(10) does not produce 5 padding spacesTatsuo Ishii
if they are two-byte multibyte characters. Same thing can be happen if octet_length(multibyte_chars) == n where n is char(n). Long standing bug since 7.3 days. Per report and fix from Yoshiyuki Asaba.
2005-05-17Guard against duplicate IDs in input file in SortTocFromFile().Tom Lane
Per report from Brian Hackett.
2005-05-08Update release checklist to reflect that HISTORY and INSTALL don'tTom Lane
need to be created by hand anymore.
2005-05-07Repair very-low-probability race condition between relation extensionTom Lane
and VACUUM: in the interval between adding a new page to the relation and formatting it, it was possible for VACUUM to come along and decide it should format the page too. Though not harmful in itself, this would cause data loss if a third transaction were able to insert tuples into the vacuumed page before the original extender got control back.
2005-05-07Adjust time qual checking code so that we always check TransactionIdIsInProgressTom Lane
before we check commit/abort status. Formerly this was done in some paths but not all, with the result that a transaction might be considered committed for some purposes before it became committed for others. Per example found by Jan Wieck.
2005-05-05Stamp release 7.3.10.Tom Lane
2005-05-05Make standalone backends ignore pg_database.datallowconn, so that thereTom Lane
is a way to recover from disabling connections to all databases at once.
2005-05-03Alter the signature for encoding conversion functions to declare theTom Lane
output area as INTERNAL not CSTRING. This is to prevent people from calling the functions by hand. This is a permanent solution for the back branches but I hope it is just a stopgap for HEAD.
2005-04-30GCC 4.0 includes a new warning option, -Wformat-literal, that emitsNeil Conway
a warning when a variable is used as a format string for printf() and similar functions (if the variable is derived from untrusted data, it could include unexpected formatting sequences). This emits too many warnings to be enabled by default, but it does flag a few dubious constructs in the Postgres tree. This patch fixes up the obvious variants: functions that are passed a variable format string but no additional arguments. This patch fixes a bug in pg_dump (triggers with formatting sequences in their names are not dumped correctly) and some related pg_dump code that looks dubious; cleanups for more harmless instances have been applied to more recent branches.
2005-04-30This patch fixes a bug in the error message emitted by pg_restore on anNeil Conway
incorrect -F argument: write_msg() expects its first parameter to be a "module name", not the format string.
2005-04-23Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. ComparisonTom Lane
of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-datetime code does not exist in 7.2).
2005-04-20Don't try to run clauseless index scans on index types that don't supportTom Lane
it. Per report from Marinos Yannikos.
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