
Here are the 7.4.2 release notes I made.  I have a few question:

What detail do we need on the pg_statistics alignment fix?  Do we need
to show an UPDATE query to fix database?  What are the ramifications of
leaving it alone?

A few categories list "various fixes" for rare fixes we made in a few
areas.  We would not normally spell those out in detail in a major
release, and I assume we wouldn't do that in a minor release either.

I will add comments to a few of them later.

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


                               Release Notes

                               Release 7.4.2

     Release date: 2004-03-??

   This release contains a variety of fixes from 7.4.1.
     _________________________________________________________________

Migration to version 7.4.2

   A dump/restore is *not* required for those running 7.4.X.
     _________________________________________________________________

Changes

   As of 2004-03-02

     * Fix problems with ALTER TABLE during concurrent access (Tom)
     * Improve hash build reliability (Tom)
     * Fix statistics alignment bug that could affect optimizer, initdb
       required (Tom)
     * Optimizer improvements (Tom)
     * Permission fix for view updates (Tom)
     * Allow non-super users to update pg_settings (Tom)
     * Fix for multibyte handling in position() (Korea PostgreSQL Users'
       Group)
     * Various multibyte fixes
     * Fix problem with hitting open file limit, especially on OS X (Tom)
     * Have pg_dump set client encoding on restore (Tom)
     * Allow ecpg to again use C keywords as column names (Michael)
     * Added ecpg WHENEVER NOT_FOUND to SELECT/INSERT/UPDATE/DELETE
       (Michael)
     * Fix ecpg crash for queries calling set-returning functions
       (Michael)
     * Various ecpg fixes (Michael)
     * Fixes for Borland compiler
     * Thread build improvements (Bruce)
     * Fix for configure --disable-shared support (Tom)
     * Various build fixes
     * Various jdbc fixes

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Mar 2004 15:00:18 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
7.4.2 release notes
On Fri, Mar 05, 2004 at 03:00:18PM -0500, Bruce Momjian wrote:
>      _________________________________________________________________
> 
> Migration to version 7.4.2
> 
>    A dump/restore is *not* required for those running 7.4.X.
>      _________________________________________________________________

[ . . . ]

>      * Fix statistics alignment bug that could affect optimizer, initdb
>        required (Tom)

Does this mean that it's optional?  It maybe ought to say so, then,
because as it stands, I'm confused.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
		--Roger Brinner

Fri, 5 Mar 2004 16:08:26 -0500
Andrew Sullivan <ajs@crankycanuck.ca>
Re: 7.4.2 release notes
Andrew Sullivan wrote:
> On Fri, Mar 05, 2004 at 03:00:18PM -0500, Bruce Momjian wrote:
> >      _________________________________________________________________
> > 
> > Migration to version 7.4.2
> > 
> >    A dump/restore is *not* required for those running 7.4.X.
> >      _________________________________________________________________
> 
> [ . . . ]
> 
> >      * Fix statistics alignment bug that could affect optimizer, initdb
> >        required (Tom)
> 
> Does this mean that it's optional?  It maybe ought to say so, then,
> because as it stands, I'm confused.

This is an item that needs clarification, as I mentioned.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Mar 2004 18:26:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 7.4.2 release notes
On Fri, Mar 05, 2004 at 06:26:52PM -0500, Bruce Momjian wrote:
> 
> This is an item that needs clarification, as I mentioned.

Yes, you certainly did.  I apologise, I'm being unusually stupid
today.

-- 
Andrew Sullivan  


Fri, 5 Mar 2004 20:29:17 -0500
Andrew Sullivan <ajs@crankycanuck.ca>
Re: 7.4.2 release notes
Andrew Sullivan wrote:
> On Fri, Mar 05, 2004 at 06:26:52PM -0500, Bruce Momjian wrote:
> > 
> > This is an item that needs clarification, as I mentioned.
> 
> Yes, you certainly did.  I apologise, I'm being unusually stupid
> today.

I looked again and the text mentioned statistics, but my comments
referred to pg_statistic, so it was easy to miss.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Mar 2004 21:23:46 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 7.4.2 release notes
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Here are the 7.4.2 release notes I made.  I have a few question:

> What detail do we need on the pg_statistics alignment fix?  Do we need
> to show an UPDATE query to fix database?  What are the ramifications of
> leaving it alone?

Potential crashes :-(.  I think we must give a detailed procedure for
fixing the problem if you don't initdb.  I am working on that now.

> A few categories list "various fixes" for rare fixes we made in a few
> areas.  We would not normally spell those out in detail in a major
> release, and I assume we wouldn't do that in a minor release either.

That's OK.  One thing I am also changing is to remove the entries that
are duplicates of the items fixed in 7.3.6 --- I think we can just refer
to the 7.3.6 notes instead.

			regards, tom lane

Sun, 07 Mar 2004 15:51:15 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.4.2 release notes 