Обсуждение: 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
statisticsalignment bug that could affect optimizer, initdb required (Tom) * Optimizer improvements (Tom) *
Permissionfix for view updates (Tom) * Allow non-super users to update pg_settings (Tom) * Fix for multibyte
handlingin position() (Korea PostgreSQL Users' Group) * Various multibyte fixes * Fix problem with hitting
openfile limit, especially on OS X (Tom) * Have pg_dump set client encoding on restore (Tom) * Allow ecpg to
againuse 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,
Pennsylvania19073
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
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, Pennsylvania19073
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@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
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