Time for 7.2.1?

Seems like it's about time to release 7.2.1. We have enough
post-release patches in there that a dot-release is clearly needed
(particularly for the pg_dump-related issues). And it seems like
not too much new stuff is coming in. Does anyone have any issues
outstanding that need to be dealt with before 7.2.1?

regards, tom lane

Post-release patches in the 7.2 branch:

2002-03-05 01:10 momjian

* contrib/tsearch/dict/porter_english.dct (REL7_2_STABLE): 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(at)minnesota(dot)com> for hard testing. This
kind of bug has significance only for dump/reload database and
viewing, but searching/indexing works right.

Teodor Sigaev

2002-03-05 00:13 tgl

* src/backend/optimizer/prep/prepunion.c (REL7_2_STABLE): 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.

2002-03-04 22:45 ishii

* src/: backend/utils/adt/timestamp.c,
test/regress/expected/timestamp.out,
test/regress/expected/timestamptz.out (REL7_2_STABLE): 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

2002-03-04 12:47 tgl

* doc/FAQ_Solaris (REL7_2_STABLE): Update FAQ_Solaris with info
about gcc 2.95.1 problems and how to work around 64-bit vsnprintf
bug.

2002-02-27 18:17 tgl

* src/backend/tcop/postgres.c (REL7_2_STABLE): Back-patch fix for
errors reported at transaction end.

2002-02-26 20:47 ishii

* src/backend/commands/copy.c (REL7_2_STABLE): 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

2002-02-26 18:48 tgl

* src/: backend/commands/command.c, backend/commands/explain.c,
backend/executor/functions.c, backend/executor/spi.c,
backend/nodes/copyfuncs.c, backend/nodes/equalfuncs.c,
backend/nodes/readfuncs.c, backend/parser/analyze.c,
backend/tcop/dest.c, backend/tcop/postgres.c,
backend/tcop/pquery.c, backend/tcop/utility.c,
include/commands/command.h, include/nodes/parsenodes.h,
include/tcop/dest.h, include/tcop/pquery.h, include/tcop/utility.h
(REL7_2_STABLE): 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.

2002-02-25 16:37 tgl

* src/bin/psql/command.c (REL7_2_STABLE): 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.

2002-02-25 15:07 momjian

* src/backend/libpq/auth.c (REL7_2_STABLE): 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

2002-02-25 11:22 thomas

* src/backend/utils/adt/datetime.c (REL7_2_STABLE): 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.

2002-02-22 10:40 momjian

* src/include/libpq/pqsignal.h (REL7_2_STABLE): 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

2002-02-22 08:02 momjian

* doc/: FAQ_russian, src/FAQ/FAQ_russian.html (REL7_2_STABLE):
BACKPATCH:

Add Russian FAQ to 7.2.1. Why not?

2002-02-22 01:08 momjian

* contrib/btree_gist/btree_gist.c (REL7_2_STABLE): 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(at)stack(dot)net

2002-02-19 17:19 tgl

* src/backend/utils/adt/cash.c (REL7_2_STABLE): Avoid failures in
cash_out and cash_words for INT_MIN. Also, 'fourty' -> 'forty'.

2002-02-18 11:04 tgl

* src/backend/commands/analyze.c (REL7_2_STABLE): Replace
number-of-distinct-values estimator equation, per recent pghackers
discussion.

2002-02-17 23:12 ishii

* src/bin/pgaccess/lib/tables.tcl (REL7_2_STABLE): Fix
kanji-coversion key binding. This has been broken since 7.1 Per
Yoshinori Ariie's report.

2002-02-17 08:29 momjian

* doc/src/sgml/ref/alter_table.sgml: Fix SGML typo in previous
patch.

2002-02-17 06:50 momjian

* doc/src/sgml/ref/alter_table.sgml: 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

2002-02-16 18:45 momjian

* doc/src/sgml/ref/alter_table.sgml: Clarify params to ALTER TABLE
to clearly show single parameters.

e.g. table contraint definition -> table_constraint_definition.

2002-02-15 12:46 petere

* src/interfaces/ecpg/preproc/pgc.l: Remove warning about automatic
inclusion of sqlca.

2002-02-14 10:24 tgl

* src/: backend/commands/command.c, backend/executor/spi.c,
backend/utils/mmgr/portalmem.c, include/utils/portal.h: 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.

2002-02-13 14:32 tgl

* doc/src/sgml/ref/createuser.sgml: 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.

2002-02-12 18:39 tgl

* src/backend/port/dynloader/: README.dlfcn.aix, aix.h, bsdi.h,
dgux.h, freebsd.h, irix5.h, linux.h, netbsd.h, openbsd.h, osf.h,
sco.h, solaris.h, sunos4.h, svr4.h, univel.h, unixware.h, win.h:
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.

2002-02-12 17:35 tgl

* doc/FAQ_Solaris: Add warning not to use /usr/ucb/cc on Solaris.

2002-02-12 17:25 momjian

* doc/src/sgml/advanced.sgml: Fix tutorial for references problem,
from rainer(dot)tammer(at)spg(dot)schulergroup(dot)com

2002-02-12 16:25 tgl

* doc/src/sgml/ref/copy.sgml, src/backend/commands/copy.c: 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.

2002-02-11 18:25 momjian

* doc/src/sgml/wal.sgml: Update wal files computation
documentation.

2002-02-11 17:41 tgl

* src/backend/access/gist/gist.c: 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.

2002-02-11 16:38 petere

* src/backend/port/dynloader/freebsd.h: Fix for old FreeBSD
versions that don't have RTLD_GLOBAL

2002-02-11 15:10 tgl

* src/backend/executor/: nodeIndexscan.c, nodeTidscan.c: 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.

2002-02-11 10:19 momjian

* contrib/pg_upgrade/pg_upgrade: Fix flag handling of pg_upgrade.

2002-02-10 19:18 tgl

* src/bin/pg_dump/: common.c, pg_backup.h, pg_backup_archiver.c,
pg_dump.c, pg_dump.h, pg_dumpall.sh: Be more wary about mixed-case
database names and user names. Get the CREATE DATABASE command
right in pg_dump -C case.

2002-02-10 19:14 tgl

* doc/src/sgml/ref/: pg_dump.sgml, pg_restore.sgml: 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.

2002-02-10 17:56 tgl

* src/backend/storage/file/fd.c: 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).

2002-02-08 11:30 momjian

* src/backend/utils/init/findbe.c: Move sys/types.h to top, for
hiroyuki hanai/ FreeBSD.

2002-02-08 09:47 momjian

* contrib/mysql/my2pg.pl: Upgrade my2pg version 1.23.

2002-02-07 17:20 tgl

* src/backend/postmaster/pgstat.c: pgstat's truncation of query
string needs to be multibyte-aware. Patch from sugita(at)sra(dot)co(dot)jp(dot)

2002-02-07 17:11 tgl

* contrib/: intarray/_int.c, tsearch/README.tsearch,
tsearch/gistidx.c, tsearch/tsearch.sql.in: Repair some problems in
GIST-index contrib modules. Patch from Teodor Sigaev
<teodor(at)stack(dot)net>.

2002-02-06 19:27 inoue

* src/backend/tcop/utility.c: Removed a check for REINDEX TABLE.

2002-02-06 15:29 petere

* doc/Makefile: Fix for parallel make

2002-02-06 12:27 tgl

* src/bin/pg_dump/: pg_backup_archiver.c, pg_dump.c: Fix failure to
reconnect as sequence's owner before issuing setval().