Re: 7.4.2 release notes

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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