== PostgreSQL Weekly News - July 09 2006 ==

The PostgreSQL Conference has been a smashing success. Full coverage
at
http://blogs.ittoolbox.com/unix/bsd/archives/postgresql-summit-day-1-10382

As a follow-up to the PostgreSQL Conference, the Code Sprint starts
tomorrow (Monday) bright and early at 09:00 in Toronto.
http://pgsprint.wetpaint.com/

EnterpriseDB has started a fund to sponsor development of PostgreSQL,
with an initial donation of USD 25,000.
http://enterprisedb.com/news_events/press_releases/06_07_06.do

== PostgreSQL Product News ==

Bizgres MPP 2.2 released.
http://www.bizgres.org/

== PostgreSQL Jobs for July ==

http://archives.postgresql.org/pgsql-jobs/2006-07/threads.php

== PostgreSQL Local ==

Everything this week was global.

== PostgreSQL in the News ==

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

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

Hello,

MicroOLAP Technologies company is glad to announce the version 1.1.0 of
the Database Designer for PostgreSQL.

http://www.microolap.com/products/database/postgresql-designer/

Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical
interface allowing you to build a clear and effective database structure visually,
see the complete picture (diagram) representing all the tables, references between
them, views, stored procedures and other objects. Then you can easily generate a
physical database on a server, modify it according to any changes you made to the
diagram using fast ALTER statements.

What's new:

[+] Color Palette added
[+] Rules support for Views and Tables added
[+] New help system

[-] Reverse Enginnering adopted for latest PostgreSQL server changes
[-] Internal SQL validator improved
[-] "Wrong reverse engeeniring of the table where some columns were previously
dropped" bug...