== PostgreSQL Weekly News - August 06 2006 ==

== PostgreSQL Weekly News - August 06 2006 ==

Pervasive announced the end of their PostgreSQL support last week.
We're sorry to lose a member of our corporate community who have been
so supportive. Commercial support for PostgreSQL is available from
several other companies. Pervasive will be donating their
documentation and PR collateral to the PostgreSQL community.
http://www.pervasivepostgres.com/letter.asp

The Gorda Project has created a preliminary PostgreSQL implementation
of their database replication.
http://gorda.di.uminho.pt/community

== Applied Patches ==

Michael Meskes committed:

- His patches to ECPG that will support regression tests.

- Implemented EXEC SQL UNDEF.

- Regression test patch by Joachim Wieland.

Tatsuo Ishii committed:

- ITAGAKI Takahiro's fix for an overflow bug in contrib/pgbench.

Bruce Momjian committed:

- Joshua Drake's patch which updates the docs on Maintenance and
External Projects.

- Greg Sabino Mullane's patch which adds regex matching and multiple
-n and -t options to pg_dump.

- Martin Pitt's patch which causes pg_dump not to restore TABLE DATA
objects if the corresponding TABLE object failed to be created.

- A patch which lets people log the parameters when executing prepared
statements. And there was much rejoicing.

Andrew Dunstan committed:

- a patch that causes pg_regress to fall back on testing with the
canonical results file if an alternative test is specified but none
succeeds.

Joe Conway committed:

- his multiple-tuple INSERT, which is now working faster in less RAM
than a certain Swedish company's.

Tom Lane committed:

- a HINT per suggestion from Michael Glaesemann for cases where the
new multiple-tuple INSERT fails.

- Andreas Seltenreich's patch which fixes stats collection for GIN
indexes.

- Michael Fuhr's patch which causes g_trigtuple and tg_newtuple to be
cleared to NULL in AFTER STATEMENT triggers.

- Gavin Sherry's patch which adds regression tests for the new VALUES
features including multiple-tuple INSERTs.

- Joachim Wieland's basic regression tests of GUC behavior.

- A patch which teaches the optimizer to simplify BooleanTest nodes
that have constant input.

- A patch to domain_in() which fixes a bug that Darcy Buskermolen
found.

- A patch per example from Martin Lesser which makes constraint
exclusion work better by extending relation_excluded_by_constraints()
to check for mutually exclusive WHERE clauses. A rename and/or new
GUC variable may be in the works.

- Another patch per example from Martin Lesser which teaches
predicate_refuted_by() how to do proofs involving NOT-clauses. This
helps with the IS NOT TRUE clauses which the rule rewriter tends to
insert.

- A fix to inheritance_planner() to delete dummy subplans from its
Append plan list, when some of the child rels have been excluded by
constraint exclusion. This doesn't save a huge amount of time but
it'll save some, and it makes the EXPLAIN output look saner. This
parallels the equivalent change in set_append_rel_pathlist()

- Simon Riggs's patch that helps do archive timeouts and one which
allows people to force the WAL file to be written out along with
some miscellanea discussed at the conference. Also ways to have
restartable recovery.

Neil Conway committed:

- Michael Fuhr's patch which fixes the pgcrypto documentation.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Jonah Harris submitted his INSERT/UPDATE ... RETURNING patch.

Pavel Stehule sent a patch that improves how PL/Perl uses PostgreSQL
arrays.

Gavin Sherry cleaned up Jie Zhang's on-disk bitmap index patch.

Chris Browne sent in a patch documenting replication options in
PostgreSQL.

Sergey E. Koposov sent in a patch which changes sql_features.txt to
include his multiple-argument aggregates, which complete T-621 of the
SQL:2003 standard.

Ralf Engelschall submitted a patch to allow C extension modules to
call code immediately after pg_dlopen and immediately before
pg_dlclose in a platform-neutral way.

Teodor Sigaev sent in a patch which adds support for typmod to any
type, and adds support for typmod to format_type().

Zoltan Boszormenyi sent in a patch with implements the SQL standard
GENERATED [ALWAYS] AS IDENTITY.

== PostgreSQL Product News ==

PgPool 3.1.1 is out
http://pgfoundry.org/projects/pgpool/

BitRock has released LAPPStack, a software bundle for Linux which
includes PostgreSQL 8.1.4.
http://www.bitrock.com/download_webstacks_download.html

phpPgGIS-4.0.1-4, a web system to manage PostgreSQL and PostGIS, is out.
http://sourceforge.net/projects/phppggis/

Sun and Greenplum have rolled out the Thumper DW date warehouse
appliance.
http://www.informationweek.com/shared/printableArticle.jhtml?articleID=191600197

MicroOLAP Database Designer 1.1.1 for PostgreSQL is out.
http://microolap.com/products/database/postgresql-designer/

== PostgreSQL Jobs for August ==

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

== PostgreSQL Local ==

Everything this week was global.

== PostgreSQL in the News ==

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

General Bits: a Time Travel Update
http://www.varlena.com/GeneralBits/

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