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

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

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

        After a flurry of activity last week, things settled down a bit this
week. A lot of focus is still on rounding out the rough edges of some of the
bigger features, as well as getting in those changes that folks had been
putting off for a while. A few alpha level bug tests have also started to
trickle in, and you can expect this pre-emptive bug fixing to continue before
we get to an official beta.

        The btree index building process was modified to not use shared
buffers, thereby avoiding locking conflict against concurrent checkpoints.
Also the mechanics of WAL-logging index builds were modified to allow for
quicker index build times in some cases. Server side functions to send INT
and TERM signals to other backends were committed. The timezone libraries
were adjusted to remove some boundary behavior issues on the edges of 32-bit
time range (1901 and 2038).

        Some more work was done to enable plpgsql to pass composite-type
arguments into SQL expressions, including allowing assignment to whole-row
variables. In a similar vein, most of the back-end has now been made safe for
composite-type columns in tables. There is still some settling that needs to
happen (such as support in the ALTER TABLE command or the exact syntax for
UPDATE) but the code and documentation is now in cvs so it is publicly
accessable.



== PostgreSQL Product News ==

SRA America Releases Win32 Version of PostgreSQL
http://www.postgresql.org/news/195.html

phpPgAdmin 3.4 Released
http://archives.postgresql.org/pgsql-announce/2004-06/msg00002.php

Slony-I Replication Solution enters BETA
http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=174

AquaFold strengthens Linux Desktop for database developers
http://www.linuxpr.com/releases/6938.html

Uwerkz Updates DataWerkz With Table Summaries
http://www.macobserver.com/article/2004/06/04.8.shtml

.com Solutions Inc. Adds PostgreSQL support for CGIScripter 2.08
http://www.emediawire.com/releases/2004/6/emw131878.htm



== PostgreSQL In the News ==

FOSS footy tips an all-round star
http://www.smh.com.au/articles/2004/06/07/1086460218113.html

Database Replication and the old Beta versus VHS thing (blog)
http://www.arachna.com/roller/page/spidaman/20040604#database_replication_and_the_old



== Upcoming Events ==

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 7th 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