Thread: v7.2.1 Released: Critical Bug Fix
Over this past weekend, the PostgreSQL Global Development Group packaged
up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release, it
fixes a critical bug in v7.2:
sequence counters will go backwards after a crash
Other fixes since v7.2 include:
Fix pgaccess kanji-coversion key binding (Tatsuo)
Optimizer improvements (Tom)
cash I/O improvements (Tom)
New Russian FAQ
Compile fix for missing AuthBlockSig (Heiko)
Additional time zones and time zone fixes (Thomas)
Allow psql \connect to handle mixed case database and user names (Tom)
Return proper OID on command completion even with ON INSERT rules (Tom)
Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo)
Fix bug in extract/date_part for milliseconds/microseconds (Tatsuo)
Improve handling of multiple UNIONs with different lengths (Tom)
contrib/btree_gist improvements (Teodor Sigaev)
contrib/tsearch dictionary improvements, see README.tsearch for
an additional installation step (Thomas T. Thai, Teodor Sigaev)
Fix for array subscripts handling (Tom)
Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
Upgrading to v7.2.1 from v7.2 *does not* require a dump/reload, but it is
required from all previous releases ...
Due to the nature of the bug with the sequence counters, it is *highly*
recommended that anyone running v7.2 upgrade to the latest version at
their earliest convience ...
Marc G. Fournier
I was wondering if it is documented as to exactly how to do a minor
upgrade. I've not been able to find it in the past, and I end up doing
a full install, dump/reload. I'm running postgresql on nt/2000 using
cygwin. Thanks -Dean
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Marc G.
Fournier
Sent: Tuesday, April 02, 2002 9:08 AM
To: pgsql-announce@postgresql.org
Cc: pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
Subject: [GENERAL] v7.2.1 Released: Critical Bug Fix
Over this past weekend, the PostgreSQL Global Development Group packaged
up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release,
it fixes a critical bug in v7.2:
sequence counters will go backwards after a crash
Other fixes since v7.2 include:
Fix pgaccess kanji-coversion key binding (Tatsuo)
Optimizer improvements (Tom)
cash I/O improvements (Tom)
New Russian FAQ
Compile fix for missing AuthBlockSig (Heiko)
Additional time zones and time zone fixes (Thomas)
Allow psql \connect to handle mixed case database and user names (Tom)
Return proper OID on command completion even with ON INSERT rules (Tom)
Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo) Fix bug in
extract/date_part for milliseconds/microseconds (Tatsuo) Improve
handling of multiple UNIONs with different lengths (Tom)
contrib/btree_gist improvements (Teodor Sigaev) contrib/tsearch
dictionary improvements, see README.tsearch for
an additional installation step (Thomas T. Thai, Teodor Sigaev) Fix
for array subscripts handling (Tom) Allow EXECUTE of "CREATE TABLE AS
... SELECT" in PL/PgSQL (Tom)
Upgrading to v7.2.1 from v7.2 *does not* require a dump/reload, but it
is required from all previous releases ...
Due to the nature of the bug with the sequence counters, it is *highly*
recommended that anyone running v7.2 upgrade to the latest version at
their earliest convience ...
Marc G. Fournier
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
"Marc G. Fournier" <scrappy@hub.org> writes:
> Over this past weekend, the PostgreSQL Global Development Group packaged
> up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release, it
> fixes a critical bug in v7.2:
> sequence counters will go backwards after a crash
It seems worth pointing out that said bug is not new in 7.2; it has
existed in all 7.1.* releases as well.
If you were looking for a reason to update to 7.2.* from 7.1.*, this
might be a good one.
regards, tom lane
"Dean Hill" <dean@metweld.com> writes: > I was wondering if it is documented as to exactly how to do a minor > upgrade. I've not been able to find it in the past, and I end up doing > a full install, dump/reload. I'm running postgresql on nt/2000 using > cygwin. Thanks -Dean Minor upgrades do not require a dump/restore; the on-disk file format remains the same. -Doug -- Doug McNaught Wireboard Industries http://www.wireboard.com/ Custom software development, systems and network consulting. Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...
Generally, what is the duration between such an announcement and the appearence of the RPMs found on the Download PostgreSQL page? Also, the http://www.us.postgresql.org/news.html has no mention of this upgrade. Thanks. Richard "Marc G. Fournier" wrote: > Over this past weekend, the PostgreSQL Global Development Group packaged > up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release, it > fixes a critical bug in v7.2: > > sequence counters will go backwards after a crash > > Other fixes since v7.2 include: > > Fix pgaccess kanji-coversion key binding (Tatsuo) > Optimizer improvements (Tom) > cash I/O improvements (Tom) > New Russian FAQ > Compile fix for missing AuthBlockSig (Heiko) > Additional time zones and time zone fixes (Thomas) > Allow psql \connect to handle mixed case database and user names (Tom) > Return proper OID on command completion even with ON INSERT rules (Tom) > Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo) > Fix bug in extract/date_part for milliseconds/microseconds (Tatsuo) > Improve handling of multiple UNIONs with different lengths (Tom) > contrib/btree_gist improvements (Teodor Sigaev) > contrib/tsearch dictionary improvements, see README.tsearch for > an additional installation step (Thomas T. Thai, Teodor Sigaev) > Fix for array subscripts handling (Tom) > Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom) > > Upgrading to v7.2.1 from v7.2 *does not* require a dump/reload, but it is > required from all previous releases ... > > Due to the nature of the bug with the sequence counters, it is *highly* > recommended that anyone running v7.2 upgrade to the latest version at > their earliest convience ... > > Marc G. Fournier > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
On Tue, 2 Apr 2002, Richard Emberson wrote: > Generally, what is the duration between such an announcement and the > appearence of > the RPMs found on the Download PostgreSQL page? > > Also, the http://www.us.postgresql.org/news.html has no mention of this It takes up to 24 hours for all of the mirror sites to catch up. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
Vince Vielhaber <vev@michvhf.com> writes: > On Tue, 2 Apr 2002, Richard Emberson wrote: >> Generally, what is the duration between such an announcement and the >> appearence of >> the RPMs found on the Download PostgreSQL page? >> >> Also, the http://www.us.postgresql.org/news.html has no mention of this > It takes up to 24 hours for all of the mirror sites to catch up. However, the tarballs were uploaded to the FTP sites several days ago, so you should be able to fetch the code already from any FTP mirror, even if your favorite WWW mirror is still behind. Look under source/v7.2.1/ if you do not see a v7.2.1 link at the top level of your FTP mirror. regards, tom lane
On Tue, 2 Apr 2002, Tom Lane wrote: > Vince Vielhaber <vev@michvhf.com> writes: > > On Tue, 2 Apr 2002, Richard Emberson wrote: > >> Generally, what is the duration between such an announcement and the > >> appearence of > >> the RPMs found on the Download PostgreSQL page? > >> > >> Also, the http://www.us.postgresql.org/news.html has no mention of this > > > It takes up to 24 hours for all of the mirror sites to catch up. > > However, the tarballs were uploaded to the FTP sites several days ago, > so you should be able to fetch the code already from any FTP mirror, > even if your favorite WWW mirror is still behind. > Look under source/v7.2.1/ if you do not see a v7.2.1 link at the top > level of your FTP mirror. The links didn't exist until just a little while ago so most of the mirrors won't have them yet. source/v7.2.1 does exist tho. RPMs aren't available yet. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
On Tue, 2002-04-02 at 18:26, Tom Lane wrote: > Vince Vielhaber <vev@michvhf.com> writes: > > On Tue, 2 Apr 2002, Richard Emberson wrote: > >> Generally, what is the duration between such an announcement and the > >> appearence of > >> the RPMs found on the Download PostgreSQL page? > >> > >> Also, the http://www.us.postgresql.org/news.html has no mention of this > > > It takes up to 24 hours for all of the mirror sites to catch up. > > However, the tarballs were uploaded to the FTP sites several days ago, > so you should be able to fetch the code already from any FTP mirror, > even if your favorite WWW mirror is still behind. > Look under source/v7.2.1/ if you do not see a v7.2.1 link at the top > level of your FTP mirror. A Debian release of 7.2.1 is now in the Debian unstable archive. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "No temptation has seized you except what is common to man. And God is faithful; he will not let you be tempted beyond what you can bear. But when you are tempted, he will also provide a way out so that you can stand up under it." I Corinthians 10:13