PGConf.DE 2013 est la suite de la très réussie PostgreSQL Conference 2011 germanophone. Nous gardons le concept : 8 novembre 2013 au musée industriel de la Rhénanie à Oberhausen : http://2013.pgconf.de/

Le programme du PG Day France 2013 est disponible, et les inscriptions sont ouvertes. Cet événement aura lieu à Nantes le 13 juin 2013. Programme : http://pgday.fr/programme Inscriptions : http://www.pgday.fr/inscriptions

Les nouveautés des produits dérivés

• phpPgAdmin 5.1, un outil web pour l'administration de PostgreSQL : http://phppgadmin.sourceforge.net/doku.php?id=download

Offres d'emplois autour de PostgreSQL en avril

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

PostgreSQL Local

• PGCon 2013 aura lieu les 23 & 24 mai 2013 à l'Université d'Ottawa : http://www.pgcon.org/2013/
• Premier rassemblement utilisateurs/développeurs Postgres-XC après le Cluster Summit : https://wiki.postgresql.org/wiki/PgCon2013CanadaClusterSummit#PostgresXC_Summit
• La 6ème conférence annuelle "Prague PostgreSQL Developers Day", organisée par le CSPUG (Groupe des utilisateurs tchèques et slovaques de PostgreSQL), aura lieu le 30 mai 2013 à la Faculté des Sciences Mathématiques & Physiques de l'Université Charles (Malostranske namesti 25, Prague). Les candidatures des conférenciers sont attendues jusqu'au 14 avril à l'adresse <info AT p2d2 POINT cz>. D'avantage d'informations sur le site : http://www.p2d2.cz/
• Le PgDay Fr est l'événement majeur de la communauté francophone. Il aura lieu le 13 juin 2013 à Nantes (France) : http://pgday.fr/
• PostgreSQL Brazil aura lieu du 15 au 17 août 2013 à Porto Velho, État du Rondônia au Brésil : http://pgbr.postgresql.org.br/2013/chamada.en.php
• Notez la date ! Postgres Open 2013 aura lieu à Chicago (Illinois, USA) du 16 au 18 septembre. Hotel Sax : https://reservations.ihotelier.com/crs/g_reservation.cfm?groupID=888761&hotelID=6865 Inscriptions pour les lèves-tôts : http://postgresopen-eac2.eventbrite.com/
• La PGConf.EU 2013 sera tenue du 29 octobre au 1^er novembre au Conrad Hotel dans le centre-ville de Dublin en Irlande : http://2013.pgconf.eu/

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

Tom Lane a poussé :

• Improve GiST index search performance for trigram regex queries. The initial coding just descended the index if any of the target trigrams were possibly present at the next level down. But actually we can apply trigramsMatchGraph() so as to take advantage of AND requirements when there are some. The input data might contain false positive matches, but that can only result in a false positive result, not false negative, so it's safe to do it this way. Alexander Korotkov http://git.postgresql.org/pg/commitdiff/410bed2ab8c3864d7f34f9694d080adcaf446352
• Don't try to pass -I switch to postmaster in contrib/start-scripts/linux. Undo thinko in commit 87306184580c9c49717b00d48a2f9e717f21e0a8. Per bug #8098 from Catherine Devlin. http://git.postgresql.org/pg/commitdiff/3353583d7ecf7c9f8bc5966ed0a2537dec71ffdc
• Improve error message when an FDW doesn't support WHERE CURRENT OF. If an FDW fails to take special measures with a CurrentOfExpr, we will end up trying to execute it as an ordinary qual, which was being treated as a purely internal failure condition. Provide a more user-oriented error message for such cases. http://git.postgresql.org/pg/commitdiff/6e481ebff6368cb0ab5351a5ef3463747c35af22
• Fix longstanding race condition in plancache.c. When creating or manipulating a cached plan for a transaction control command (particularly ROLLBACK), we must not perform any catalog accesses, since we might be in an aborted transaction. However, plancache.c busily saved or examined the search_path for every cached plan. If we were unlucky enough to do this at a moment where the path's expansion into schema OIDs wasn't already cached, we'd do some catalog accesses; and with some more bad luck such as an ill-timed signal arrival, that could lead to crashes or Assert failures, as exhibited in bug #8095 from Nachiket Vaidya. Fortunately, there's no real need to consider the search path for such commands, so we can just skip the relevant steps when the subject statement is a TransactionStmt. This is somewhat related to bug #5269, though the failure happens during initial cached-plan creation rather than revalidation. This bug has been there since the plan cache was invented, so back-patch to all supported branches. http://git.postgresql.org/pg/commitdiff/ac63dca607e8e22247defbc8fe03b6baa3628c42

Andrew Dunstan a poussé :

• Correct handling of NULL arguments in json funcs. Per gripe from Tom Lane. http://git.postgresql.org/pg/commitdiff/728ec9731fb0b3f2de8ce66a394b71c64930f445
• Mark json IO and extraction functions immutable. Per complaint from Hubert Depesz Lubaczewski. Catalog version bumped. http://git.postgresql.org/pg/commitdiff/d788121aba3425b5d52fe20cc9facb6aca1294ce

Peter Eisentraut a poussé :

• Fix function return type confusion When parse_hba_line's return type was changed from bool to a pointer, the MANDATORY_AUTH_ARG macro wasn't adjusted. http://git.postgresql.org/pg/commitdiff/c74d586d2fc8aeaa303d8c60a8a9d959fdc5e791
• doc: Update PQgetssl() documentation. The return type of PQgetssl() was changed from SSL* to void* a long time ago, but the documentation was not updated. http://git.postgresql.org/pg/commitdiff/b9bdaf3964a1fbd32e6140eb180dfa82ff1d8f23
• Standardize spelling of "nonblocking". Only adjusted the user-exposed messages and documentation, not all source code comments. http://git.postgresql.org/pg/commitdiff/acd5803053eb5ff6ad055ac1f7670625f1d111e0
• Clean up references to SQL92. In most cases, these were just references to the SQL standard in general. In a few cases, a contrast was made between SQL92 and later standards -- those have been kept unchanged. http://git.postgresql.org/pg/commitdiff/cc26ea9fe2e41e73c955ea75bea7a77fbd062d64
• doc: Mention SATA alongside IDE for Linux. suggested by Jov http://git.postgresql.org/pg/commitdiff/540ec93e33c4eea7da502e8a4e76e5de4b994ac1
• doc: Fix syntax in example. LANGUAGE 'plpgsql' no longer works. The single quotes need to be removed. Erwin Brandstetter http://git.postgresql.org/pg/commitdiff/53ecfddcebbf607badc678e294bf977334b79327
• doc: Improve example formatting. Erwin Brandstetter http://git.postgresql.org/pg/commitdiff/e7d5ffe8ea9883f1b472036dfc098d555f5cd3ea

Heikki Linnakangas a poussé :

• Remove some unused and seldom used fields from RelationAmInfo. This saves some memory from each index relcache entry. At least on a 64-bit machine, it saves just enough to shrink a typical relcache entry's memory usage from 2k to 1k. That's nice if you have a lot of backends and a lot of indexes. http://git.postgresql.org/pg/commitdiff/87ae9e72654ddddf25433b8a178e9268cf03f5b5

Bruce Momjian a poussé :

• pgindent: add newline to die() so script line number is not reported on failure. http://git.postgresql.org/pg/commitdiff/d61dddba37c27b1b5157b493bd04913c23ade7c2
• pg_upgrade: Add checksum C comment. We might eventually allow checksum to no-checksum upgrades. http://git.postgresql.org/pg/commitdiff/5286963066ce7420d80882528b5f07c28f39eacf
• Publish draft 9.3 release notes. No links added yet. http://git.postgresql.org/pg/commitdiff/e9a35c2082e638c34567db1b5738f355475811d6
• Reorder some 9.3 release item entries. More to go. http://git.postgresql.org/pg/commitdiff/61b962345dd87276452922a5dbc21836266b43e0
• Fix Gilles Darold's name in 9.3 release notes. http://git.postgresql.org/pg/commitdiff/488eb9055d3135268fdb401953f395885829d2f4
• Push 9.3 release SGML file. Forgotten in previous commit. http://git.postgresql.org/pg/commitdiff/22f956f50cac33287daf76d79890057ba2fb3789
• More 9.3 release note reorderings http://git.postgresql.org/pg/commitdiff/f0922cbdcc54a11ea7eef955763aab4d540bf22f
• Adjust 9.3 release notes per request from Simon Riggs. http://git.postgresql.org/pg/commitdiff/864ec2f0cd5dd2ba5a7b40cc150cecb3010f739c
• 9.3 release note fixes. Move commit_delay, fix Zoltan's name, and adjust range type histogram text. http://git.postgresql.org/pg/commitdiff/ac96e6a8c2c5477344e78840e689e39e7b7b3cf1
• Remove 9.3 item about fixing DROP INDEX CONCURRENTLY. Already fixed in back branch. http://git.postgresql.org/pg/commitdiff/1f2236edd1876a8718453f7d4e8e7fdef378c91e
• 9.3 release note adjustments per request from Andres Freund http://git.postgresql.org/pg/commitdiff/4be535e2e44025975814937818c899fed7aafca3
• Reorder 9.3 release note items. Typo fix from David Fetter. http://git.postgresql.org/pg/commitdiff/ef3defcf0d507abb75d9e9696f11b44f4fc09291
• In 9.3 release notes, split up items. Split log shipping speed improvement and fail-over speed improvement items. Per request from Simon Riggs http://git.postgresql.org/pg/commitdiff/c3ab4ea27d5e2cd341fc189eb413909f177d835e

Robert Haas a poussé :

• sepgsql: One more getObjectIdentity in lieu of getObjectDescription. KaiGai Kohei, based on a suggestion from Álvaro Herrera http://git.postgresql.org/pg/commitdiff/0bf5c548d64b66b92197c6d8490b9b131ba02269
• sepgsql: Minor improvement to test script, doc fix. KaiGai Kohei http://git.postgresql.org/pg/commitdiff/f050457978f4f8deb1ac850439bf7c46c818f4ae
• Fix typo in comment. Fabrízio de Royes Mello http://git.postgresql.org/pg/commitdiff/4580a4bd2c858acf85c578609b8373d730a04534

Correctifs rejetés (à ce jour)

• Colin 't Hart's patch to add \ns as a short cut for SET search_path in psql.

Correctifs en attente

• Simon Riggs sent in three revisions of a patch to optimize COPY for some kinds of volatile expressions.
• Bruce Momjian sent in a patch to reformat pg_test_fsync's output in a more compact way.
• Robert Haas sent in a patch to prevent pg_restore from restoring into the pg_catalog schema by accident.
• Ants Aasma sent in two more revisions of a patch to implement page checksums, including variously optimizable algorithms for same.
• Fabrízio de Royes Mello sent in two revisions of a patch to include currval() for discarding in DISCARD ALL.