Обсуждение: 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