X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 01B8D5E46EC for ; Fri, 20 Aug 2004 10:22:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08393-05 for ; Fri, 20 Aug 2004 13:22:01 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 5731E5E46F1 for ; Fri, 20 Aug 2004 10:21:55 -0300 (ADT) Received: (qmail 21963 invoked by uid 500); 20 Aug 2004 13:30:27 -0000 Date: Fri, 20 Aug 2004 08:30:27 -0500 From: Bruno Wolff III To: Paul Tilles Cc: interfaces Subject: Re: Version 7.4.4 Message-ID: <20040820133027.GF20737@wolff.to> Mail-Followup-To: Paul Tilles , interfaces References: <4125EDCC.553D7AF9@noaa.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4125EDCC.553D7AF9@noaa.gov> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/26 X-Sequence-Number: 5074 On Fri, Aug 20, 2004 at 08:25:48 -0400, Paul Tilles wrote: > I see references this week to a Version 7.4.4. > > What's new in this version? Is there a website where I can view the > changes of each PostgreSQL revision (including 7.4.4)? 7.4.4 isn't going to happen. Another serious bug was found after it was wrapped and some unofficial rpms were created. So the next release will be 7.4.5. It should be announced shortly. (Probably within a day if no problems are found with the wrapped version being checked out now.) You will definitely want to upgrade to 7.4.5 from any previous 7.4.* release as a potential data corruption problem after a crash is fixed in this version. The release notes are as follows (most sgml markup not removed): Release 7.4.5 Release date 2004-08-18 This release contains one serious bug fix over 7.4.4. Migration to version 7.4.5 A dump/restore is not required for those running 7.4.X. Changes Repair possible crash during concurrent btree index insertions This patch fixes a rare case in which concurrent insertions into a btree index could result in a server panic. No permanent damage would result, but it's still worth a re-release. The bug does not exist in pre-7.4 releases. Release 7.4.4 Release date 2004-08-16 This release contains a variety of fixes from 7.4.3. Migration to version 7.4.4 A dump/restore is not required for those running 7.4.X. Changes Prevent possible loss of committed transactions during crash Due to insufficient interlocking between transaction commit and checkpointing, it was possible for transactions committed just before the most recent checkpoint to be lost, in whole or in part, following a database crash and restart. This is a serious bug that has existed since PostgreSQL 7.1. Check HAVING restriction before evaluating result list of an aggregate plan Avoid crash when session's current userID is deleted Fix hashed crosstab for zero-rows case (Joe) Force cache update after renaming a column in a foreign key Pretty-print UNION queries correctly Make psql handle \r\n newlines properly in COPY IN pg_dump handled ACLs with grant options incorrectly Fix thread support for OS X and Solaris Updated JDBC driver (build 215) with various fixes ECPG fixes Translation updates (various contributors)