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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Marc G.
Fournier
Sent: Tuesday, April 02, 2002 9:08 AM
To: pgsql-announce(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)

> cash I/O improvements (Tom)

If it will change the I/O cash flow to more I than O, it will definitely be
a success... :-)

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk
2000 Frederiksberg Lørdag 11.00-17.00 Email: kar(at)kakidata(dot)dk

"Marc G. Fournier" <scrappy(at)hub(dot)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(at)metweld(dot)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(at)postgresql(dot)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(at)michvhf(dot)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(at)michvhf(dot)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(at)michvhf(dot)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(at)michvhf(dot)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(at)michvhf(dot)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(dot)Elphick(at)lfix(dot)co(dot)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