== PostgreSQL Weekly News - July 03 2006 ==

== PostgreSQL Weekly News - July 03 2006 ==

In CVS TIP:

Greg Stark added a feature called INCLUDING CONSTRAINTS to CREATE
TABLE LIKE.

Christopher Kings-Lynne added a PQescapeIdentifier() function to
libpq.

Tom Lane changed the ROW() constructor syntax so that list
elements foo.* get expanded to a list of their member fields
rather than creating a nested rowtype field as before. The old
behavior is still available by omitting '.*'. You can now check
thing like "IF ROW(NEW.*) IS DISTINCT FROM ROW(OLD.*)" in a
trigger or rule.

Teodor Sigaev changed the split algorithm for GiST per his
earlier proposal.
http://archives.postgresql.org/pgsql-hackers/2006-06/msg00254.php

Tom Lane removed the 'stats buffer' process, letting backend stats
messages be delivered directly to the collector process. This
should result in a performance increase.

== PostgreSQL Product News ==

Pgpool 3.1 released.
http://pgpool.projects.PostgreSQL.org

MicroOLAP Database Designer for PostgreSQL ver.1.1.0 released.
http://microolap.com/products/database/postgresql-designer/

EMS Data Generator 2005 for PostgreSQL ver. 2.2 released.
http://www.sqlmanager.net/products/postgresql/datagenerator/

== PostgreSQL Local ==

Greater Los Angeles PostgreSQL users now have a PUG.
http://pugs.postgresql.org/lapug/

PDXPUG is reactivated. Find out more at
http://pugs.postgresql.org/pdx/

== PostgreSQL in the News ==

David Wheeler has published an article on PL/PgSQL at
http://www.onlamp.com/pub/a/onlamp/2006/06/29/many-to-many-with-plpgsql.html

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter