New News Entry

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?173

Submitted by: press@postgresql.org
Headline: PostgreSQL 7.4.2 Released
Summary:

7.4.2, a \"bugfix\" release in the 7.4 version branch, is now available.  Please note that this upgrade requires some
additionalsteps.    

Story:

After several fixes were backpatches to the 7_4_STABLE branch, we have now
released a 7.4.2.  As the list of Changes since 7.4.2 is quite small, they
are included in this email:
<p>
WARNING: Unlike most minor versions, this version does require some updates to the
pg_* system tables.  Full instructions for how to do this are included in
the full HISTORY file.  <i>Do not upgrade without reading these instructions</i>
<p>
     * Fix pg_statistics alignment bug that could crash optimizer<br>
     * Allow non-super users to update pg_settings<br>
     * Fix several optimizer bugs, most of which led to \"variable not
       found in subplan target lists\" errors<br>
     * Avoid out-of-memory failure during startup of large multiple index
       scan<br>
     * Fix multibyte problem that could lead to \"out of memory\" error
       during \"COPY IN\"<br>
     * Fix problems with \"SELECT INTO\" / \"CREATE TABLE AS\" from tables
       without OIDs<br>
     * Fix problems with \"alter_table\" regression test during parallel
       testing<br>
     * Fix problems with hitting open file limit, especially on OS X
       (Tom)<br>
     * Partial fix for Turkish-locale issues<br>
     * Make pg_dump set client encoding on restore<br>
     * Other minor pg_dump fixes<br>
     * Allow ecpg to again use C keywords as column names (Michael)<br>
     * Added ecpg WHENEVER NOT_FOUND to SELECT/INSERT/UPDATE/DELETE (Michael)<br>
     * Fix ecpg crash for queries calling set-returning functions (Michael)<br>
     * Various other ecpg fixes (Michael)<br>
     * Fixes for Borland compiler<br>
     * Thread build improvements (Bruce)<br>
     * Various other build fixes<br>
     * Various JDBC fixes<br>
<p>
As always, this release is <a href=\"http://www.postgresql.org/mirrors-www.html\">available on all our
mirrors.</a>        
<p>
And, thanks to David Fetter, is also <a href=\"http://bt.postgresql.org\">available via BitTorrent.</a>