Le PGDay Italy aura lieu à Prato, Toscane, le 25 octobre 2013. Les informations complémentaires sont en chemin.

Les nouveautés des produits dérivés

• pgBadger 3.4, un analyseur de logs PostgreSQL écrit en Perl : https://sourceforge.net/projects/pgbadger/
• PG Commander, un client PostgreSQL pour OS X : http://eggerapps.at/pgcommander/
• PostGIS 2.1.0beta3, le système d'information géographique de référence : http://postgis.net/2013/06/22/postgis-2-1-0beta3
• psycopg2 2.5.1, un connecteur Python pour PostgreSQL : http://initd.org/psycopg/articles/2013/06/23/psycopg-251-released/

Offres d'emplois autour de PostgreSQL en juin

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

PostgreSQL Local

• Nous aurons un stand lors de l'OSCON cette année. N'hésitez pas à vous inscrire et y passer une heure ou deux : https://wiki.postgresql.org/wiki/Oscon_2013_signup
• Le PGDay UK 2013 aura lieu le 12 juillet 2013. Les inscriptions sont ouvertes : http://postgresqlusergroup.org.uk
• 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
• Postgres Open 2013 aura lieu à Chicago (Illinois, USA) du 16 au 18 septembre. Les inscriptions "lève-tôt" et l'appel à conférenciers se terminent le 30 juin : http://postgresopen.org/
• La PGConf.EU 2013 sera tenue du 29 octobre au 1^er novembre au Conrad Hotel dans le centre-ville de Dublin en Irlande. L'appel à conférenciers est lancé : http://2013.pgconf.eu/
• PGConf.DE 2013 aura lieu le 8 novembre 2013 au musée industriel de la Rhénanie à Oberhausen. L'appel à conférenciers porte jusqu'au 15 septembre : http://2013.pgconf.de/

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

Jeff Davis a poussé :

• Add buffer_std flag to MarkBufferDirtyHint(). MarkBufferDirtyHint() writes WAL, and should know if it's got a standard buffer or not. Currently, the only callers where buffer_std is false are related to the FSM. In passing, rename XLOG_HINT to XLOG_FPI, which is more descriptive. Back-patch to 9.3. http://git.postgresql.org/pg/commitdiff/b8fd1a09f382f04c41128fded4d56da2127ce92d

Peter Eisentraut a poussé :

• psql: Re-allow -1 together with -c or -l http://git.postgresql.org/pg/commitdiff/c3c86ae2aff67676a49ec84240f1d6a482f359cb
• initdb: Add blank line before output about checksums. This maintains the logical grouping of the output better. http://git.postgresql.org/pg/commitdiff/8df54b9fad9b7954b71c63b86a6c587fc6748099
• Further update CREATE FUNCTION documentation about argument names. More languages than SQL and PL/pgSQL actually support parameter names. http://git.postgresql.org/pg/commitdiff/4c54e87a86d6e73aa3a3b7710fa3db33297792d4
• Clarify terminology standalone backend vs. single-user mode. Most of the documentation uses "single-user mode", so use that in the code as well. Adjust the documentation to match the new error message wording. Also add a documentation index entry for "single-user mode". Based-on-patch-by: Jeff Janes. http://git.postgresql.org/pg/commitdiff/7dfd5cd21c0091e467b16b31a10e20bbedd0a836
• doc: Fix date in EPUB manifest. If there is no <date> element, the publication date for the EPUB manifest is taken from the copyright year. But something like "1996-2013" is not a legal date specification. So the EPUB output currently fails epubcheck. Put in a separate <date> element with the current year. Put it in legal.sgml, because copyright.pl already instructs to update that manually, so it hopefully won't be missed. http://git.postgresql.org/pg/commitdiff/dab1603e5238d3abce9f7a3a7b9450888cc07c70

Simon Riggs a poussé :

• Fix docs on lock level for ALTER TABLE VALIDATE. ALTER TABLE .. VALIDATE CONSTRAINT previously gave incorrect details about lock levels and therefore incomplete reasons to use the option. Initial bug report and fix from Marko Tiikkaja Reworded by me to include comments by Kevin Grittner http://git.postgresql.org/pg/commitdiff/073d7cb513f5de44530f4bdbaaa4b5d4cce5f984
• Ensure no xid gaps during Hot Standby startup. In some cases with higher numbers of subtransactions it was possible for us to incorrectly initialize subtrans leading to complaints of missing pages. Bug report by Sergey Konoplev. Analysis and fix by Andres Freund. http://git.postgresql.org/pg/commitdiff/1f09121b4edee8b4d4cdd4ee0a8cffacee7b85f7

Kevin Grittner a poussé :

• Fix the create_index regression test for Danish collation. In Danish collations, there are letter combinations which sort higher than 'Z'. A test for values > 'WA' was picking up rows where the value started with 'Ants Aasma', causing the test to fail. Backpatch to 9.2, where the failing test was added. Per report from Svenne Krap and analysis by Jeff Janes http://git.postgresql.org/pg/commitdiff/8791627b8f9a9ce44603beec447bc6f18bfd9a36

Bruce Momjian a poussé :

• Modernize entab source code. Remove halt.c, improve comments, rename manual page file. http://git.postgresql.org/pg/commitdiff/f979599b2068f036405f1b51a9c4260619b06941

Fujii Masao a poussé :

• Support TB (terabyte) memory unit in GUC variables. Patch by Simon Riggs, reviewed by Jeff Janes and me. http://git.postgresql.org/pg/commitdiff/bab54e383dd102001753366d3c124f706c7967dd

Tom Lane a poussé :

• Add a comment warning against use of pg_usleep() for long sleeps. Follow-up to commit 873ab97219caabeb2f7b390268a4fe01e2b7518c, in which I noted that WaitLatch was a better solution in the commit log message, but neglected to add any documentation in the code. http://git.postgresql.org/pg/commitdiff/8c1a71d36f5d667f3c2236e0e015a48f809ca240

Correctifs rejetés (à ce jour)

• No one was disappointed this week

Correctifs en attente

• David Fetter sent in another revision of a patch to implement makeFuncArgs.
• Andres Freund sent in a patch to clarify an error message on Linux.
• Robins Tharakan sent in another revision of a patch to add regression tests for SET xxx.
• Alexander Korotkov sent in two more revisions of a patch to add more information to GIN indexes.
• Alexander Korotkov sent in two more revisions of a patch to add ordering in GIN indexes.
• Alexander Korotkov sent in two more revisions of a patch to add fast scan to GIN indexes.
• Ian Link sent in a patch to improve the fast GIN cache.
• Michael Paquier sent in five more revisions of a patch to implement REINDEX CONCURRENTLY.
• Jeff Davis sent in another revision of a patch to have pg_filedump take checksums, among other things, into account.
• Amit Langote sent in a patch to correct a comment in heaptuple.c.
• Cedric Villemain sent in a patch to fix a bug and add new features to pgxs.
• Etsuro Fujita sent in four more revisions of a patch to remove unused targets.
• Nicholas White and Troels Nielsen traded patches to allow the SQL standard IGNORE/RESPECT NULLS in lead and lag window functions.
• Heikki Linnakangas sent in two more revisions of a patch to scale XLogInserts.
• Amit Kapila sent in another revision of a patch to allow changing GUCs persistently from SQL.
• Fabien COELHO sent in another revision of a patch to add long options to pgbench.
• Andres Freund sent in a patch to create a new contrib module: xidfuncs.
• Jeff Janes sent in another revision of a patch to add a startup option to pgbench.
• Josh Kupershmidt sent in a patch to rename the specs directory to something that won't interfer with certain OSs.
• Andres Freund sent in another revision of a patch to create infrastructure for and implement examples of pluggable compressors.
• Gurjeet Singh sent in a patch to implement a function pg_test_reload_conf() which allows you to know whether the changes you've made to configuration parameters have actually taken effect after a SIGHUP.
• KONDO Mitsumasa sent in another revision of a patch to add --progress to pgbench.
• Andres Freund sent in two more revisions of the set of patches to implement WAL decoding.
• David Fetter sent in another revision of a patch to implement FILTER, this time without the restriction that certain types of subqueries couldn't be in the FILTER clause. Dean Rasheed sent in a patch on top of same to make FILTER an unreserved word.
• Alexander Korotkov sent in a patch to fix an irregularity in trigram indexes.
• Andres Freund sent in a WIP patch to fix a corner case in CASE.
• Andrew Dunstan sent in a patch to fix pg_dump for foreign tables in the pg_upgrade scenario.
• Fabien COELHO sent in another revision of a patch to implement CREATE CAST...AS EXPLICIT.
• Simon Riggs and Heikki Linnakangas traded patches to fix how hashes work in some edge cases.
• Fabien COELHO sent in another revision of a patch to implement pgbench --throttle.
• Noah Misch sent in another revision of a patch to make Windows behave better with different encodings.