Félicitations aux nouveaux commiteurs : Etsuro Fujita, Peter Geoghegan, Amit Kapila, Alexander Korotkov, Thomas Munro, Michael Paquier et Tomas Vondra !

[ndt: Rencontre PostgreSQL à Toulouse le 5 juin : https://www.meetup.com/fr-FR/PostgreSQL-User-Group-Toulouse/]

Les nouveautés des produits dérivés

Offres d'emplois autour de PostgreSQL en juin

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. La version originale se trouve à l'adresse suivante : http://www.postgresql.org/message-id/20180603222541.GA11266@fetter.org

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.

Correctifs appliqués

Bruce Momjian pushed:

Andrew Dunstan pushed:

  • Return a value from Install.pm's lcopy function. Commit 3a7cc727c was a little over eager about adding an explicit return to this function, whose value is checked in most call sites. This change reverses that and returns the expected value explicitly. It also adds a check to the one call site lacking one. https://git.postgresql.org/pg/commitdiff/01deec5f8ae64b5120cc8c93d54fe0e19e477b02
  • Fix compile-time warnings on all perl code. This patch does two things. First, it silences a number of compile-time warnings in the msvc tools files, mainly those due to the fact that in some cases we have more than one package per file. Second it supplies a dummy Perl library with just enough of the Windows API referred to in our code to let it run these checks cleanly, even on Unix machines where the code is never supposed to run. The dummy library should only be used for that purpose, as its README notes. https://git.postgresql.org/pg/commitdiff/0039049fb1d76afef05d550823b27731ad7d7b3d

Peter Eisentraut pushed:

Teodor Sigaev pushed:

�lvaro Herrera pushed:

Noah Misch pushed:

Correctifs en attente

Micha�l Paquier sent in another revision of a patch to support channel binding in various TLS implementations.

Andres Freund and �lvaro Herrera traded patches to ensure relcache entries for nailed relations are accurate.

Craig Ringer sent in two revisions of a patch to install pg_isolation_regress, not just isolationtester.

Micha�l Paquier sent in two revisions of a patch to ensure that pg_replication_slot_advance returns NULL instead of 0/0 when a slot is not advanced.

Micha�l Paquier sent in two more revisions of a patch to rework scram_channel_binding to protect from downgrade attacks.

Vik Fearing sent in a patch to implement tab completion in psql for TABLE.

Craig Ringer sent in another revision of a patch to PANIC when we detect a possible fsync I/O error instead of retrying fsync.

Edmund Horner sent in a patch to remove a redundant psql tab-completion for CREATE PUBLICATION.

Justin Pryzby sent in a patch to add psql tab completions for several of the new VACUUM and ANALYZE options.

Micha�l Paquier sent in a patch to support tls-server-end-point on old version (1.0.0 and 1.0.1) of OpenSSL.

Daniel Gustafsson sent in two revisions of a patch to change uses of bms_num_members() without storing the returned count to use bms_membership(), which is optimized for that case.

Manuel Kniep sent in a patch to enable passing PGOPTIONS to pg_regress.

Daniel Gustafsson sent in a patch to avoid extra Sort nodes between WindowAggs when sorting can be reused.

Adrien Nayrat sent in two revisions of a patch to add a new GUC, log_sample_rate, to reduce the number of queries are actually logged.

David Rowley sent in a patch to allow direct lookups of AppendRelInfo by child relid.

Teodor Sigaev sent in two revisions of a patch to optimize GROUP BY by allowing reordering the columns, which then enables using n_distinct to speed up the process.

Carter Thaxton sent in another revision of a patch to add a --where option to pg_dump, which allows dumping prearranged subsets of the data.

James Coleman sent in another revision of a patch to implement incremental sort.

Micha�l Paquier sent in two revisions of a patch to fix and document lock handling for in-memory replication xslot data and fix a couple of bugs with replication slot advancing feature.

Justin Pryzby sent in another revision of a patch to fix some of the documentation for partition pruning.

L�titia Avrot sent in a patch to document the fact that CHECK constraints cannot reliably span tables, at least under pg_dump(all).

Amit Kapila sent in a patch to do some cosmetic cleanups for the patch which speeds up adding columns with defaults other than NULL.

Dmitry Dolgov sent in a patch to check for stable expressions in partition pruning.

Emre Hasegeli sent in another revision of a patch to fix the floating point handling in geometric types.