== PostgreSQL Weekly News - July 27 2008 ==

== PostgreSQL Weekly News - July 27 2008 ==

July's commitfest is nearly over, with lots of new features being
added.

== PostgreSQL Product News ==

Benetl 2.2 released.
http://www.benetl.net

check_postgres 2.1.0 released.
http://bucardo.org/check_postgres/

pgpool-II 2.1 released.
http://pgfoundry.org/frs/shownotes.php?group_id=1000055&release_id=1187

== PostgreSQL Jobs for July ==

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

== PostgreSQL Local ==

Sponsor the European PGDay!
http://www.pgday.org/en/sponsors/campaign

The Call for Papers for European PGDay has begun.
http://www.pgday.org/en/call4papers

pgDay San Francisco will be August 5. Schedule:
http://pugs.postgresql.org/node/447
Register here:
http://www.linuxworldexpo.com/live/12/ehall//SN460564

PGCon Brazil 2008 will be on September 26-27 at Unicamp in Campinas.
http://pgcon.postgresql.org.br/index.en.html

PGDay.(IT|EU) 2008 will be October 17 and 18 in Prato.
http://www.pgday.org/it/

== PostgreSQL in the News ==

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

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot)

== Applied Patches ==

Tom Lane committed:

- In pgsql/src/backend/commands/prepare.c, add comment about the two
different query strings that ExecuteQuery() has to deal with.

- In pgsql/doc/src/sgml/gin.sgml, update link to Oleg and Teodor's GIN
page. (Extracted from fast-insert patch, since it ought to be
back-patched)

- Use guc.c's parse_int() instead of pg_atoi() to parse fillfactor in
default_reloptions(). The previous coding was really a bug because
pg_atoi() will always throw elog on bad input data, whereas
default_reloptions is not supposed to complain about bad input
unless its validate parameter is true. Right now you could only
expose the problem by hand-modifying pg_class.reloptions into an
invalid state, so it doesn't seem worth back-patching; but we should
get it right in HEAD because there might be other situations in
future. Noted while studying GIN fast-update patch.

- In pgsql/src/backend/libpq/hba.c, remove some redundant tests and
improve comments in next_token(). Cosmetic, but it might make this
a bit less confusing to the next reader.

- In pgsql/src/backend/libpq/auth.c, fix parsing of LDAP URLs so it
doesn't reject spaces in the "suffix" part. Per report from Cesar
Miguel Oliveira Alves.

- As noted by Andrew Gierth, there's really no need any more to force
a junk filter to be used when INSERT or SELECT INTO has a plan that
returns raw disk tuples. The virtual-tuple-slot optimizations that
were put in place awhile ago mean that ExecInsert has to do
ExecMaterializeSlot, and that already copies the tuple if it's raw
(and does so more efficiently than a junk filter, too). So get rid
of that logic. This in turn means that we can throw away
ExecMayReturnRawTuples, which wasn't used for any other purpose, and
was always a kluge anyway. In passing, move a couple of
SELECT-INTO-specific fields out of EState and into the private state
of the SELECT INTO DestReceiver, as was foreseen in an old comment
there. Also make intorel_receive use ExecMaterializeSlot not
ExecCopySlotTuple, for consistency with ExecInsert and to possibly
save a tuple copy step in some cases.

Alvaro Herrera committed:

- In pgsql/src/backend/postmaster/autovacuum.c, publish more openly
the fact that autovacuum is working for wraparound protection.
Simon Riggs.

- In pgsql/src/backend/postmaster/autovacuum.c, ratchet up patch to
improve autovacuum wraparound messages. Simon Riggs.

Peter Eisentraut committed:

- Abort if Tcl support was configured and no tcl shell was found.
This is required because the value is substituted into the
pltcl_*mod scripts.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Markus Wanner sent in a patch to rename query_string to prepared_qs.

Robert Lor sent in a revised patch for dtrace probes.

David Gould sent in a patch for pg_dumpall which adds a
--lock-wait-timeout parameter similar to the one he added for pg_dump.

Simon Riggs sent in revision of his patch to make autovacuum report
when it is preventing a transaction ID wraparound for CVS HEAD and
8.3.

Simon Riggs sent in two more revisions of a patch to add
--schema-before-data and --schema-after-data options to pg_dump.

Xiao Meng sent in another version of his patch to improve performance
on hash indexes.

Robert Haas sent in a patch to add a separate permission for TRUNCATE.

Tatsuo Ishii sent in three more revisions of Yoshiyuki Asaba's patch
to implement CTEs.

Simon Riggs sent a patch to add a contrib module which adds a
Transportable Optimizer Mode to PostgreSQL.