Thread: == PostgreSQL Weekly News - June 15th 2004 ==

== PostgreSQL Weekly News - June 15th 2004 ==

From
Robert Treat
Date:
== PostgreSQL Weekly News - June 15th 2004 ==

        Well the big news for the week was the release of PostgreSQL 7.4.3
today. It should be arriving soon at your local ftp mirror if it hasn't
arrived already, or you can download load it via BitTorrent
(http://bt.postgresql.org/) if you are so inclined. Release notes are
included in the full announcement at http://www.postgresql.org/news/200.html,
and as a reminder those upgrading from other 7.4.x versions of PostgreSQL do
not need to dump/reload.

        Back in the world of 7.5, we've come another week closer to the
proposed feature freeze date and still a lot of hacking going on as people
try to finish up their patches before beta. The list of changes that did make
it in is relatively short, so let's take a quick run through. Start and stop
times were added to pg_dump/pg_dumpall when --verbose output is used. Support
for assignment to subfields of composite columns in UPDATE and INSERT
statements was added. This also now allows updating an element of an array
value that is NULL to produce a non-null result. Planning of unnamed
statements via the extended query protocol underwent some optimizations to
improve plan quality when using out-of-line parameters instead of literal
values. The inet/cidr datatypes were given their own hash function that
ignores the inet vs. cdir type bit, enabling their proper use in hash joins
and hash aggregation.

        One last note, a new Brazilian version of the FAQ has been added to
CVS and the website, thanks to Euler Taveira de Oliveira. All of or FAQ's are
available at http://www.postgresql.org/docs/#faqs, and we are always looking
for new translations in case you don't see your favorite language
represented.



== PostgreSQL Product News ==

Updated Cygwin Package: postgresql-7.4.2-1
http://archives.postgresql.org/pgsql-announce/2004-06/msg00007.php

Native PostgreSQL driver for OpenOffice.org
http://archives.postgresql.org/pgsql-announce/2004-06/msg00008.php

pqa v1.1 released.
http://pgfoundry.org/forum/forum.php?forum_id=98



== PostgreSQL In the News ==

An interview with Jim Wilson
http://techdocs.postgresql.org/techdocs/interview-wilson.php

SQL Transaction Misunderstandings (blog)
http://mark.aufflick.com/dev-blog/one-entry?entry%5fid=1498


== Upcoming Events ==

LinuxTag 2004: Karlsruhe, Germany: June 23-26
There will be a PostgreSQL booth and multiple presentations
http://www.postgresql.org/events/195.html

European Regional Open Source Conference: Yerevan, Armenia: June 28-30
Bruce Momjian will be speaking at the Conferance
http://www.opensourcearmenia.com/osconference

OSCon: Portland, OR. USA: July 26-30
There will be a PostgreSQL Track with many community members participating.
http://conferences.oreillynet.com/os2004/



== PostgreSQL Weekly News - June 15th 2004 ==
Don't forget to read Elein Mustain's Weekly Summary of the PostgreSQL
General Mailing List http://www.varlena.com/GeneralBits/

On the Web:
http://www.postgresql.org
http://advocacy.postgresql.org


Correction !! Re: == PostgreSQL Weekly News - June 15th 2004 ==

From
Robert Treat
Date:
On Tue, 2004-06-15 at 14:25, Robert Treat wrote:
> == PostgreSQL Weekly News - June 15th 2004 ==
>
>         Well the big news for the week was the release of PostgreSQL 7.4.3
> today. It should be arriving soon at your local ftp mirror if it hasn't
> arrived already, or you can download load it via BitTorrent
> (http://bt.postgresql.org/) if you are so inclined. Release notes are
> included in the full announcement at http://www.postgresql.org/news/200.html,
> and as a reminder those upgrading from other 7.4.x versions of PostgreSQL do
> not need to dump/reload.
>

Sorry folks, but after a quick discussion we've decided the above needed
some clarification. There are changes incorporated in 7.4.3 that do
require updates to the system catalogs (these are the same changes that
were in 7.4.2) so users upgrading from 7.4.0 or 7.4.1 may want to do an
dump/initdb/reload cycle.

For more information (and as a general rule of thumb) please check out
the previous release notes of those versions that are relevant to your
upgrade. All of the release notes are made available in the online
documentation at http://www.postgresql.org/docs/7.4/static/release.html

Thanks again, and sorry for the confusion.


Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL