Re: Time for 7.2.1?

Applied to current and 7.2.X.  Thanks.

(No delay for /contrib commits from maintainers.)

---------------------------------------------------------------------------

Teodor Sigaev wrote:
> Sorry, one more patch for tsearch.
> 
> Pleas apply it for 7.2.1 and current CVS.
> 
> Patch fixes using lc.lang instead of lc.lc_ctype.
> Thank you.
> 
> 
> Tom Lane wrote:
> > 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@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
> > 
> > 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@stack.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.tammer@spg.schulergroup.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@sra.co.jp.
> > 
> > 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@stack.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().
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> > 
> > 
> 
> 
> -- 
> Teodor Sigaev
> teodor@stack.net
> 

[ application/gzip is not supported, skipping... ]

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026