Le PGDay Campinas 2014 aura lieu à Campinas (Brésil) le 10 septembre. Inscriptions ouvertes et candidatures de conférences-éclair attendues : http://pgdaycampinas.com.br/

Offres d'emplois autour de PostgreSQL en août

PostgreSQL Local

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

Heikki Linnakangas a poussé :

Bruce Momjian a poussé :

Robert Haas a poussé :

Kevin Grittner a poussé :

Fujii Masao a poussé :

  • Change ParseConfigFp() so that it doesn't process unused entry of each parameter. When more than one setting entries of same parameter exist in the configuration file, PostgreSQL uses only entry appearing last in configuration file scan. Since the other entries are not used, ParseConfigFp() doesn't need to process them, but previously it did that. This problematic behavior caused the configuration file scan to detect invalid settings of unused entries (e.g., existence of multiple entries of PGC_POSTMASTER parameter) and log the messages complaining about them. This commit changes the configuration file scan so that it processes only last entry of each parameter. Note that when multiple entries of same parameter exist both in postgresql.conf and postgresql.auto.conf, unused entries in postgresql.conf are still processed only at postmaster startup. The problem has existed since old version, but a user is more likely to encounter it since 9.4 where ALTER SYSTEM command was introduced. So back-patch to 9.4. Amit Kapila, slightly modified by me. Per report from Christoph Berg. http://git.postgresql.org/pg/commitdiff/e3da0d4d1a47e2049ae16aa30bb7bf3105dc8c45
  • Refactor pg_receivexlog main loop code, for readability, take 2. Previously the source codes for processing the received data and handling the end of stream were included in pg_receivexlog main loop. This commit splits out them as separate functions. This is useful for improving the readability of main loop code and making the future pg_receivexlog-related patch simpler. http://git.postgresql.org/pg/commitdiff/6805e02c66eac3857ef1a3d6cfd1ffeea64d9447
  • Add -F option to pg_receivexlog, for specifying fsync interval. This allows us to specify the maximum time to issue fsync to ensure the received WAL file is safely flushed to disk. Without this, pg_receivexlog always flushes WAL file only when it's closed and which can cause WAL data to be lost at the event of a crash. Furuya Osamu, heavily modified by me. http://git.postgresql.org/pg/commitdiff/3dad73e71f08abd86564d5090a58ca71740e07e0

Tom Lane a poussé :

  • Fix typo in docs. s/XIDs XIDs/XIDs/ in one place in maintenance.sgml. Guillaume Lelarge http://git.postgresql.org/pg/commitdiff/1add956ac70384a99ed6606e2963a5a53f567add
  • Reject duplicate column names in foreign key referenced-columns lists. Such cases are disallowed by the SQL spec, and even if we wanted to allow them, the semantics seem ambiguous: how should the FK columns be matched up with the columns of a unique index? (The matching could be significant in the presence of opclasses with different notions of equality, so this issue isn't just academic.) However, our code did not previously reject such cases, but instead would either fail to match to any unique index, or generate a bizarre opclass-lookup error because of sloppy thinking in the index-matching code. David Rowley http://git.postgresql.org/pg/commitdiff/9da86753735ab89b0ee685aea985b25c4218ca0b
  • Further cleanup of JSON-specific error messages. Fix an obvious typo in json_build_object()'s complaint about invalid number of arguments, and make the errhint a bit more sensible too. Per discussion about how to word the improved hint, change the few places in the documentation that refer to JSON object field names as "names" to say "keys" instead, since that's what we've said in the vast majority of places in the docs. Arguably "name" is more correct, since that's the terminology used in RFC 7159; but we're stuck with "key" in view of the naming of json_object_keys() so let's at least be self-consistent. I adjusted a few code comments to match this as well, and failed to resist the temptation to clean up some odd whitespace choices in the same area, as well as a useless duplicate PG_ARGISNULL() check. There's still quite a bit of code that uses the phrase "field name" in non-user- visible ways, so I left those usages alone. http://git.postgresql.org/pg/commitdiff/495cadda5ed55f63db9a91d174b6fad0e1816204
  • Clean up handling of unknown-type inputs in json_build_object and friends. There's actually no need for any special case for unknown-type literals, since we only need to push the value through its output function and unknownout() works fine. The code that was here was completely bizarre anyway, and would fail outright in cases that should work, not to mention suffering from some copy-and-paste bugs. http://git.postgresql.org/pg/commitdiff/92f57c9ae95668636bc77d3cda3edbdfd83320d9
  • Clarify type resolution behavior for domain types. The user documentation was vague and not entirely accurate about how we treat domain inputs for ambiguous operators/functions. Clarify that, and add an example and some commentary. Per a recent question from Adam Mackler. It's acted like this ever since we added domains, so back-patch to all supported branches. http://git.postgresql.org/pg/commitdiff/6aa61580e08d58909b2a8845a4087b7699335ee0

Peter Eisentraut a poussé :

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Dilip Kumar sent in another revision of a patch to allow parallel cores to be used by vacuumdb.
  • Etsuro Fujita sent in another revision of a patch to optimize writes to foreign tables using the PostgreSQL FDW.
  • Alexander Korotkov sent in another revision of a patch to add KNN-GiST with recheck.
  • Heikki Linnakangas sent in a patch to create an SSL regression test suite.
  • Fabien COELHO sent in two more revisions of a patch to add modulo to pgbench.
  • Jeff Davis sent in two more revisions of a patch to implement better memory accounting, infrastructure for a memory-bounded HashAgg.
  • Fujii Masao sent in a patch to add PGC_SU_BACKEND.
  • Jeff Janes sent in a patch to fix one of the regression tests changed by another patch which fixed redundant i18n strings in json.
  • Fujii Masao sent in two more revisions of a patch to add a synchrounous mode to pg_receivexlog.
  • Robert Haas and Peter Geoghegan traded patches to add an optional comparator for B-Tree sort support.
  • David Rowley sent in two more revisions of a patch to allow certain SEMI and ANTI join removals.
  • Alvaro Herrera and Heikki Linnakangas traded patches to implement minmax indexes.
  • Marko (johto) Tiikkaja sent in another revision of a patch to add plpgsql.extra_warnings='num_into_expressions'.
  • Marko (johto) Tiikkaja sent in two revisions of a patch to enable PGP signatures in the pgcrypto extenstion.
  • Tatsuo Ishii and Fabien COELHO started patching pgbench to ensure that its parameters are checked better.
  • Etsuro Fujita sent in two revisions of a patch to compute attr_needed for child rels. As there were already two different places this functionality was used, this patch factored out the functionality in order to add a third use case, namely allowing foreign tables to be in table inheritance hierarchies.
  • Heikki Linnakangas sent in another revision of a patch to Invent a new internal API for interfacing with SSLv3.
  • Fujii Masao sent in a patch to enable specifying the unit in storage parameters.
  • Pavel Stehule and Fujii Masao traded patches to allow tab completion for \pset variables in psql.
  • Marko (johto) Tiikkaja sent in a patch to add PGP armor headers in the pgcrypto extension.
  • MauMau sent in another revision of a patch to fix an unconditional truncation that should have been a conditional truncation for temporary relations.
  • Fujii Masao sent in a patch to add a new GIN index storage parameter "PENDING_LIST_CLEANUP_SIZE" which specifies the maximum size of GIN pending list.
  • Michael Paquier sent in a patch to add support for N synchronous standby servers for N > 1.
  • Jeff Davis sent in a patch to enable memory-bounded HashAgg.