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