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