Nouvelles hebdomadaires de PostgreSQL - 13 juin 2010

PostgreSQL 9.0 beta 2 publiée. Testez ! http://www.postgresql.org/developer/beta

Nouveau sondage : laquelle des fonctionnalités de la 9.0 Beta (hors réplication) est votre préférée ? http://www.postgresql.org/community/

Les archives vidéo du rassemblement du SFPUG du 8 décembre 2009 : "Contraintes d'Exclusion via Opérateur", sont maintenant disponibles : http://thebuild.com/blog/2009/12/23/sfpug-operator-exclusion-constraints/

Les nouveautés des produits dérivés

• pgnotifyd v0.1, un gestionnaire de notification asynchrone pour PostgreSQL : http://www.pogo.org.uk/~mark/pgnotifyd/

Offres d'emplois autour de PostgreSQL en juin

• Internationales : http://archives.postgresql.org/pgsql-jobs/2010-06/threads.php;
• Francophones : http://forums.postgresql.fr/viewforum.php?id=4.

PostgreSQL Local

• Conférence de Michael Renner au Netways OSDC à Nuremberg (All.) les 23 & 24 juin 2010 : http://www.netways.de/osdc/y2010/programm/
• CHAR(10), la conférence PostgreSQL dédiée au clustering, à la haute-disponibilité et à la réplication vient d'ouvrir les inscriptions en ligne et les réservations. 2 & 3 juillet 2010, Oriel College, Université d'Oxford (Royaume-Uni) : http://www.char10.org/
• Le PDXPUG Day est programmé pour le 18 juillet 2010 à "l'Oregon Convention Center" à Portland. D'avantage d'informations : http://wiki.postgresql.org/wiki/PDXPUGDay2010
• L'OSCON aura lieu à Portland (Oregon) du 19 au 23 juillet 2010 : http://www.oscon.com/oscon2010

PostgreSQL dans les média

• Planet PostgreSQL : http://planet.postgresql.org/
• Planet PostgreSQLFr : http://planete.postgresql.fr/

PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter et Josh Berkus. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA.

Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais à david (a) fetter.org, en allemand à pwn (a) pgug.de, en italien à pwn (a) itpug.org et en espagnol à pwn (a) arpug.com.ar.

(lien vers l'article original)

Correctifs appliqués

Teodor Sigaev a commité :

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

Tom Lane a commité :

• 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 a commité :

• 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 a commité :

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

ITAGAKI Takahiro a commité :

• 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 a commité :

• 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 a commité :

• 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 a commité :

• 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 a commité :

• 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 a commité :

• 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.

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente

• 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.