La seconde CommitFest du nouveau cycle de développement de PostgreSQL a commencé :
https://commitfest.postgresql.org/action/commitfest_view/inprogress
http://wiki.postgresql.org/wiki/Reviewing_a_Patch
https://commitfest.postgresql.org/action/commitfest_view?id=19

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en septembre

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

Robert Haas a poussé :

Peter Eisentraut a poussé :

Fujii Masao a poussé :

Bruce Momjian a poussé :

Kevin Grittner a poussé :

Noah Misch a poussé :

  • Ignore interrupts during quickdie(). Once the administrator has called for an immediate shutdown or a backend crash has triggered a reinitialization, no mere SIGINT or SIGTERM should change that course. Such derailment remains possible when the signal arrives before quickdie() blocks signals. That being a narrow race affecting most PostgreSQL signal handlers in some way, leave it for another patch. Back-patch this to all supported versions. http://git.postgresql.org/pg/commitdiff/d41cb869aad493178777b6e6e8d1425535349acb

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Peter Geoghegan sent in two revisions of a patch to implement INSERT ... ON DUPLICATE KEY LOCK FOR UPDATE.
  • Zoltan Boszormenyi sent in another revision of a patch to implement fetch readahead for ECPG.
  • Blake Smith sent in another revision of a patch to speed up queries with hstore using GIN indexes.
  • Heikki Linnakangas and Stephen Frost traded patches to fix an issue in libpq's interaction with SSL.
  • Satoshi Nagayasu sent in two more revisions of a patch to collect a statistic for WAL buffer dirty writes called pg_stat_walwriter.dirty_write.
  • Noah Misch sent in a patch to fix a case where SIGQUIT sent after a query cancel, the cancel takes precedent and the backend survives.
  • Bruce Momjian sent in a patch to issue a warning when SET TRANSACTION is called outside a transaction block.
  • Ronan Dunklau sent in a patch to implement triggers on foreign tables.
  • Bruce Momjian sent in a patch to fix some functions in contrib/unaccent to be immutable.
  • Fujii Masao sent in another revision of a patch to compress full-page writes.
  • Peter Eisentraut sent in a patch to document how to use FOP to build the PDF documentation.
  • Samrat Revagade and Sawada Masahiko traded patches to allow fail-back without taking a fresh backup.
  • Robert Haas sent in a set of patches to allow terminating background workers, a way to flag same, and some test code. This may eventually lead to parallel query.
  • Peter Eisentraut sent in a patch to remove the maintainer-check target, roll its functionality into the regular build, and include Andrew Dunstan's check for duplicate OIDs.
  • Peter Eisentraut sent in a patch to split off pg_fatal() from pg_log() in pg_upgrade.
  • Kevin Grittner sent in a patch to implement a record_identical() operator as part of the infrastructure for maintaining materialized views.
  • MauMau sent in another revision of a patch to make sure shutting down in immediate mode is reliable.
  • Andrew (RhodiumToad) Gierth sent in another revision of a patch to make UNNEST take multiple heterogeneous array arguments and have TABLE() do similar with multiple SRFs.
  • Robert Haas and Amit Kapila sent in another revision of a patch to implment dynamic shared memory.
  • Dimitri Fontaine sent in a patch to complete the stock PL support for EVENT TRIGGERS.
  • Peter Eisentraut sent in another revision of a patch to implement TRANSFORMS.
  • Peter Eisentraut sent in a patch to use asprintf() on platforms that support it.
  • Atri Sharma and Andrew (RhodiumToad) Gierth traded patches implementing WITHIN GROUP.
  • Marko (johto) Tiikkaja sent in a patch to implement a strict mode for PL/pgsql.
  • Richard Poole sent in a WIP patch to adds the MAP_HUGETLB flag to mmap() for shared memory on systems that support it. The patch is based on Christian Kruse's patch from last year, incorporating suggestions from Andres Freund.
  • Marko (johto) Tiikkaja sent in three more revisions of a patch to add a COMPACT mode for errors where the CONTEXT field is omitted for all non-error messages.
  • Marko (johto) Tiikkaja sent in two revisions of a patch to (optionally) print more information on STRICT failures in PL/PgSQL:
  • Amit Kapila sent in another revision of a patch to compute the max LSN of pages.
  • Peter Eisentraut sent in another revision of a patch to implement information_schema.parameters.parameter_default.
  • Andres Freund sent in a patch to allow custom GUCs to be nested more that one level in config files.
  • Peter Eisentraut sent in another revision of a patch to revive the line type.
  • Bernd Helmle sent in a patch to create a GUC for page checksums.
  • Alvaro Herrera sent in another revision of a patch to implement min-max indexes.
  • Andres Freund sent in a flock of patches intended to help with logical changesets. Details here: http://www.postgresql.org/message-id/20130914204913.GA4071@awork2.anarazel.de
  • Marko (johto) Tiikkaja sent in two revisions of a patch to add ASSERTions to PL/pgsql.
  • Abhijit Menon-Sen sent in another revision of a patch to implement bitmap indexes.
  • Amit Kapila sent in two more revisions of a patch to fix some inconsistent behavior in table inheritance.
  • Satoshi Nagayasu sent in another revision of a patch to update contrib/pgstattuple.
  • Alexander Korotkov sent in another revision of a patch to improve GIN indexes with optional information.
  • Satoshi Nagayasu sent in another revision of a patch to add CLUSTER statistics.