== PostgreSQL Weekly News - October 25 2009 ==

== PostgreSQL Weekly News - October 25 2009 ==

== PostgreSQL Product News ==

once:fabrik, an ERP system based on PostgreSQL, is available for a
free trial until October 31, 2009.
http://www.oncetechnologies.com/

== PostgreSQL Jobs for October ==

http://archives.postgresql.org/pgsql-jobs/2009-10/threads.php

== PostgreSQL Local ==

LISA 09, the Large Installation and Systems Administration conference,
will be held November 1-6, 2009. There will be a Postgres booth
Wednesday and Thursday.
http://www.usenix.org/event/lisa09/

PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
November 6-7, 2009. Registration is open.
http://www.pgday.eu/

OpenSQL Camp in Portland is looking for sponsors. Make your travel plans now! :)
http://www.chesnok.com/daily/2009/07/29/opensql-camp-comes-to-portland-november-14-15-2009/

JPUG 10th Anniversary Conference is November 20-21, 2009 in Tokyo, Japan.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

FOSDEM 2010 will be in Brussels, Belgium on February 6-7, 2010.
http://www.fosdem.org/

Chemnitzer Linuxtage will be in Chemnitz, Germany on March 13-14, 2010.
http://chemnitzer.linux-tage.de/

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

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

Peter Eisentraut committed:

- In pgsql/src/tools/RELEASE_CHANGES, update translation updating
procedure. This pertains to some changes I made to automatically
exclude translations below the 80% minimum.

- Translations update for 8.5alpha2

- In pgsql/doc/src/sgml/release-8.5.sgml, preliminary release notes
for 8.5alpha2.

- In pgsql/doc/src/sgml/release-8.5.sgml, finalize 8.5alpha2 release
notes, with updates from Josh Berkus.

- Version stamp 8.5alpha2.

- When querying a table with child tables, do not check permissions on
the child tables. This was found to be useless and confusing in
virtually all cases, and also contrary to the SQL standard.

Tom Lane committed:

- Remove add_missing_from GUC and associated parser support for
"implicit RTEs". Per recent discussion, add_missing_from has been
deprecated for long enough to consider removing, and it's getting in
the way of planned parser refactoring. The system now always
behaves as though add_missing_from were OFF.

- Remove regex_flavor GUC, so that regular expressions are always
"advanced" style by default. Per discussion, there seems to be
hardly anything that really relies on being able to change the regex
flavor, so the ability to select it via embedded options ought to be
enough for any stragglers. Also, if we didn't remove the GUC, we'd
really be morally obligated to mark the regex functions
non-immutable, which'd possibly create performance issues.

- Re-implement EvalPlanQual processing to improve its performance and
eliminate a lot of strange behaviors that occurred in join cases.
We now identify the "current" row for every joined relation in
UPDATE, DELETE, and SELECT FOR UPDATE/SHARE queries. If an
EvalPlanQual recheck is necessary, we jam the appropriate row into
each scan node in the rechecking plan, forcing it to emit only that
one row. The former behavior could rescan the whole of each joined
relation for each recheck, which was terrible for performance, and
what's much worse could result in duplicated output tuples. Also,
the original implementation of EvalPlanQual could not re-use the
recheck execution tree --- it had to go through a full executor init
and shutdown for every row to be tested. To avoid this overhead,
I've associated a special runtime Param with each LockRows or
ModifyTable plan node, and arranged to make every scan node below
such a node depend on that Param. Thus, by signaling a change in
that Param, the EPQ machinery can just rescan the already-built test
plan. This patch also adds a prohibition on set-returning functions
in the targetlist of SELECT FOR UPDATE/SHARE. This is needed to
avoid the duplicate-output-tuple problem. It seems fairly
reasonable since the other restrictions on SELECT FOR UPDATE are
meant to ensure that there is a unique correspondence between source
tuples and result tuples, which an output SRF destroys as much as
anything else does.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Dave Page sent in two more revisions of the patch to make the
connecting application name available for display and modification via
a GUC.

Dean Rasheed sent in a WIP patch to scale up deferred UNIQUE
constraints.

ITAGAKI Takahiro sent in a patch to implement a process utility hook.

ITAGAKI Takahiro sent in a patch to allow psql to and use Byte Order
Marks.

ITAGAKI Takahiro sent in another revision of a patch which adds the
option to add an SQL:2008-compliant WHEN clause to trigger
definitions.

Marko (johto) Tiikkaja sent in a WIP patch implementing writeable
CTEs.

ITAGAKI Takahiro sent in a WIP patch to make VACUUM FULL unneeded

Magnus Hagander sent in a patch to parse all configuration files in a
directory. This is, among other things, infrastructure for tools
which could manipulate such files.

Roger Leigh sent in three more revisions of the Unicode pretty-print
patch for psql.

Jeff Davis sent in another revision of the operator exclusion
constraints patch.