Les nouveautés des produits dérivés

• Version 2.19.0 de check_postgres, un outil de surveillance de PostgreSQL : http://bucardo.org/wiki/check_postgres
• PostgreSQL XC 0.97, une solution de cluster multi-maître synchrone, souple sur les performances en écriture, basée sur PostgreSQL 9.1 : http://sourceforge.net/projects/postgres-xc/

Offres d'emplois autour de PostgreSQL en janvier

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

PostgreSQL Local

• La cinquième conférence annuelle "Prague PostgreSQL Developers Day", organisée pas le CSPUG (PUG Tchèque & Slovaque), aura lieu le 9 février 2012 à Prague.
• La PGCon 2012 sera tenue à l'Université d'Ottawa, les 17 et 18 mai 2012. Elle sera précédée par deux jours de tutoriels les 15 & 16 mai 2012 : http://www.pgcon.org/2012/

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

Robert Haas a poussé :

• Prevent adding relations to a concurrently dropped schema. In the previous coding, it was possible for a relation to be created via CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE FOREIGN TABLE, etc. in a schema while that schema was meanwhile being concurrently dropped. This led to a pg_class entry with an invalid relnamespace value. The same problem could occur if a relation was moved using ALTER .. SET SCHEMA while the target schema was being concurrently dropped. This patch prevents both of those scenarios by locking the schema to which the relation is being added using AccessShareLock, which conflicts with the AccessExclusiveLock taken by DROP. As a desirable side effect, this also prevents the use of CREATE OR REPLACE VIEW to queue for an AccessExclusiveLock on a relation on which you have no rights: that will now fail immediately with a permissions error, before trying to obtain a lock. We need similar protection for all other object types, but as everything other than relations uses a slightly different set of code paths, I'm leaving that for a separate commit. Original complaint (as far as I could find) about CREATE by Nikhil Sontakke; risk for ALTER .. SET SCHEMA pointed out by Tom Lane; further details by Dan Farina; patch by me; review by Hitoshi Harada. http://git.postgresql.org/pg/commitdiff/1575fbcb795fc331f46588b4520c4bca7e854d5c
• fastgetattr is in access/htup.h, not access/heapam.h. Noted by Peter Geoghegan http://git.postgresql.org/pg/commitdiff/754b8140a1a5ceb12343fd89423da5cc86ce5328
• Catch fatal flex errors in the GUC file lexer. This prevents the postmaster from unexpectedly croaking if postgresql.conf contains something like: include 'invalid_directory_name' Noah Misch. Reviewed by Tom Lane and myself. http://git.postgresql.org/pg/commitdiff/4b496a3583ecb3f70bb4d13f8275dbb7e5b26100
• Regression tests for security_barrier views. KaiGai Kohei http://git.postgresql.org/pg/commitdiff/504f0c5d5d2955c05458e1a8d5f4fbba4cac07cd
• Add bitwise AND, OR, and NOT operators for macaddr data type. Brendan Jurd, reviewed by Fujii Masao. http://git.postgresql.org/pg/commitdiff/cc53a1e7ccfa762bda70e1b6a15bfd929bf1b4e3
• Clarify that bgwriter no longer handles checkpoints. Text by Peter Geoghegan. http://git.postgresql.org/pg/commitdiff/c8397bd6d909620457b532e252ce2e437c787d4f
• Triggered change notifications. Kevin Grittner, reviewed (in earlier versions) by Álvaro Herrera http://git.postgresql.org/pg/commitdiff/6e3323d41dc45e93700a3420fd27ca05db6a64a7

Peter Eisentraut a poussé :

• psql: Fix memory leak. The command \password username leaked memory. http://git.postgresql.org/pg/commitdiff/1b9f774090d58a950ef0535b51bc377ab62b795c
• PL/Python: Update example. Change the usesavedplan() example to use a more modern Python style using the .setdefault() function. http://git.postgresql.org/pg/commitdiff/6f6b46c9c0ca3d96acbebc5499c32ee6369e1eec
• psql: Add support for tab completion of GRANT/REVOKE role. Previously, only GRANT/REVOKE privilege was supported. reviewed by Pavel Stehule http://git.postgresql.org/pg/commitdiff/95c63b5e3209cfc8d91d7956407032fc6fe89640

Alvaro Herrera a poussé :

• Disallow merging ONLY constraints in children tables. When creating a child table, or when attaching an existing table as child of another, we must not allow inheritable constraints to be merged with non-inheritable ones, because then grandchildren would not properly get the constraint. This would violate the grandparent's expectations. Bugs noted by Robert Haas. Author: Nikhil Sontakke http://git.postgresql.org/pg/commitdiff/3b11247aadf857bbcbfc765191273973d9ca9dd7

Magnus Hagander a poussé :

• Fix warning about unused variable http://git.postgresql.org/pg/commitdiff/ae137bcaab7dd0b1ee58020d93ce8f07e36d4d49
• Show psql timing output for failed queries as well as successful ones. This is useful for example when a long-runing statement such as CREATE INDEX fails after a long time. http://git.postgresql.org/pg/commitdiff/2106c55ac8dacc52bf6483925529fd3ab99b94c4
• Separate state from query string in pg_stat_activity. This separates the state (running/idle/idleintransaction etc) into it's own field ("state"), and leaves the query field containing just query text. The query text will now mean "current query" when a query is running and "last query" in other states. Accordingly,the field has been renamed from current_query to query. Since backwards compatibility was broken anyway to make that, the procpid field has also been renamed to pid - along with the same field in pg_stat_replication for consistency. Scott Mead and Magnus Hagander, review work from Greg Smith http://git.postgresql.org/pg/commitdiff/4f42b546fd87a80be30c53a0f2c897acb826ad52
• Further doc cleanups from the pg_stat_activity changes. Fujii Masao http://git.postgresql.org/pg/commitdiff/a65023e7decf5f5ba9b17bd86db8fe1ea4b6c331
• Get rid of itemizedlist inside table. This renders badly on the website, and in this particular case also doesn't actually add anything to the readability... http://git.postgresql.org/pg/commitdiff/356fddfa0ff612a40cc85f8374f9cd058585687f
• Check number of fields in IDENTIFY_SYSTEM response. Jaime Casanova http://git.postgresql.org/pg/commitdiff/c14534957bb93df76bc66516aa03476de0069213
• Typo fix. Guillaume Lelarge http://git.postgresql.org/pg/commitdiff/4993a49b7cf1d23dfe1f9e1a85d9411b8ff57454

Heikki Linnakangas a poussé :

• Fix corner case in cleanup of transactions using SSI. When the only remaining active transactions are READ ONLY, we do a "partial cleanup" of committed transactions because certain types of conflicts aren't possible anymore. For committed r/w transactions, we release the SIREAD locks but keep the SERIALIZABLEXACT. However, for committed r/o transactions, we can go further and release the SERIALIZABLEXACT too. The problem was with the latter case: we were returning the SERIALIZABLEXACT to the free list without removing it from the finished list. The only real change in the patch is the SHMQueueDelete line, but I also reworked some of the surrounding code to make it obvious that r/o and r/w transactions are handled differently -- the existing code felt a bit too clever. Dan Ports http://git.postgresql.org/pg/commitdiff/326b922e8b2d65257a635b5f80e5de0f15dffd3a
• Make pg_relation_size() and friends return NULL if the object doesn't exist. That avoids errors when the functions are used in queries like "SELECT pg_relation_size(oid) FROM pg_class", and a table is dropped concurrently. Phil Sorber http://git.postgresql.org/pg/commitdiff/fa352d662e57fa150158b9cb0a8f127250f8c97f

Bruce Momjian a poussé :

• Add pg_upgrade C comment about why we check all relkinds for regtypes. http://git.postgresql.org/pg/commitdiff/ecf7a2ea387a409f6152c05f60e5765c7436b8df

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente

• Peter Geoghegan and Heikki Linnakangas traded new revisions of the GROUP COMMIT patch.
• Greg Smith sent in a patch to publish checkpoint timing and sync files summary data to pg_stat_bgwriter.
• Greg Smith sent in a patch to implement an unconditional checkpoint sync pause.
• Andrew Dunstan sent in another revision of the patch to make pretty-printing view definitions actually print them prettily.
• Fujii Masao sent in another revision of the patch to add a "write" replication mode.
• Magnus Hagander sent in a patch to patch add a counter for the number of deadlocks in a database to pg_stat_database.
• Tom Lane sent in a WIP patch for parameterized inner paths.
• Fujii Masao sent in another revision of the patch to allow taking a base backup from a hot standby. Steve Singer reviewed same.
• Alexander Korotkov sent in two more revisions of the patch to collect frequency statistics for arrays, the second per review by Noah Misch.
• Kyotaro HORIGUCHI sent in another revision of the patch to speed dblink using a new libpq tuple storage system. Marko Kreen and Marc Mamin reviewed.
• Greg Smith sent in a patch to add a pg_test_timing.
• Tomas Vondra sent in another revision of the patch to track temp files in pg_stat_database. Magnus Hagander reviewed same.
• Heikki Linnakangas sent in another revision of the bgwriter latch patch intended to save energy.
• Daniel Farina sent in two revisions of a patch to factor out the various CRC32 implementations in the PostgreSQL source code, per reviews by Tom Lane and Robert Haas.
• Martin Pihlak sent in two more revisions of the patch to add logging hooks.
• Martin Pihlak sent in another revision of the patch to generate call graphs in real time, per review by Joel Jacobson.
• KaiGai Kohei sent in two more revisions of the patch to implement sepgsql's DROP permissions.
• Peter Geoghegan sent in another revision of the fast path sorting patch.
• Simon Riggs sent in another revision of the patch to implement DROP INDEX CONCURRENTLY, reviewed by Robert Haas.
• Peter Eisentraut sent in another revision of the collation for expression patch.
• Simon Riggs sent in two more revisions of the walrestore patch, per reviews by Fujii Masao.
• Heikki Linnakangas sent in another revision of the patch to move work out of WALInsertLock(), per review by Robert Haas.
• Dimitri Fontaine sent in another revision of the inline EXTENSION patch per review by Robert Haas.
• Euler Taveira de Oliveira sent in two more patches to implement xlog arithmetic.
• Noah Misch sent in another revision of the patch to avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE.
• Noah Misch sent in a patch to fix a defective test case.
• Simon Riggs sent in another revision of a patch to fix certain kinds of CLOG contention.
• KaiGai Kohei sent in two more revisions of the patch to add a LEAKPROOOF attribute to functions per review by Robert Haas.
• Peter Eisentraut sent in another revision of the patch to remove unused-variable warnings in assert-free builds.
• KaiGai Kohei sent in a patch to fix some infelicities in the changes that plug certain kinds of information leakage in views.
• Julien Tachoires sent in another revision of the patch to allow toast tables to be moved to a different tablespace.
• Mikko Tiihonen sent in another revision of the patch to create a new, more space-efficient serialization for arrays with fix-length elements.
• Tom Lane sent in a patch to fix bug 6123.