Peripheral Links
Header And Logo
Site Navigation
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