== PostgreSQL Weekly News - October 04 2009 ==

== PostgreSQL Weekly News - October 04 2009 ==

== PostgreSQL Product News ==

Bucardo 4.2.1, a replication system with dual-master capability, released.
http://bucardo.org/wiki/Bucardo

pgpool-II 2.2.5, a connection pooler and more, released.
http://pgfoundry.org/projects/pgpool/

Marc Balmer has put up a German language wiki at
http://www.postgres-support.com/

Wordpress has a plugin that makes it work with PostgreSQL.
http://wordpress.org/extend/plugins/postgresql-for-wordpress/

== PostgreSQL Jobs for October ==

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

== PostgreSQL Local ==

There will be a conference in Seattle, Washington, USA October 16-18,
2009.
http://www.postgresqlconference.org/2009/west

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state. Registration open!
http://pgcon.postgresql.org.br/2009/

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

Michael Meskes committed:

- In pgsql/src/interfaces/ecpg/preproc/README.parser, added some
explanation about how the parser is generated, taken from an email
by Zoltan Boszormenyi.

- In ECPG, applied patch by Zoltan Boszormenyi to fix memory leak in
decimal handling.

Andrew Dunstan committed:

- In pgsql/src/pl/plperl/plperl.c, convert a perl array to a postgres
array when returned by Set Returning Functions as well as +non SRFs.
Backpatch to 8.1 where these facilities were introduced. with a
little help from Abhijit Menon-Sen.

Tom Lane committed:

- Fix equivclass.c's not-quite-right strategy for handling X=X
clauses. The original coding correctly noted that these aren't just
redundancies (they're effectively X IS NOT NULL, assuming = is
strict). However, they got treated that way if X happened to be in
a single-member EquivalenceClass already, which could happen if
there was an ORDER BY X clause, for instance. The simplest and most
reliable solution seems to be to not try to process such clauses
through the EquivalenceClass machinery; just throw them back for
traditional processing. The amount of work that'd be needed to be
smarter than that seems out of proportion to the benefit. Per bug
#5084 from Bernt Marius Johnsen, and analysis by Andrew Gierth.

- Allow MOVE FORWARD n, MOVE BACKWARD n, MOVE FORWARD ALL, MOVE
BACKWARD ALL in plpgsql. Clean up a couple of corner cases in the
MOVE/FETCH syntax. Pavel Stehule.

- Assorted improvements in contrib/hstore. Remove the 64K limit on
the lengths of keys and values within an hstore. (This changes the
on-disk format, but the old format can still be read.) Add support
for btree/hash opclasses for hstore --- this is not so much for
actual indexing purposes as to allow use of GROUP BY, DISTINCT, etc.
Add various other new functions and operators. Andrew (RhodiumToad)
Gierth.

- In pgsql/contrib/hstore/hstore_op.c, fix bogus Assert, per buildfarm
results.

- Support "samehost" and "samenet" specifications in pg_hba.conf, by
enumerating the machine's IP interfaces to look for a match. Stef
Walter.

- Fix erroneous handling of shared dependencies (ie dependencies on
roles) in CREATE OR REPLACE FUNCTION. The original code would
update pg_shdepend as if a new function was being created, even if
it wasn't, with two bad consequences: pg_shdepend might record the
wrong owner for the function, and any dependencies for roles
mentioned in the function's ACL would be lost. The fix is very
easy: just don't touch pg_shdepend at all when doing a function
replacement. Also update the CREATE FUNCTION reference page, which
never explained exactly what changes and doesn't change in a
function replacement. In passing, fix the CREATE VIEW reference
page similarly; there's no code bug there, but the docs didn't say
what happens.

- Make sure that GIN fast-insert and regular code paths enforce the
same tuple size limit. Improve the error message for
index-tuple-too-large so that it includes the actual size, the
limit, and the index name. Sync with the btree occurrences of the
same error. Back-patch to 8.4 because it appears that the
out-of-sync problem is occurring in the field. Teodor Sigaev and
Tom Lane.

- In pgsql/src/backend/postmaster/pgstat.c, fix an oversight in an
8.3-era patch: pgstat_initstats should allow stats to be collected
for sequences. Report and fix by Akira Kurosawa.

- Fix a couple of issues in recent patch to print updates to
postgresql.conf settings: avoid calling superuser() in contexts
where it's not defined, don't leak the transient copies of
GetConfigOption output, and avoid the whole exercise in postmaster
child processes. I found that actually no current caller of
GetConfigOption has any use for its internal check of
GUC_SUPERUSER_ONLY. But rather than just remove that entirely, it
seemed better to add a parameter indicating whether to enforce the
check. Per report from Simon and subsequent testing.

- In pgsql/src/backend/libpq/hba.c, fix assorted memory leaks in
pg_hba.conf parsing. Over a sufficiently large number of SIGHUP
cycles, these would have run the postmaster out of memory. Noted
while testing memory-leak scenario in postgresql.conf
configuration-change-printing patch.

Peter Eisentraut committed:

- In pgsql/doc/src/sgml/stylesheet.dsl, add tooltips to the header
links, and make title a link to the home page based on an idea by
Richard Huxton.

Alvaro Herrera committed:

- Ensure that a cursor has an immutable snapshot throughout its
lifespan. The old coding was using a regular snapshot, referenced
elsewhere, that was subject to having its command counter updated.
Fix by creating a private copy of the snapshot exclusively for the
cursor. Backpatch to 8.4, which is when the bug was introduced
during the snapshot management rewrite.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/config.sgml, document the purpose of the GUC
listen_addresses.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Heikki Linnakangas sent in more fixes atop earlier Hot Standby
patches.

Abhijit Menon-Sen sent in another patch to fix return_next in PL/Perl
for arrays.

ITAGAKI Takahiro sent in two more revisions of the patch expanding the
functionality of CREATE TABLE LIKE...

KaiGai Kohei sent in another revision of the large object ACL patch.

Marko (johto) Tiikkaja sent in another revision of the patch to
refactor the executor to have nodes for INSERT, UPDATE and DELETE.
This is among other things infrastructure for the Writeable CTE
feature.

Alvaro Herrera sent in missing files from the patch to add per-ROLE,
per-database GUC settings, then a patch for psql to make it display
same.

Devrim GUNDUZ sent in a doc patch which updates links to some
external projects.

Euler Taveira de Oliveira sent in a reviewed version of ITAGAKI
Takahiro's patch to include buffer usage in EXPLAIN.

Brad T. Sliger sent in a revised version of the patch to allow Unicode
codes for pretty-printing in psql.

KaiGai Kohei sent in a patch atop the ACL rework patch to eliminate
permission checks in FindConversion() and EnableDisableRule().

Alvaro Herrera sent in three more revisions of the per-ROLE,
per-database GUC patch.

Robert Leigh sent in two more revisions of the patch to add UTF8
pretty-printing to psql.

Petr (PJMODOS) Jelinek sent in another revision of the DefaulsACLs
patch and a follow-up patch with adjusted docs.

Laurenz Albe sent in a patch to add a hook for checking password
strength, per discussion.

Heikki Linnakangas sent in another patch for Hot Standby.

David Gould sent in a patch to limit the amount of memory allocated
per session.

Brendan Jurd sent in a patch for the named/mixed notation for
PL/pgsql.

ITAGAKI Takahiro sent in another revision of the buffer usage patch
for EXPLAIN.

Fujii Masao sent in another revision of the Streaming Replication
patch.

Jeff Davis sent in another revision of the mixed/named function
notation patch for PL/pgsql.

Roger Leigh sent in another revision of the Unicode pretty-printing
patch for psql, this time with a switch to change to ASCII format in
UTF-8 locales.

KaiGai Kohei sent in another revision of the ACL rework patch.

Bernd Helmle sent in a patch atop the per-ROLE, per-database GUC
settings patch which adds ALTER ROLE ... IN DATABASE functionality.

Pavel Stehule sent in another revision of the named/mixed PL/pgsql
parameter notation based in part on Brendan Jurd's and Jeff Davis's
patches.

Zoltan Boszormenyi sent in another ECPG patch for Informix
compatibility.

Zoltan Boszormenyi sent another flock of patches for dynamic cursor
names in ECPG.

Alvaro Herrera sent in a patch to remove the useless pushing of an
active snapshot on PortalStart.

Ian Small sent in a patch which does alphagram fuzzy string matching.

Joe Conway sent in a patch to fix a memory leak in dblink.