
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



Tue, 2 Apr 2002 10:08:05 -0400 (AST)
"Marc G. Fournier" <scrappy@hub.org>
v7.2.1 Released: Critical Bug Fix
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)


Tue, 2 Apr 2002 09:39:55 -0500
"Dean Hill" <dean@metweld.com>
Re: v7.2.1 Released: Critical Bug Fix
>  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@kakidata.dk 

Tue, 02 Apr 2002 15:12:02 GMT
"Kaare Rasmussen" <kar@kakidata.dk>
Re: v7.2.1 Released: Critical Bug Fix
"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

Tue, 02 Apr 2002 10:36:37 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: v7.2.1 Released: Critical Bug Fix 
"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...

02 Apr 2002 10:56:36 -0500
Doug McNaught <doug@wireboard.com>
Re: v7.2.1 Released: Critical Bug Fix
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)


Tue, 02 Apr 2002 09:00:11 -0800
Richard Emberson <emberson@phc.net>
Re: v7.2.1 Released: Critical Bug Fix
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
==========================================================================




Tue, 2 Apr 2002 12:04:41 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: v7.2.1 Released: Critical Bug Fix
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

Tue, 02 Apr 2002 12:26:45 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: v7.2.1 Released: Critical Bug Fix 
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
==========================================================================




Tue, 2 Apr 2002 12:30:36 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: v7.2.1 Released: Critical Bug Fix 
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
03 Apr 2002 06:48:20 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: [HACKERS] v7.2.1 Released: Critical Bug Fix