7.4.2 release notes

Started by Bruce Momjianalmost 22 years ago6 messages
#1Bruce Momjian
pgman@candle.pha.pa.us

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
#2Andrew Sullivan
ajs@crankycanuck.ca
In reply to: Bruce Momjian (#1)
Re: 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

#3Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Andrew Sullivan (#2)
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
#4Andrew Sullivan
ajs@crankycanuck.ca
In reply to: Bruce Momjian (#3)
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

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Andrew Sullivan (#4)
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
#6Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#1)
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