Le PgDay argentin a besoin de soutien financier. Participations par là : http://www.postgresql.org.ar/pgday2013/crowdfunding?lang=en

La CommitFest II du cycle de la 9.4 s'est terminée, affichant de grands progrès dans la file d'attente des patchs. 20 patchs ont été poussés, dont certains concernent des fonctionnalités de premier plan.

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en octobre

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

  • Fix details missed by dynamic shared memory patch. Additional documentation update, and a comment fix. Both issues reported by Amit Kapila. http://git.postgresql.org/pg/commitdiff/05a0283e7a48ffdca96cb6dd94fa5bae06e29bd1
  • In dsm_impl_windows, don't error out when the segment already exists. This is the behavior of the other implementations, and the behavior expected by the callers of this function. Amit Kapila http://git.postgresql.org/pg/commitdiff/e5158613676d940cf71ecfb5c73ac933746ac847
  • initdb: Suppress dynamic shared memory when probing for max_connections. This might not be the right long-term solution here, but it will hopefully turn the buildfarm green again. Oversight noted by Andres Freund http://git.postgresql.org/pg/commitdiff/d41ab71712a4457ed39d5471b23949872ac91def
  • Remove spinlock support for SINIX, Sun3, and NS32K. All of these platforms are very much obsolete. As far as I can determine, the last version of SINIX, later renamed Reliant, occurred some time between 2002 and 2005. The last release of SunOS that would run on a sun3 was released in November of 1991; the last release of OpenBSD which supported that platform was in 2001. The highest clock speed of any processor in the family was 25MHz. The NS32K (national semiconductor 320xx) architecture was retired in 1990. Support can be re-added if a maintainer emerges for any of these platforms, but it seems unlikely. Reviewed by Andres Freund. http://git.postgresql.org/pg/commitdiff/81051a86bcecdc681592725139fe610b2c1d1428
  • Remove IRIX port. Development of IRIX has been discontinued, and support is scheduled to end in December of 2013. Therefore, there will be no supported versions of this operating system by the time PostgreSQL 9.4 is released. Furthermore, we have no maintainer for this platform. http://git.postgresql.org/pg/commitdiff/ea91a6be89575095f61ebf36d67c2df98be093db
  • Provide a reliable mechanism for terminating a background worker. Although previously-introduced APIs allow the process that registers a background worker to obtain the worker's PID, there's no way to prevent a worker that is not currently running from being restarted. This patch introduces a new API TerminateBackgroundWorker() that prevents the background worker from being restarted, terminates it if it is currently running, and causes it to be unregistered if or when it is not running. Patch by me. Review by Michael Paquier and KaiGai Kohei. http://git.postgresql.org/pg/commitdiff/523beaa11bdf6a9864e8978b467ed586b792c9ca
  • Allow only some columns of a view to be auto-updateable. Previously, unless all columns were auto-updateable, we wouldn't inserts, updates, or deletes, or at least not without a rule or trigger; now, we'll allow inserts and updates that target only the auto-updateable columns, and deletes even if there are no auto-updateable columns at all provided the view definition is otherwise suitable. Dean Rasheed, reviewed by Marko Tiikkaja http://git.postgresql.org/pg/commitdiff/cab5dc5daf2f6f5da0ce79deb399633b4bb443b5

Bruce Momjian a poussé :

Peter Eisentraut a poussé :

Alvaro Herrera a poussé :

Andrew Dunstan a poussé :

Noah Misch a poussé :

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • David Fetter sent in another revision of a patch to allow CREATE FOREIGN TABLE (... LIKE ...).
  • Andres Freund sent another flock of patches for logical changeset generation.
  • Vik Fearing sent in another revision of a patch to document how and when subqueries can modify data.
  • Vik Fearing sent in another revision of a patch to allow stats collection for the CLUSTER command.
  • Robert Haas sent in a patch to remove support for the Alpha architecture.
  • Tomas Vondra sent in two versions of a patch to add flow charts for the FDW API.
  • Vik Fearing sent in two more revisions of a patch to add pg_sleep_for(interval) and pg_sleep_until(timestamptz).
  • KONDO Mitsumasa sent in two approaches to a patch to improve pg_stat_statements.
  • Rajeev Rastogi sent in a patch to ensure that COPY FROM STDIN shows a count tag, which it did not before.
  • Fabrízio de Royes Mello sent in another revision of a patch to enable time-delayed standbys.
  • Dean Rasheed sent in another revision of a patch to allow tab completion for views and foreign tables in psql.
  • Peter Geoghegan sent in a patch to create an autovacuum_work_mem GUC.
  • Nigel Heron sent in a WIP patch to keep track of the number of bytes sent and received by the server over its communication sockets.