Nouvelles hebdomadaires de PostgreSQL - 22 septembre 2013
CommitFest II du nouveau cycle en est au quart de sa course. Avec 83 patchs dont 6 déjà commités, ça se déroule plutôt bien jusque là. 8 patchs restent tristement sans relecteur. Corrigeons cela cette semaine. Si vous souhaitez participer, écrivez à pgsql-rrreviewers list (infos sur l'inscription ci-après) et nous vous aiderons à nous aider : http://www.postgresql.org/community/lists/subscribe/
Les nouveautés des produits dérivés
- Sortie de HadoopFDW : http://www.bigsql.org/se/hadoopfdw/
Offres d'emplois autour de PostgreSQL en septembre
- Internationales : http://archives.postgresql.org/pgsql-jobs/2013-09/threads.php;
- Francophones : http://forums.postgresql.fr/viewforum.php?id=4.
PostgreSQL Local
- Le PGDay italien (PGDay.IT) sera tenu le 25 octobre à Prato (Italie, Toscane) au centre de recherche de l'Université Monash. Inscriptions et infos : http://2013.pgday.it
- La PostgreSQL Conference China de 2103 aura lieu les 26 & 27 octobre à Hangzhou. Informations :
https://wiki.postgresql.org/wiki/Pgconf_cn2013
Inscriptions : http://bbs.pgsqldb.com/client/bm.php - La PGConf.EU 2013 sera tenue du 29 octobre au 1er novembre au Conrad Hotel dans le centre-ville de Dublin en Irlande. Les inscriptions sont ouvertes : http://2013.pgconf.eu/
- PGConf.DE 2013 aura lieu le 8 novembre 2013 au musée industriel de la Rhénanie à Oberhausen. L'appel à conférenciers porte jusqu'au 15 septembre : http://2013.pgconf.de/
- La quatrième édition du PGDay argentin se tiendra le 14 novembre 2013 à Buenos Aires, Argentine. L'appel à conférenciers est lancé jusqu'au 28 septembre : http://wiki.postgresql.org/wiki/PGDay_Argentina_2013
- Le PGDay cubain aura lieu en novembre 2013 : http://postgresql.uci.cu/
PostgreSQL dans les média
- Planet PostgreSQL : http://planet.postgresql.org/
- Planet PostgreSQLFr : http://planete.postgresql.fr/
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é :
- Add a GUC to report whether data page checksums are enabled. Bernd Helmle http://git.postgresql.org/pg/commitdiff/0892ecbc015930dde2cee9ad464b9b70fdb7667e
Alvaro Herrera a poussé :
- Rename various "freeze multixact" variables. It seems to make more sense to use "cutoff multixact" terminology throughout the backend code; "freeze" is associated with replacing of an Xid with FrozenTransactionId, which is not what we do for MultiXactIds. Andres Freund Some adjustments by Álvaro Herrera http://git.postgresql.org/pg/commitdiff/dd778e9d888454fdd2c25c66fc268ba9844eb125
- Remove `proc` argument from LockCheckConflicts. This has been unused since commit 8563ccae2caf. Noted by Antonin Houska http://git.postgresql.org/pg/commitdiff/1247ea28cbc834bd6750b569537baff4e35edf79
Robert Haas a poussé :
- Typo fix. Etsuro Fujita http://git.postgresql.org/pg/commitdiff/86a174bff0730791c5c262d646d4fe28c2485be1
- Documentation correction. Etsuro Fujita http://git.postgresql.org/pg/commitdiff/eb3b79ffd4c456b49325df0002dbc4cb6a3741e7
- Fix compiler warning in WaitForBackgroundWorkerStartup(). Per complaint from Andrew Gierth. http://git.postgresql.org/pg/commitdiff/496439d943565bdb6cb2eef534cce551c30e8a0f
Fujii Masao a poussé :
- Fix typo in comment. Ian Lawrence Barwick http://git.postgresql.org/pg/commitdiff/6e5f6e59134c4829060321b875e86c538adc0914
Correctifs rejetés (à ce jour)
- No one was disappointed this week
Correctifs en attente
- Ronan Dunklau sent in another revision of a patch to add triggers to foreign tables.
- Wang Shuo sent in another revision of a patch to skip rewriting the table for allowable changes to NUMERIC columns via ALTER TABLE.
- Dean Rasheed and Marko (johto) Tiikkaja traded patches to expand the writeability of VIEWs by determining which can be changed in a sane way.
- Alvaro Herrera and Jaime Casanova traded patches for minmax indexes.
- Alvaro Herrera sent in a patch to refactor relscan_details.h out of relscan.h to reduce unneeded #includes of the same header.
- Heikki Linnakangas sent in another revision of an instrumentation patch to with two functions: one to consume N xids, making it faster to hit the creation of new XID ranges and wraparound, The other, print_xidlsnranges(), to print out the contents of the current XID-LSN range array.
- Samrat Revagade and Sawada Masahiko traded patches to make it possible to fail back without first creating a fresh backup.
- Rushabh Lathia sent in another revision of a patch to disallow year fields of length greater than 4 in all cases.
- Hamid Quddus Akhtar sent in a patch to fix a bug in output/security_label.source where it refers to abs_builddir instead of libdir.
- Marko (johto) Tiikkaja sent in another revision of a patch to implement a GUC plpgsql.print_strict_params which gives more detail about parameter problems in PL/pgsql functions when set.
- Jeevan Chalke sent in another revision of a patch to create a simple date constructor for numeric values.
- Sameer Thakur and Daniel Farina traded patches to fix some mis-countings in pg_stat_statements.
- Rushabh Lathia, Robert Haas, and Amit Kapila traded patches to fix an inconsistency in checking for table inheritance.
- Andres Freund sent in two more flocks of patches which are inteded to be infrastructure for logical changeset replication.
- Alexander Korotkov sent in two more revisions of a patch to improve GIN indexing by adding some additional information.
- Alexander Korotkov sent in a patch to fix KNN-GiST behaviour with NaN.
- Pavel Stehule sent in another revision of a patch to add LOB utility functions load_lo and make_lo.
- Vik Fearing sent in a patch to fix the interaction between relocatable extensions and pg_dump/pg_restore.
- Andres Freund sent in another revision of a patch to allow custom GUCs to be nested more than one level.
- KONDO Mitsumasa sent in a patch to add a Gaussian distribution to pgbench.
- David Rowley sent in three more revisions of a patch to allow formatting in log_line_prefix.
- Robert Haas sent in another revision of a patch to implement dynamic shared memory.
- Mike Blackwell sent in a doc patch to clarify the OPTIONS clause in contrib/file_fdw.
- Alvaro Herrera sent in a patch to handle SSL renegotiation cleanly.
- Heikki Linnakangas sent in a patch to detect an issue where freezing incorrectly releases any predicate locks.
- KaiGai Kohei sent in another revision of a patch to implement row-level access control, this time with a mitigation for a side-channel attach to which the previous patch was vulnerable.
- Vik Fearing sent in another revision of a patch to implement pg_sleep(interval).
- Fabien COELHO sent in a flock of patches improving pgbench progress reports.
- Didier (did447 AT gmail DOT com) sent in a patch to fix a small memory leak in guc-file.l ParseConfigFile.
- Stas Kelvich sent in a patch to add kNN search for cubes with euclidean, taxicab and Chebyshev distances.