L'appel à conférenciers pour le Postgres Open a été lancé. Les candidatures sont attendues jusqu'au 1^er juillet 2013 : http://postgresopen.org/2013/speaker

PostgreSQL Local

• Le PgDay Fr est l'événement majeur de la communauté francophone. Il aura lieu le 13 juin 2013 à Nantes (France) : http://pgday.fr/
• 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
• 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ève-tôt : 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. 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

Stephen Frost a poussé :

• Documentation fix for ALTER TYPE .. RENAME. The documentation for ALTER TYPE .. RENAME claimed to support a RESTRICT/CASCADE option at the 'type' level, which wasn't implemented and doesn't make a whole lot of sense to begin with. What is supported, and previously undocumented, is ALTER TYPE .. RENAME ATTRIBUTE .. RESTRICT/CASCADE. I've updated the documentation and back-patched this to 9.1 where it was first introduced. http://git.postgresql.org/pg/commitdiff/05624220c413eba1d7da38586dfb9aa6a8e9623d
• Post-pgindent cleanup. Make slightly better decisions about indentation than what pgindent is capable of. Mostly breaking out long function calls into one line per argument, with a few other minor adjustments. No functional changes- all whitespace. pgindent ran cleanly (didn't change anything) after. Passes all regressions. http://git.postgresql.org/pg/commitdiff/551938ae2284975b53d665fa8a82a7e1f3514dda
• Minor spelling fixes. Fix a few spelling mistakes. Per bug report #8193 from Lajos Veres. http://git.postgresql.org/pg/commitdiff/c9fc28a7f12e27d530e2657c9dc6080fbfbe8a14

Bruce Momjian a poussé :

• pg_upgrade docs: mention need to set parameters for vacuumdb. http://git.postgresql.org/pg/commitdiff/f80e55054bb40421ee414558818cf944a6b48b7e
• pgindent run for release 9.3. This is the first run of the Perl-based pgindent script. Also update pgindent instructions. http://git.postgresql.org/pg/commitdiff/9af4159fce6654aa0e081b00d02bca40b978745c

Robert Haas a poussé :

• Document auto_explain.log_timing. Tomas Vondra http://git.postgresql.org/pg/commitdiff/07ab261ef3a9575a4a2bd3045b222d7b3dee2c46

Peter Eisentraut a poussé :

• postgresql.conf.sample: Improve whitespace http://git.postgresql.org/pg/commitdiff/97a11fd0e3055ab82d562930b38027b054e6c8e0
• doc: Fix claim that query is passed as ASCII text. Ian Lawrence Barwick http://git.postgresql.org/pg/commitdiff/eff8055afb7c89c2d2629d35b074ca617a3c2310
• Remove whitespace from end of lines http://git.postgresql.org/pg/commitdiff/8b5a3998a104ef5918b50e207be0aa86e085d49d
• Minor spell checking http://git.postgresql.org/pg/commitdiff/d7eb6f46de900f6664918cda3b5e6f922a0a2356
• Add new source files to nls.mk http://git.postgresql.org/pg/commitdiff/01497e738e58b0a5d87706353f28eccc5bea9591
• doc: Remove paragraph about typesetting conventions. They no longer match reality with the web site style sheets, and it is difficult to keep the up to date in a CSS world. http://git.postgresql.org/pg/commitdiff/dedf7e9919a2dc42370c0b218728e1556985de6a
• Fix whitespace issues in the man pages. See 00b0c73f1f2b98a7d09de63aaa14d6498ac521ae for an explanation. http://git.postgresql.org/pg/commitdiff/93874ce064836e45220978e2656cbf62eba766ed
• Another man page whitespace fix http://git.postgresql.org/pg/commitdiff/22b36412c73fdae960cc6bef58eb16a26d14b700

Tom Lane a poussé :

• Fix unportable usage of isspace(). Must cast char argument to unsigned to avoid doing the wrong thing with high-bit-set characters. Oversight in commit 30b5ede7157e34e77c7914b8ecfd55aa8da6edc3. http://git.postgresql.org/pg/commitdiff/a149d8bd56edc2f06643118ed8aac8bce6ebad6d
• Allow type_func_name_keywords in some places where they weren't before. This change makes type_func_name_keywords less reserved than they were before, by allowing them for role names, language names, EXPLAIN and COPY options, and SET values for GUCs; which are all places where few if any actual keywords could appear instead, so no new ambiguities are introduced. The main driver for this change is to allow "COPY ... (FORMAT BINARY)" to work without quoting the word "binary". That is an inconsistency that has been complained of repeatedly over the years (at least by Pavel Golub, Kurt Lidl, and Simon Riggs); but we hadn't thought of any non-ugly solution until now. Back-patch to 9.0 where the COPY (FORMAT BINARY) syntax was introduced. http://git.postgresql.org/pg/commitdiff/2c92edad48796119c83d7dbe6c33425d1924626d

Correctifs rejetés (à ce jour)

• No one was disappointed this week

Correctifs en attente

• Thom Brown sent in a patch to correct a flock of typos.
• Amit Kapila sent in another revision of a patch to allow postgresql.conf values to be changed via SQL.
• Szymon Guz sent in a patch to fix conversion for Decimal arguments in plpython functions.
• Robert Haas sent in a patch to preserve forensic information when we freeze.
• Bruce Momjian sent in a patch to change the -u parameter for username to the more customary (and consistent with other utilities) -U.
• Cedric Villemain sent in a flock of patches intended to un-break "make install" of certain extensions.
• Joe Conway sent in three more revisions of a patch to fix cases where dumping extensions fails.
• Heikki Linnakangas sent in another revision of a patch to scale xlog inserts.
• Andres Freund sent in a patch to ensure that all_visible WAL records operate on an intialized page.
• Jeff Davis sent in another revision of a patch to eliminate PD_ALL_VISIBLE.
• Andres Freund sent in a WIP patch to add support for multiple kinds of external toast datums.
• Dean Rasheed sent in a patch to make array_remove() do the right thing with a 0-D array.
• Fabien COELHO sent in another revision of a patch to add a --progress option to pgbench.
• Fabien COELHO sent in another revision of a patch to add a --throttle option to pgbench.
• Fujii Masao sent in another revision of a patch to add pg_isready.