PostgreSQL 7.4.1 Released

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-announce(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 7.4.1 Released
Date: 2003-12-23 02:56:10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-announce pgsql-general

Its been almost 4 weeks since PostgreSQL 7.4 was released, and, as with
all new releases, several bugs have been identified as administrators
migrate their production databases up from older releases.

As the list of Changes since 7.4 is fairly small, they are included in
this email:

* Fixed bug in "CREATE SCHEMA" parsing in ECPG (Michael)
* Fix compile error when "--enable-thread-safety" and "--with-perl"
are used together (Peter)
* Fix for subqueries that used hash joins (Tom)
* Fix free space map compaction bug (Tom)
* Fix for Borland compiler build of libpq (Bruce)
* Fix netmask() and hostmask() to return the maximum-length masklen
* Several "contrib/pg_autovacuum" fixes
* Allow compile of "contrib/cube" under Cygwin (Jason Tishler)
* Fix Solaris use of password file when no passwords are defined
* JDBC fix for thread problems, other fixes
* Fix for bytea index lookups (Joe)
* Fix information schema for bit data types (Peter)
* Force zero_damaged_pages to be on during recovery from WAL
* Prevent some obscure cases of "variable not in subplan target
* Make PQescapeBytea and byteaout consistent with each other (Joe)
* Escape bytea output for bytes > 0x7e(Joe)
* Added missing SPI_finish() calls to dblink's
get_tuple_of_interest() (Joe)
* New Czech FAQ
* Fix information schema view constraint_column_usage for foreign
keys (Peter)
* ECPG fixes (Michael)
* Fix bug with multiple IN subqueries and joins in the subqueries
* Alllow COUNT('x') to work (Tom)
* Install ECPG include files for Informix compatibility into
separate directory (Peter)
* Fix SSL memory leak (Neil)
* Prevent "pg_service.conf" from using service name as default
dbname (Bruce)
* Fix local ident authentication on FreeBSD (Tom)

This version, as with most minor versions, does not require a dump/reload
to put into place. That said, there are some changes to the information
schema that require a DROP/reload of that *specific* schema ... please
read the HISTORY file for instruction on how to do this.

As always, this release is available on all our mirrors, viable at:

And, thanks to David Fetter, is also available via BitTorrent at:

Marc G. Fournier Hub.Org Networking Services (
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Browse pgsql-announce by date

  From Date Subject
Next Message Robert Treat 2003-12-29 21:07:09 PostgreSQL Weekly News - December 29th 2003
Previous Message Robert Treat 2003-12-22 16:52:27 == PostgreSQL Weekly News - December 22 2003 ==

Browse pgsql-general by date

  From Date Subject
Next Message kbd 2003-12-23 03:17:33 Re: hardware requirements under Redhat
Previous Message Adrian Klaver 2003-12-23 02:47:45 Re: windows distribution