https://github.com/postgres/postgres

sort by:
Revision Author Date Message Commit Date
895491b Brand 7.2.4. 29 January 2003, 22:13:19 UTC
d106c79 Update release history for 7.2.4. 29 January 2003, 22:12:42 UTC
dd10354 Back-patch fix to avoid integer overflow in ExecHashJoinGetBatch(), which leads to core dump in large-enough hash joins. 29 January 2003, 19:37:23 UTC
2357fd1 Back-patch fixes to detoast pg_group.grolist. 26 January 2003, 23:16:23 UTC
12fa077 Back-patch fixes to ensure t_ctid always has correct value (prevents some instances of 'No one parent tuple' VACUUM error, and perhaps worse things). 26 January 2003, 23:09:37 UTC
3c877e5 Back-patch fix for alphabetization mistakes in datetime token tables. 26 January 2003, 22:33:16 UTC
adf852b Back-patch fix to ensure pg_clog updates are not only written but sync'ed before we consider the checkpoint to be done. 21 January 2003, 19:51:42 UTC
0c3cf79 Back-patch fixes for integer overflows in circle_poly(), path_encode(), and path_add() --- from Neil Conway. Also, repair recently-detected errors in lseg_eq(), lseg_ne(), lseg_center(). 21 January 2003, 19:41:26 UTC
474f113 Back-patch fix for VACUUM being confused by SELECT FOR UPDATE of tuple that was previously outdated by a transaction that later aborted. Also, prevent VACUUM from being called inside function. 21 January 2003, 19:38:21 UTC
4526d21 Brand 7.2.3. 01 October 2002, 03:34:29 UTC
9227bc5 Update HISTORY/release.sgml for 7.2.3. 01 October 2002, 03:24:17 UTC
407517f Back-patch fixes to work around broken mktime() in recent glibc releases. 30 September 2002, 20:57:11 UTC
96464fa Back-patch fix for bad SIGUSR2 interrupt handling during backend shutdown. 30 September 2002, 20:47:22 UTC
c6ec2a8 Back-patch fix for correct TAS operation on multi-CPU PPC machines. 30 September 2002, 20:24:53 UTC
c9e3806 Back-patch fix for 'can't wait without a PROC structure' failures: remove separate ShutdownBufferPoolAccess exit callback, and do the work in ProcKill instead, before we delete MyProc. 30 September 2002, 20:18:59 UTC
c80d09f Back-patch fix to ensure a checkpoint occurs before truncating CLOG, even if no recent WAL activity has occurred. 30 September 2002, 19:55:08 UTC
a829ad1 Back-patch fix to not change pg_database.datvacuumxid or truncate CLOG when an unprivileged user runs VACUUM. 30 September 2002, 19:45:57 UTC
8266927 Back-patch fix for failure to dump views containing FULL JOIN USING. The bug is not present in CVS tip due to cleanup of JOIN handling, but 7.2.* is broken. 20 September 2002, 21:37:07 UTC
30ab8da Update HISTORY with Neil's changes. 23 August 2002, 02:33:06 UTC
17e543e Stamp the 7.2.2 release. 22 August 2002, 23:26:26 UTC
5a2c7c3 Fix regression-test breakage from (unnecessary) rewrite of show_datestyle. Grumble. 22 August 2002, 22:17:22 UTC
8c905b0 Back-patch fix to make partial indexes usable on relations other than the first one listed in a query. Per request from Oleg. 22 August 2002, 16:20:38 UTC
cd9f392 Apply Neil Conway's security patches to 7.2.X. 22 August 2002, 05:27:41 UTC
76fc795 Fix bug in pg_convert() per report from MaC.Yui. It pfree() wrong pointer. 19 August 2002, 04:58:26 UTC
7e49585 Back-patch 7.3 fix to fully parenthesize UNION/EXCEPT/INTERSECT queries in ruleutils output. The previous partial parenthesization was a hack to get around grammar restrictions that have since been fixed; and as Sam O'Connor pointed out, there were cases where it didn't work. 15 June 2002, 18:38:10 UTC
a67387b Please apply attached patch to contrib/intarray (7.2, 7.3). Fixed bug with '=' operator for gist__int_ops and define '=' operator for gist__intbig_ops opclass. Now '=' operator is consistent with standard 'array' type. Thanks Achilleus Mantzios for bug report and suggestion. Oleg Bartunov 07 June 2002, 21:53:09 UTC
b81737b Repair incorrect dumping of user-defined aggregate with null initcond. (Already fixed in current, but need a patch for 7.2.2.) 28 May 2002, 15:40:36 UTC
efe861c Fix a bug with building rtree_gist indexes. Patch from Teodor Sigaev. 28 May 2002, 15:25:03 UTC
5b79215 Repair error with not adjusting active scans properly after gistSplit. Patch from Teodor Sigaev. 28 May 2002, 15:22:44 UTC
6344882 Make RelationForgetRelation error out if the relcache entry has nonzero reference count. This avoids leaving dangling pointers around, as in recent bug report against sequences (bug# 671). 22 May 2002, 17:29:45 UTC
ce362bf Repair OPEN cursor(args), which I broke on 11/29/01 with a change to be smarter about parentheses in read_sql_construct(). Sigh. 21 May 2002, 18:50:18 UTC
490b12d Remove unnecessary pfree's in geometric operators. At least one of these is actively dangerous, per bug report from Ewald Geschwinde 14-May-02, and several of the rest look suspicious to me. Since there is no longer any significant value in retail pfree's in these functions, just get rid of all of them for safety's sake. 14 May 2002, 18:16:54 UTC
964f1fa Fix bug in pg_dump and psql (to reproduce the bug, just try pg_dump --nonexistingoption). per report from sugita@sra.co.jp on Thu, 09 May 2002 11:57:51 +0900 (JST) at pgsql-patches list. Illegal long options to pg_dump makes core on some systems, since it lacks the last null sentinel of struct option array. Attached is a patch made by Mr. Ishida Akio <iakio@pjam.jpweb.net>. 14 May 2002, 02:08:22 UTC
77c4ba6 plpgsql_dstring_append was broken for long strings. 05 May 2002, 17:38:28 UTC
ffd1a5d Change heap_get_latest_tid() so that a transaction can see changes made by the transaction itself. 01 May 2002, 01:27:31 UTC
891ce19 A backport patch. Fix PQescapeBytea/PQunescapeBytea so that they handle bytes > 0x7f. This is necessary for mulibyte character sequences. See "[HACKERS] PQescapeBytea is not multibyte aware" thread posted around 2002/04/05 for more details. 08 April 2002, 06:21:31 UTC
af99745 Fix CLOG truncation code to not do the Wrong Thing when there are already wrapped-around databases. The unvacuumed databases might be fine, or they might not, but things will definitely not be fine if we remove the wrong CLOG segments. Per trouble report from Gary Wolfe, 1-Apr-2002. 02 April 2002, 05:12:00 UTC
9de8b7b Update release list. 26 March 2002, 05:34:37 UTC
70cde08 Update sgml version properly. 26 March 2002, 05:33:47 UTC
22b32cb New wording: Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom) 25 March 2002, 21:24:46 UTC
ff71f2a Add to HISTORY: Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom) 25 March 2002, 20:58:40 UTC
df739a0 Re-allow CREATE AS (but not SELECT INTO) in EXECUTE. 25 March 2002, 07:41:21 UTC
b2d05d5 Remove long-dead 'fix for SELECT NULL' to stop current coredump. 21 March 2002, 06:21:14 UTC
94a4677 > > Users of contrib/tsearch needs after upgrading of module (compiling, installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov 19 March 2002, 14:16:32 UTC
873a986 Improve wording of bug fix: Ensure that sequence counters do not go backwards after a crash 19 March 2002, 00:12:41 UTC
0d3abc0 Update for 7.2.1. 18 March 2002, 23:04:11 UTC
bbc1fb0 Backpatch array I/O code and documentation fixes, also array slice lower subscript bounds change. 17 March 2002, 20:05:59 UTC
efec53a Repair bad calculation in timetz_izone() which gave erroneous results. Will be patched separately but equivalently in HEAD for 7.3. 15 March 2002, 23:37:48 UTC
94a41d1 Repair two problems with WAL logging of sequence nextvalI() ops, as per recent pghackers discussion: force a new WAL record at first nextval after a checkpoint, and ensure that xlog is flushed to disk if a nextval record is the only thing emitted by a transaction. 15 March 2002, 19:20:47 UTC
44d7f15 Update FAQ for 7.2.1. 13 March 2002, 20:53:15 UTC
aaf52da Pleas apply it for 7.2.1 and current CVS. Patch fixes using lc.lang instead of lc.lc_ctype. Teodor Sigaev 11 March 2002, 16:55:18 UTC
07ee72f Guard against NULL strings in SET key=val constructs. Problem noted by Fernando Nasser. 09 March 2002, 17:41:04 UTC
38b4088 Please, apply attached patch for contrib/tsearch to 7.2.1 and current CVS. It fix english stemmer's problem with ending words like 'technology'. We have found one more bug in english stemmer. The bug is with 'irregular' english words like 'skies' -> 'sky'. Please, apply attached cumulative patch to 7.2.1 and current CVS instead previous one. Thank to Thomas T. Thai <tom@minnesota.com> for hard testing. This kind of bug has significance only for dump/reload database and viewing, but searching/indexing works right. Teodor Sigaev 05 March 2002, 06:10:49 UTC
68d8137 Previous patch to mark UNION outputs with common typmod (if any) breaks three-or-more-way UNIONs, as per example from Josh Berkus. Cause is a fragile assumption that one tlist's entries will exactly match another. Restructure code to make that assumption a little less fragile. 05 March 2002, 05:13:36 UTC
06b3be1 A backport patch: Fix bug in extract/date_part for milliseconds/miscroseconds and timestamp/timestamptz combo. Now extract/date_part returns seconds*1000 or 1000000 + fraction part as the manual stats. regression test are also fixed. See the thread in pgsql-hackers: Subject: Re: [HACKERS] timestamp_part() bug? Date: Sat, 02 Mar 2002 11:29:53 +0900 05 March 2002, 03:45:44 UTC
ee93155 Update FAQ_Solaris with info about gcc 2.95.1 problems and how to work around 64-bit vsnprintf bug. 04 March 2002, 17:47:24 UTC
b233e59 Back-patch fix for errors reported at transaction end. 27 February 2002, 23:17:01 UTC
567f9d0 Back-patch fix for followings: Fix bug in COPY FROM when DELIMITER is not in ASCII range. See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean" around 2002/02/26 for more details -- Tatsuo Ishii 27 February 2002, 01:47:31 UTC
75c07d5 Back-patch fix for command completion report handling. This is primarily needed so that INSERTing a row still reports the row's OID even when there are ON INSERT rules firing additional queries. 26 February 2002, 23:48:47 UTC
5fb5066 Tweak psql's \connect command to not downcase unquoted database and user names. This is a temporary measure to allow backwards compatibility with 7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed case names in \connect. Once we feel that older dumps are not a problem anymore, we can revert this change and treat \connect arguments as normal SQL identifiers. 25 February 2002, 21:37:47 UTC
5eab1f1 Fix for PAM error message display: > and that the right fix is to make each of the subsequent calls be in > this same pattern, not to try to emulate their nonsensical style. Dominic J. Eidson 25 February 2002, 20:07:33 UTC
e6dbc17 Add a large number of time zones to the lookup table. Fix a few apparently-wrong TZ vs DTZ declarations. Same patch as added to HEAD. 25 February 2002, 16:22:48 UTC
326191c We had a problem with to compile pgsql-7.2 under SW-8.0. In the mailing lists I found no informations. See note for further informations. Add missing AuthBlockSig. regards Heiko 22 February 2002, 15:40:28 UTC
876eda5 BACKPATCH: Add Russian FAQ to 7.2.1. Why not? 22 February 2002, 13:03:01 UTC
a81dc0d BACKPATCH: Please, apply attached patch of contrib/btree_gist to 7.2.1 and current cvs. The patch fixes memory leak during creation GiST index on timestamp column. Thank you. -- Teodor Sigaev teodor@stack.net 22 February 2002, 06:08:48 UTC
c30ef87 Avoid failures in cash_out and cash_words for INT_MIN. Also, 'fourty' -> 'forty'. 19 February 2002, 22:19:42 UTC
cceca2c Replace number-of-distinct-values estimator equation, per recent pghackers discussion. 18 February 2002, 16:04:21 UTC
39821d1 Fix kanji-coversion key binding. This has been broken since 7.1 Per Yoshinori Ariie's report. 18 February 2002, 04:12:34 UTC
62feef6 Fix SGML typo in previous patch. 17 February 2002, 13:29:00 UTC
bf4507e I think it's important that it's actually documented that they can add primary keys after the fact! Also, we need to add regression tests for alter table / add primary key and alter table / drop constraint. These shouldn't be added until 7.3 tho methinks... Chris 17 February 2002, 11:50:09 UTC
a966ac1 Clarify params to ALTER TABLE to clearly show single parameters. e.g. table contraint definition -> table_constraint_definition. 16 February 2002, 23:45:48 UTC
673b48b Remove warning about automatic inclusion of sqlca. 15 February 2002, 17:46:57 UTC
ceec779 Update FAQ. 14 February 2002, 17:15:00 UTC
3576820 Ensure that a cursor is scanned under the same scanCommandId it was originally created with, so that the set of visible tuples does not change as a result of other activity. This essentially makes PG cursors INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02. 14 February 2002, 15:24:10 UTC
1392042 Point out that --adduser actually makes the new user a superuser. This was mentioned on the man page for the underlying CREATE USER command, but it should be explained here too. 13 February 2002, 19:32:17 UTC
a164407 Add DROP COLUMN status from Hiroshi. 13 February 2002, 14:36:43 UTC
fa046b6 Use RTLD_NOW, not RTLD_LAZY, as binding mode for dlopen() on all platforms. This restores the Linux behavior to what it was in PG 7.0 and 7.1, and causes other platforms to agree. (Other well-tested platforms like HPUX were doing it this way already.) Per pghackers discussion over the past month or so. 12 February 2002, 23:41:25 UTC
baa0bb9 Add warning not to use /usr/ucb/cc on Solaris. 12 February 2002, 22:35:07 UTC
28108b3 Fix tutorial for references problem, from rainer.tammer@spg.schulergroup.com 12 February 2002, 22:25:15 UTC
fa8a73c Clarify working in 'top x items using sequential scan' item 12 February 2002, 22:24:36 UTC
9832a23 Modify COPY TO to emit carriage returns and newlines as backslash escapes (backslash-r, backslash-n) for protection against newline-conversion munging. In future we will also tweak COPY FROM, but this part of the change should be backwards-compatible. Per pghackers discussion. Also, update COPY reference page to describe the backslash conversions more completely and accurately. 12 February 2002, 21:25:41 UTC
c16ef16 Update FAQ. 12 February 2002, 17:18:10 UTC
d39a369 Update FAQ. 12 February 2002, 17:14:55 UTC
0ae5540 Update wal files computation documentation. 11 February 2002, 23:25:14 UTC
028e13b Tweak GiST code to work correctly on machines where 8-byte alignment of pointers is required. Patch from Teodor Sigaev per pghackers discussion. It's an ugly kluge but avoids forcing initdb; we'll put a better fix into 7.3 or later. 11 February 2002, 22:41:59 UTC
2bd15ad Fix for old FreeBSD versions that don't have RTLD_GLOBAL 11 February 2002, 21:38:11 UTC
6799a6c Repair problems with EvalPlanQual where target table is scanned as inner indexscan (ie, one with runtime keys). ExecIndexReScan must compute or recompute runtime keys even if we are rescanning in the EPQ case. TidScan seems to have comparable problems. Per bug noted by Barry Lind 11-Feb-02. 11 February 2002, 20:10:50 UTC
0cdf4d9 Fix typo. < o prevent lose of indexes, permissions, inheritance (Bruce) --- > o prevent loss of indexes, permissions, inheritance (Bruce) 11 February 2002, 18:14:56 UTC
966e647 Fix flag handling of pg_upgrade. 11 February 2002, 15:19:33 UTC
15c30b6 Be more wary about mixed-case database names and user names. Get the CREATE DATABASE command right in pg_dump -C case. 11 February 2002, 00:18:20 UTC
906254a pg_dump and pg_restore man pages need to mention that one should restore into a virgin database, ie, one created from template0, if there are any site-local additions in template1. 11 February 2002, 00:14:10 UTC
d99fb0d Don't Assert() that fsync() and close() never fail; I have seen this crash on Solaris when over disk quota. Instead, report such failures via elog(DEBUG). 10 February 2002, 22:56:31 UTC
dbb76bf Move sys/types.h to top, for hiroyuki hanai/ FreeBSD. 08 February 2002, 16:30:11 UTC
8c7e189 Upgrade my2pg version 1.23. 08 February 2002, 14:47:56 UTC
c783158 Oops, already completed: < * Have checkpoint process identify itself via ps status display 08 February 2002, 06:41:30 UTC
4af4c50 Added: > * Have checkpoint process identify itself via ps status display 08 February 2002, 04:32:17 UTC
0cc9917 pgstat's truncation of query string needs to be multibyte-aware. Patch from sugita@sra.co.jp. 07 February 2002, 22:20:26 UTC
fe1a9c3 Repair some problems in GIST-index contrib modules. Patch from Teodor Sigaev <teodor@stack.net>. 07 February 2002, 22:11:43 UTC
e206ff5 Removed a check for REINDEX TABLE. 07 February 2002, 00:27:30 UTC
e55b1f9 Fix for parallel make 06 February 2002, 20:29:35 UTC
back to top