PostgreSQL 7.4.2 Now Available ...

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:

* Fix pg_statistics alignment bug that could crash optimizer
* Allow non-super users to update pg_settings
* Fix several optimizer bugs, most of which led to "variable not
found in subplan target lists" errors
* Avoid out-of-memory failure during startup of large multiple index
scan
* Fix multibyte problem that could lead to "out of memory" error
during "COPY IN"
* Fix problems with "SELECT INTO" / "CREATE TABLE AS" from tables
without OIDs
* Fix problems with "alter_table" regression test during parallel
testing
* Fix problems with hitting open file limit, especially on OS X
(Tom)
* Partial fix for Turkish-locale issues
* Make pg_dump set client encoding on restore
* Other minor pg_dump fixes
* Allow ecpg to again use 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 other ecpg fixes (Michael)
* Fixes for Borland compiler
* Thread build improvements (Bruce)
* Various other build fixes
* Various JDBC fixes

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.

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

http://www.postgresql.org/mirrors-www.html

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

http://bt.postgresql.org

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

Marc G. Fournier wrote:

> * Various JDBC fixes
>
I thought JDBC wasn't in the tarball anymore. Or does that start with 7.5?

On Wed, 10 Mar 2004, Joseph Shraibman wrote:

> Marc G. Fournier wrote:
>
> > * Various JDBC fixes
> >
> I thought JDBC wasn't in the tarball anymore. Or does that start with 7.5?

7.5

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

Just a quick note to express my thanks.

Great job folks. Issues I had with 7.3.5 have been fixed (pg_dump and
dependancies) and the upgrade was quick and easy.

Keep up the good work.

Tim.

Marc G. Fournier wrote:
> 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:
>
> * Fix pg_statistics alignment bug that could crash optimizer
> * Allow non-super users to update pg_settings
> * Fix several optimizer bugs, most of which led to "variable not
> found in subplan target lists" errors
> * Avoid out-of-memory failure during startup of large multiple index
> scan
> * Fix multibyte problem that could lead to "out of memory" error
> during "COPY IN"
> * Fix problems with "SELECT INTO" / "CREATE TABLE AS" from tables
> without OIDs
> * Fix problems with "alter_table" regression test during parallel
> testing
> * Fix problems with hitting open file limit, especially on OS X
> (Tom)
> * Partial fix for Turkish-locale issues
> * Make pg_dump set client encoding on restore
> * Other minor pg_dump fixes
> * Allow ecpg to again use 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 other ecpg fixes (Michael)
> * Fixes for Borland compiler
> * Thread build improvements (Bruce)
> * Various other build fixes
> * Various JDBC fixes
>
> 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.
>
> As always, this release is available on all our mirrors, viable at:
>
> http://www.postgresql.org/mirrors-www.html
>
> And, thanks to David Fetter, is also available via BitTorrent at:
>
> http://bt.postgresql.org
>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> Marc G. Fournier wrote:
>> * Various JDBC fixes
>>
> I thought JDBC wasn't in the tarball anymore. Or does that start with 7.5?

7.5. The JDBC guys have been very good about back-patching stuff into
the 7.4 tree, even though it's now a separate CVS archive and thus extra
trouble for them. Thanks guys!

regards, tom lane