Le Nordic PGDay 2014 aura lieu à Stockholm le 20 mars 2014 : http://www.nordicpgday.org/

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en décembre

PostgreSQL Local

  • FOSDEM PGDay, une conférence d'une journée, tenue avant le FOSDEM à Bruxelles, aura lieu le 31 janvier 2014. Détails : http://fosdem2014.pgconf.eu/ http://fosdem2014.pgconf.eu/registration/
  • La 7ème conférence annuelle "Prague PostgreSQL Developers Day" (P2D2), organisée par le CSPUG (PUG tchèque et slovaque), aura lieu le 6 février 2014 à la Faculté des Sciences Mathématiques & Physiques de l'Université Charles (Malostranske namesti 25, Prague). Infos en langue tchèque ci-après. L'appel à conférenciers court jusqu'au 3 janvier 2014 : http://www.p2d2.cz/
  • L'appel à conférenciers pour la PGConf NYC 2014 court jusqu'au 10 janvier 2014. Les notifications seront envoyées le 15 janvier : http://nyc.pgconf.us/2014/
  • L'appel à conférenciers pour le PGCon 2014 est lancé. Date limite : 19 janvier 2014 : http://www.pgcon.org/2014/

PostgreSQL dans les média

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é :

Robert Haas a poussé :

  • Revise documentation for new freezing method. Commit 37484ad2aacef5ec794f4dd3d5cf814475180a78 invalidated a good chunk of documentation, so patch it up to reflect the new state of play. Along the way, patch remaining documentation references to FrozenXID to say instead FrozenTransactionId, so that they match the way we actually spell it in the code. http://git.postgresql.org/pg/commitdiff/d43760b624b7cebc35e5f9c60d2e1439cbe9b220

Peter Eisentraut a poussé :

Andrew Dunstan a poussé :

  • Properly detect invalid JSON numbers when generating JSON. Instead of looking for characters that aren't valid in JSON numbers, we simply pass the output string through the JSON number parser, and if it fails the string is quoted. This means among other things that money and domains over money will be quoted correctly and generate valid JSON. Fixes bug #8676 reported by Anderson Cristian da Silva. Backpatched to 9.2 where JSON generation was introduced. http://git.postgresql.org/pg/commitdiff/29dcf7ded5ef8533376689a85c5b242fc7ace01d

Kevin Grittner a poussé :

  • Fix misplaced right paren bugs in pgstatfuncs.c. The bug would only show up if the C sockaddr structure contained zero in the first byte for a valid address; otherwise it would fail to fail, which is probably why it went unnoticed for so long. Patch submitted by Joel Jacobson after seeing an article by Andrey Karpov in which he reports finding this through static code analysis using PVS-Studio. While I was at it I moved a definition of a local variable referenced in the buggy code to a more local context. Backpatch to all supported branches. http://git.postgresql.org/pg/commitdiff/a133bf7031ad5b62281b21dbd6b2097d3d400f0d
  • Don't attempt to limit target database for pg_restore. There was an apparent attempt to limit the target database for pg_restore to version 7.1.0 or later. Due to a leading zero this was interpreted as an octal number, which allowed targets with version numbers down to 2.87.36. The lowest actual release above that was 6.0.0, so that was effectively the limit. Since the success of the restore attempt will depend primarily on on what statements were generated by the dump run, we don't want pg_restore trying to guess whether a given target should be allowed based on version number. Allow a connection to any version. Since it is very unlikely that anyone would be using a recent version of pg_restore to restore to a pre-6.0 database, this has little to no practical impact, but it makes the code less confusing to read. Issue reported and initial patch suggestion from Joel Jacobson based on an article by Andrey Karpov reporting on issues found by PVS-Studio static code analyzer. Final patch based on analysis by Tom Lane. Back-patch to all supported branches. http://git.postgresql.org/pg/commitdiff/47f50262e7ce5ba37940d8a94198b7a7f4892c0e

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Robert Haas sent in another revision of a patch to implement shared memory message queues.
  • Michael Paquier sent in a patch to align the internal name of wal_log_hints with its external name.
  • Andres Freund sent in a WIP patch to remove system columns from pg_attribute.
  • Robert Haas sent in a patch to implement a pg_tuple_header function.
  • Andreas Karlsson sent in two revisions of a patch to allow including planning time in EXPLAIN [ANALYZE].
  • Sergey Muraviov sent in another revision of a patch to improve how psql displays wide output.
  • Michael Paquier sent in a patch to add a pg_prewarm--unpackaged--1.0.sql to the new pg_prewarm contrib module.
  • Vik Fearing sent in a patch to implement CREATE TABLESPACE ... SET ...
  • MauMau sent in a patch to fix an issue where an ECPG application crashes due to SIGBUS on SPARC Solaris.
  • MauMau sent in a patch to fix an issue where "pg_ctl stop" times out when it should respond quickly.
  • Joel Jacobson sent in a patch to fix an issue where compare returned value by socket() against PGINVALID_SOCKET instead of < 0.
  • David Rowley sent in two more revisions of a patch to implement inverse transition functions for aggregates.
  • Marko Kreen sent in a patch to fix an issue where memset was being used in a dangerous way in pg_crypto. The patch replaces memset in places where it might be optimized away with px_memset.
  • Etsuro Fujita sent in another revision of a patch to show lossy heap block info in EXPLAIN ANALYZE for bitmap heap scan.
  • David Rowley sent in a patch to fix an issue where the diff options on Windows would wrongly hide whitespace changes deemed important.
  • David Rowley sent in a patch to prevent a possible overflow in work_mem calculations.
  • Tom Lane sent in a patch to generalize OR-clause extraction for foreign tables.
  • Alexander Korotkov sent in two more revisions of a patch to implement partial sorting.
  • Peter Geoghegan sent in another revision of a patch to implement INSERT...ON DUPLICATE KEY LOCK FOR UPDATE.