== PostgreSQL Weekly News - June 13 2010 ==

== PostgreSQL Weekly News - June 13 2010 ==

PostgreSQL 9.0 beta 2 released. Test!
http://www.postgresql.org/developer/beta

New Survey: Which non-replication 9.0 Beta feature is your favorite?
http://www.postgresql.org/community/

The video archive for the December 8, 2009 SFPUG meeting, "Operator
Exclusion Constraints," is now available:
http://thebuild.com/blog/2009/12/23/sfpug-operator-exclusion-constraints/

== PostgreSQL Product News ==

pgnotifyd v0.1, an asynchronous notification processor for PostgreSQL, released.
http://www.pogo.org.uk/~mark/pgnotifyd/

== PostgreSQL Jobs for June ==

http://archives.postgresql.org/pgsql-jobs/2010-06/threads.php

== PostgreSQL Local ==

Michael Renner will be speaking at Netways OSDC in Nuremberg, Germany,
which will be June 23-24, 2010.
http://www.netways.de/osdc/y2010/programm/

CHAR(10), the PostgreSQL Conference on Clustering, High Availability
and Replication is now open for online registration and bookings.
July 2-3 2010, Oriel College, Oxford University, UK
http://www.char10.org/

PDXPUG Day will be July 18, 2010 at the Oregon Convention Center in
Portland, OR. For more information, see:
http://wiki.postgresql.org/wiki/PDXPUGDay2010

OSCON will take place in Portland, Oregon July 19-23, 2010.
http://www.oscon.com/oscon2010

== PostgreSQL in the News ==

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

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

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) Spanish language
to pwn(at)arpug(dot)com(dot)ar(dot)

== Applied Patches ==

Teodor Sigaev committed:

- In pgsql/contrib/dblink/uninstall_dblink.sql, add missed function
dblink_connect_u(text[,text]) to uninstall script

Tom Lane committed:

- In pgsql/src/backend/replication/walreceiver.c, avoid useless
snprintf() call when update_process_title is turned off. Fujii
Masao.

- In pgsql/src/pl/plpython/plpython.c, fix quite-bogus handling of
arrays in plpython datum-to-PyObject conversion. Per bug #5497 from
David Gardner.

- In pgsql/src/bin/scripts/vacuumdb.c, add missing 'Z' letter to
getopt_long call --- the newly added --analyze-only switch did not
work in its short form -Z. Josh Berkus

- In pgsql/doc/src/sgml/Makefile, Postgres.txt should get cleaned by
'make clean'.

Robert Haas committed:

- In pgsql/doc/src/sgml/plhandler.sgml, make procedural language
handler reference C-language function docs. Based on suggestions
from Jonathan Leto and Joshua Tolley.

- In pgsql/src/backend/commands/explain.c, attempt to fix EXPLAIN
(FORMAT YAML) quoting to behave sanely. The previous code failed to
quote in many cases where quoting was necessary - YAML has loads of
special characters, including -:[]{},"'|*& - so quote much more
aggressively, and only refrain from quoting things where it seems
fairly clear that it isn't necessary. Per report from Dean Rasheed.

- In pgsql/src/backend/catalog/pg_largeobject.c, remove stray word
from comment.

- In pgsql/src/backend/commands/explain.c, quote all string values in
EXPLAIN (FORMAT YAML) output. While my previous attempt seems to
always produce valid YAML, it doesn't always produce YAML that means
what it appears to mean, because of tokens like "0xa" and "true",
which without quotes will be interpreted as integer or Boolean
literals. So, instead, just quote everything that's not known to be
a number, as we do for JSON. Dean Rasheed, with some changes to the
comments by me.

- Fix ALTER LARGE OBJECT and GRANT ... ON LARGE OBJECT for large OIDs.
The previous coding failed for OIDs too large to be represented by a
signed integer.

- In pgsql/doc/src/sgml/release-9.0.sgml, fix typo.

- In pgsql/doc/src/sgml/release-9.0.sgml, fix misplaced modifier. As
suggested by Ian Barwick.

Tatsuo Ishii committed:

- In pgsql/src/backend/replication/walreceiver.c, fix typo in the
header comment. Per request from Masao Fujii.

ITAGAKI Takahiro committed:

- In pgsql/contrib/dblink/dblink.c, fix connection leak in dblink when
dblink_connect() or dblink_connect_u() end with "duplicate
connection name" errors. Backported to release 7.4.

- In pgsql/contrib/dblink/dblink.c, avoid "identifier will be
truncated" warning in dblink when connection string is longer than
NAMEDATALEN. The previous fix for long connection name broke the
behavior.

- In pgsql/contrib/dblink/dblink.c, fix incorrect change in dblink
introduced by the previous commit "Fix connection leak in dblink".

- Rename restartpoint_command to archive_cleanup_command.

- In pgsql/src/backend/storage/ipc/standby.c, remove max_standby_delay
message from ps display of recovery process in waiting status. The
parameter is not so interesting in ps display because it is
referable in postgresql.conf.

Magnus Hagander committed:

- In pgsql/src/backend/access/transam/xlog.c, make the walwriter close
its handle to an old xlog segment if it's no longer the current one.
Not doing this would leave the walwriter with a handle to a deleted
file if there was nothing for it to do for a long period of time,
preventing the file from being completely removed. Reported by
Tollef Fog Heen, and thanks to Heikki for some hand-holding with the
patch.

Heikki Linnakangas committed:

- In standby mode, respect checkpoint_segments in addition to
checkpoint_timeout to trigger restartpoints. We used to
deliberately only do time-based restartpoints, because if
checkpoint_segments is small we would spend time doing restartpoints
more often than really necessary. But now that restartpoints are
done in bgwriter, they're not as disruptive as they used to be.
Secondly, because streaming replication stores the streamed WAL
files in pg_xlog, we want to clean it up more often to avoid running
out of disk space when checkpoint_timeout is large and
checkpoint_segments small. Patch by Fujii Masao, with some minor
changes by me.

- Return NULL instead of 0/0 in pg_last_xlog_receive_location() and
pg_last_xlog_replay_location(). Per Robert Haas's suggestion, after
Itagaki Takahiro pointed out an issue in the docs. Also, some
wording changes in the docs by me.

- Make TriggerFile variable static. It's not used outside xlog.c.
Fujii Masao.

Alvaro Herrera committed:

- In pgsql/doc/src/sgml/syntax.sgml, add index entry for ::, per
complaint from John Gage.

- In pgsql/doc/src/sgml/ref/alter_table.sgml, update ALTER TABLE docs
to account for exclusion and deferrable uniqueness constraints.
Dean Rasheed.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/release-9.0.sgml, update text of 9.0 release
notes. Josh Berkus.

- In pgsql/doc/src/sgml/Makefile, add space between after ">" in ">$@"
in SGML Makefile, for clarity.

- In pgsql/doc/src/sgml/Makefile, add SGML Makefile rule for
single-page text, postgres.txt.

- Have pg_upgrade create its output files in the current directory,
rather than in a subdirectory of the $HOME directory, or $TMP in
Windows.

- In pgsql/doc/src/sgml/Makefile, remove lynx -stdin flag for
postgres.text.

- In pgsql/src/test/regress/pg_regress.c, add missing --use-existing
--help mention from regression binary. Jan Urbanski

- In pgsql/contrib/pg_upgrade/pg_upgrade.h, update pg_upgrade C
comment about cwd.

Peter Eisentraut committed:

- Add a regression test case for bug #5497.

- In pgsql/src/pl/plpython/expected/README, update Python version
information.

- In pgsql/src/backend/access/transam/xlog.c, fix typo/bug, found by
Clang compiler.

- Add target to build HTML documentation as single page.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Fujii Masao sent in a patch per Andrew Dunstan to clarify that to use
a pgpass file to connect to Streaming Replica standbys, it is
necessary to use a * for the database field.

Peter Eisentraut sent in a WIP patch to allow GROUP BY to infer
functional dependencies and not require that the target list include
all non-aggregated columns when it finds them, per the SQL standard.

Alexander Korotkov sent in another revision of the patch to allow
multi-byte character sets in Levenshtein functions in the supplied
module for fuzzy string matching.

Joel Jacobson sent in another revision of the patch to add
a pg_stat_transaction system view.

Robert Haas sent in a patch to deprecate => and add ==> to the hstore
module, per discussion.