https://github.com/postgres/postgres

sort by:
Revision Author Date Message Commit Date
a41379f Stamp 7.4.12. 12 February 2006, 22:38:30 UTC
8cef661 Update release notes. 12 February 2006, 22:36:05 UTC
7ef174c Fix bug in SET SESSION AUTHORIZATION that allows unprivileged users to crash the server, if it has been compiled with Asserts enabled (CVE-2006-0553). Thanks to Akio Ishida for reporting this problem. 12 February 2006, 22:33:29 UTC
86b2da8 Update FAQ latest version 12 February 2006, 18:50:26 UTC
81c303c Stamp releases for 2006-02-14 release 12 February 2006, 18:41:39 UTC
dd56158 Update release notes for 2006-02-14 release 12 February 2006, 18:23:22 UTC
7da4e7a Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code is actually simpler than what we had, because we can just say O_CREAT to start with and not need a second open() call. I believe this accounts for several recent reports of hard-to-reproduce "could not create file ...: File exists" errors in both pg_clog and pg_subtrans. 21 January 2006, 04:38:46 UTC
e05a95b We neglected to apply domain constraints on UNKNOWN parameters to prepared statements, per report from David Wheeler. 12 January 2006, 22:29:31 UTC
e76bb5c Repair "Halloween problem" in EvalPlanQual: a tuple that's been inserted by our own command (or more generally, xmin = our xact and cmin >= current command ID) should not be seen as good. Else we may try to update rows we already updated. This error was inserted last August while fixing the even bigger problem that the old coding wouldn't see *any* tuples inserted by our own transaction as good. Per report from Euler Taveira de Oliveira. 12 January 2006, 21:49:32 UTC
1937d8d Use a more bulletproof test for whether finite() and isinf() are present. It seems that recent gcc versions can optimize away calls to these functions even when the functions do not exist on the platform, resulting in a bogus positive result. Avoid this by using a non-constant argument and ensuring that the function result is not simply discarded. Per report from François Laupretre. 12 January 2006, 19:24:27 UTC
1fc010c Fix pg_dump to add the required OPERATOR() decoration to schema-qualified operator names. This is needed when dumping operator definitions that have COMMUTATOR (or similar) links to operators in other schemas. Apparently Daniel Whitter is the first person ever to try this :-( 09 January 2006, 21:16:46 UTC
2942023 Fix failure to apply domain constraints to a NULL constant that's added to an INSERT target list during rule rewriting. Per report from John Supplee. 06 January 2006, 20:11:31 UTC
e9b0c2d Release-note updates and copy editing. 06 January 2006, 03:00:34 UTC
7de3bec Generate back-branch configure scripts with the appropriate version of autoconf. 06 January 2006, 02:31:08 UTC
f1f15af New pgcrypto item wording. 05 January 2006, 15:17:40 UTC
877ecee Wording improvements. 05 January 2006, 15:11:33 UTC
f8c7c06 Improve markup. 05 January 2006, 14:52:58 UTC
721205b *** empty log message *** 05 January 2006, 05:22:09 UTC
12693c6 Stamp release 7.4.11. 05 January 2006, 03:59:48 UTC
d514752 Arrange to set the LC_XXX environment variables to match our locale setup. Back-patch of previous fix in HEAD for plperl-vs-locale issue. 05 January 2006, 00:55:24 UTC
37cdf43 Add port support for unsetenv() in back branches. Needed for locale environment fix. 05 January 2006, 00:51:25 UTC
fcacfc9 When the remote query result has a different number of columns than the local query specifies (e.g. in the FROM clause), throw an ERROR (instead of crashing). Fix for bug #2129 reported by Akio Iwaasa. 03 January 2006, 23:48:04 UTC
8dc7c8c There is a signedness bug in Openwall gen_salt code that pgcrypto uses. This makes the salt space for md5 and xdes algorithms a lot smaller than it should be. Marko Kreen 03 January 2006, 23:46:51 UTC
bf8128f Remove DOS line endings ("\r\n") from several .po files. DOS line endings are inconsistent with the rest of the .po files, and apparently cause problems for Sun's cc. Per report on IRC from "bitvector2". 01 January 2006, 10:14:27 UTC
b2af5a2 Fix long standing Asian multibyte charsets bug. See: Subject: [HACKERS] bugs with certain Asian multibyte charsets From: Tatsuo Ishii <ishii@sraoss.co.jp> To: pgsql-hackers@postgresql.org Date: Sat, 24 Dec 2005 18:25:33 +0900 (JST) for more details. 24 December 2005, 10:40:55 UTC
0862aea Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. NOTE: affected databases may need to REINDEX indexes on text columns to be sure they are self-consistent. 22 December 2005, 22:50:22 UTC
b1ea82f Defend against crash while processing Describe Statement or Describe Portal messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr. 14 December 2005, 17:07:00 UTC
6acbe66 Translation updates 09 December 2005, 22:12:26 UTC
9c8c45e Stamp 7.4.10. 09 December 2005, 20:53:26 UTC
c8457e0 Add release notes for back branches (7.3 and up). Also minor improvements to 8.1.1 release notes. 09 December 2005, 20:40:56 UTC
d45693f Documentation fix: s/event_object_name/event_object_table/g 08 December 2005, 20:44:18 UTC
9e4caa5 Fix stupid bug with sizeof 06 December 2005, 18:22:13 UTC
a025aa1 In a nestloop inner indexscan, it's OK to use pushed-down baserestrictinfo clauses even if it's an outer join. This is a corner case since such clauses could only arise from weird OUTER JOIN ON conditions, but worth fixing. Per example from Ron at cheapcomplexdevices.com. 06 December 2005, 16:59:22 UTC
8b20f8a Add regression test to see if the min/max values of int8 convert correctly. 05 December 2005, 04:14:27 UTC
22868b9 Fix out-of-order inclusion of -L switches from LDFLAGS on AIX and HPUX. Per example from Dirk Pirschel. 03 December 2005, 20:17:00 UTC
22fff8b Check for overflow in strtol() while parsing datetime inputs. Michael Fuhr. 01 December 2005, 17:57:07 UTC
e03c5e2 Fix performance issue in exprTypmod(): for a COALESCE expression, it recursed twice on its first argument, leading to exponential time spent on a deep nest of COALESCEs ... such as a deeply nested FULL JOIN would produce. Per report from Matt Carter. 18 November 2005, 23:08:43 UTC
48fabd2 Properly document return value of strpos(). 16 November 2005, 03:56:52 UTC
63b2342 When in transaction-aborted state, reject Bind message for portals containing anything but transaction-exiting commands (ROLLBACK etc). We already rejected Parse and Execute in such cases, so there seems little point in allowing Bind. This prevents at least an Assert failure, and probably worse things, since there's a lot of infrastructure that doesn't work when not in a live transaction. We can also simplify the Bind logic a bit by rejecting messages with a nonzero number of parameters, instead of the former kluge to silently substitute NULL for each parameter. Per bug #2033 from Joel Stevenson. 10 November 2005, 00:31:59 UTC
74f224f 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. I intend a more extensive fix when 8.2 development starts, but this is a reasonably low-impact patch for the existing branches. 03 November 2005, 00:23:50 UTC
fcd978c 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. 25 October 2005, 20:30:45 UTC
01145f9 Prevent core dump in contrib version of autovacuum when a table has been dropped. Per report from daveg (not his patch, though). 20 October 2005, 16:14:47 UTC
52e98f8 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. 20 October 2005, 01:31:50 UTC
a4baf22 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. 14 October 2005, 16:41:28 UTC
e257f28 [ Backpatch to 7.4.X.] Also I fixed a bug in a bug fix I committed a few weeks ago. he check for a varchar pointer was incomplete. Michael Meskes 14 October 2005, 01:50:58 UTC
5c05d16 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. 12 October 2005, 17:18:31 UTC
25a5b74 Fix typo in sample pg_hba.conf; per IRC report from Bernhard Neuhauser. 11 October 2005, 23:00:39 UTC
31d276d COPY's test for read-only transaction was backward; it prohibited COPY TO where it should prohibit COPY FROM. Found by Alon Goldshuv. 03 October 2005, 23:43:45 UTC
4082f5e Stamp release 7.4.9. 03 October 2005, 17:14:24 UTC
fd366be Update release notes for pending back-branch releases. 03 October 2005, 16:05:09 UTC
196c9d2 Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916). 28 September 2005, 21:17:50 UTC
6a2c659 [ Patch to 7.4.X.] In several places PL/Python was calling PyObject_Str() and then PyString_AsString() without checking if the former had returned NULL to indicate an error. PyString_AsString() doesn't expect a NULL argument, so passing one causes a segmentation fault. This patch adds checks for NULL and raises errors via PLy_elog(), which prints details of the underlying Python exception. The patch also adds regression tests for these checks. All tests pass on my Solaris 9 box running HEAD and Python 2.4.1. 25 September 2005, 03:18:16 UTC
8fb4451 Update Snowball. I have to update it because of old version doesn't available on Snowball's site and new version of stemmers can't be compiled with old interface. 15 September 2005, 12:41:52 UTC
e3523f5 Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. 12 September 2005, 18:51:29 UTC
752b861 Translation update 03 September 2005, 07:41:11 UTC
d4235f9 Fix missing rows in query update a=.. where a... with GiST index on column 'a' Backpatch from 8.0 branch 30 August 2005, 08:36:52 UTC
2ba0540 Back-patch fixes for problems with VACUUM destroying t_ctid chains too soon, and with insufficient paranoia in code that follows t_ctid links. This patch covers the 7.4 branch. 25 August 2005, 22:07:21 UTC
c9e69d7 Back-patch fix to correctly quote schema names in --no-owner mode. Per gripe from Dick Kniep. 25 August 2005, 00:11:36 UTC
d00f6b2 - Check for NULL before checking whether argument is an array. - Removed stray character from string quoting. - Fixed check to report missing varchar pointer implementation. 24 August 2005, 10:35:54 UTC
e2e2e15 Reject operator names >= NAMEDATALEN characters. These will not work 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. 16 August 2005, 00:48:43 UTC
ec70ca7 array_in() and array_recv() need to be more paranoid about validating their OID parameter. It was possible to crash the backend with select array_in('{123}',0,0); because that would bypass the needed step of initializing the workspace. These seem to be the only two places with a problem, though (record_in and record_recv don't have the issue, and the other array functions aren't depending on user-supplied input). Back-patch as far as 7.4; 7.3 does not have the bug. 15 August 2005, 19:41:06 UTC
6f0da95 int_array_enum function should be using fcinfo->flinfo->fn_extra for working state, not fcinfo->context. Silly oversight on my part in last go-round of fixes. 15 August 2005, 19:05:43 UTC
c98a606 Fix count_usable_fds() to stop trying to open files once it reaches max_files_per_process. Going further than that is just a waste of cycles, and it seems that current Cygwin does not cope gracefully with deliberately running the system out of FDs. Per Andrew Dunstan. 07 August 2005, 18:48:00 UTC
c76de7d MemSet() must not cast its pointer argument to int32* until after it has 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. 18 July 2005, 15:54:11 UTC
027b623 Make pg_regress accept a command-line option for the temporary installation's port number, and use a default value for it that is dependent on the configuration-time DEF_PGPORT. Should make the world safe for running parallel 'make check' in different branches. Back-patch as far as 7.4 so that this actually is useful. 17 July 2005, 18:29:37 UTC
86494de Back-patch recent changes to alter the order of -L flags inserted from LDFLAGS versus those built into the Makefiles. This looks like it will fix several buildfarm failures in the back branches. 17 July 2005, 04:06:04 UTC
6ec28d8 ecpglib depends on last_path_separator from src/port/path.c, so we'd better include that in the library build. This was fixed in 8.0 and later, backport to 7.4 to fix buildfarm failure. 16 July 2005, 20:39:24 UTC
bf84d6e Back-patch 8.0's tightening of ORDER BY clauses in join regression test, in hopes of eliminating buildfarm regression failure. (Not clear if we will need a join_1.out variant in this branch.) 16 July 2005, 20:20:49 UTC
dc59b47 cube_1 variant is needed in 7.4 branch, per results from buildfarm machine 'kudu'. 16 July 2005, 20:11:12 UTC
d96e046 The geometry_2 variant appears to be needed in 7.4 branch as well as later, per results from buildfarm member 'wallaroo'. 16 July 2005, 18:39:26 UTC
0a719d8 Fix bogus "extern int errno;" in back branches, per Andrew Dunstan. 16 July 2005, 15:23:29 UTC
ecafa82 Fix mis-backport of libpq memory leak fix. Per Michael Fuhr. 14 July 2005, 14:07:41 UTC
57bdab7 Fix libpq memory leak during PQreset() --- closePGconn() was not freeing all transient state of the PGconn object. 13 July 2005, 15:26:16 UTC
a5d10d6 Make libpq_gettext save and restore errno in a Windows-compatible way. Also, back-patch fix into back branches. 08 July 2005, 15:25:19 UTC
4677334 Fix ancient memory leak in index_create(): RelationInitIndexAccessInfo was being called twice in normal operation, leading to a leak of one set of relcache subsidiary info. Per report from Jeff Gold. 25 June 2005, 16:54:12 UTC
0592a1e Correct some code in pg_restore when reading the header of a tar archive: (1) The code doesn't initialize `sum', so the initial "does the checksum match?" test is wrong. (2) The loop that is intended to check for a "null block" just checks the first byte of the tar block 512 times, rather than each of the 512 bytes one time (!), which I'm guessing was the intent. It was only through sheer luck that this worked in the first place. Per Coverity static analysis performed by EnterpriseDB. 22 June 2005, 02:12:19 UTC
a6f0dee plpgsql's exec_assign_value() freed the old value of a variable before 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. 20 June 2005, 20:44:57 UTC
41d2849 When using C-string lookup keys in a dynahash.c hash table, use strncpy() not memcpy() to copy the offered key into the hash table during HASH_ENTER. This avoids possible core dump if the passed key is located very near the end of memory. Per report from Stefan Kaltenbrunner. 18 June 2005, 20:51:59 UTC
2b6dd51 Translation updates 17 June 2005, 11:30:57 UTC
a1f08fc The random selection in function linear() could deliver a value equal to max 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. 14 June 2005, 14:21:31 UTC
4f3ae01 Fix bug in MIC -> EUC_JP conversion. Per Atsushi Ogawa. 11 June 2005, 02:50:07 UTC
fe88b20 Repair error in description of nonblocking usage of PQgetCopyData(). Per Volkan Yazici. 09 June 2005, 19:08:47 UTC
39c9398 Code for SET/SHOW TIME ZONE with a fixed-interval timezone was not prepared for HAVE_INT64_TIMESTAMP. Per report from Guillaume Beaudoin. 05 June 2005, 01:48:55 UTC
b38bcb2 Push enable/disable of notify and catchup interrupts all the way down 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. 02 June 2005, 21:04:08 UTC
e063240 Fixed memory leak in ecpglib by adding some missing free() commands. 02 June 2005, 12:50:30 UTC
1891938 Prevent to divide by zero and range out of 0..1 01 June 2005, 11:46:09 UTC
5205024 Add test to WAL replay to verify that xl_prev points back to the previous 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. 31 May 2005, 19:10:57 UTC
3c6bba3 expandRTE and get_rte_attribute_type mistakenly always imputed typmod -1 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. 29 May 2005, 17:10:52 UTC
ab82f60 Adjust datetime parsing to be more robust. We now pass the length of the working buffer into ParseDateTime() and reject too-long input there, rather than checking the length of the input string before calling ParseDateTime(). The old method was bogus because ParseDateTime() can use a variable amount of working space, depending on the content of the input string (e.g. how many fields need to be NUL terminated). This fixes a minor stack overrun -- I don't _think_ it's exploitable, although I won't claim to be an expert. Along the way, fix a bug reported by Mark Dilger: the working buffer allocated by interval_in() was too short, which resulted in rejecting some perfectly valid interval input values. I added a regression test for this fix. 26 May 2005, 02:14:32 UTC
d1d5c0f Translation updates 25 May 2005, 08:32:14 UTC
05a07af Fix previous patch to exprTypmod. 25 May 2005, 02:13:48 UTC
de212f4 Inserting 5 characters into char(10) does not produce 5 padding spaces 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. 24 May 2005, 23:15:05 UTC
0a7b3a3 Previous fix for "x FULL JOIN y ON true" failed to handle the case where there was also a WHERE-clause restriction that applied to the join. The check on restrictlist == NIL is really unnecessary anyway, because select_mergejoin_clauses already checked for and complained about any unmergejoinable join clauses. So just take it out. 24 May 2005, 18:03:24 UTC
88c59ae Guard against duplicate IDs in input file in SortTocFromFile(). Per report from Brian Hackett. 17 May 2005, 17:30:53 UTC
103376e Update release notes for upcoming re-releases. 09 May 2005, 00:10:22 UTC
775fec1 Update release checklist to reflect that HISTORY and INSTALL don't need to be created by hand anymore. 08 May 2005, 23:34:32 UTC
43418e8 In Blob.getBytes(long position, int length) position is an offset starting at 1, not zero as the driver was previously doing. Thanks to Emmanuel Bernard for the report. 08 May 2005, 23:16:58 UTC
0053e29 Repair very-low-probability race condition between relation extension 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. 07 May 2005, 21:33:21 UTC
501ec7b Adjust time qual checking code so that we always check TransactionIdIsInProgress 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. 07 May 2005, 21:23:02 UTC
26f64e4 Stamp release 7.4.8. 05 May 2005, 20:08:35 UTC
back to top