<p><strong>Nouvelles hebdomadaires de PostgreSQL - 21 juin 2009</strong></p> <p>L'appel &agrave; conf&eacute;rences pour le PGDay.eu est lanc&eacute;&nbsp;: <a target="_blank" href="http://2009.pgday.eu/">http://2009.pgday.eu/</a></p> <p>&Agrave; partir du 1<sup>er</sup> octobre, 2ndQuadrant va offrir, pendant 15 mois, un support gratuit aux &eacute;tudiants de l'universit&eacute; de L'Aquila (r&eacute;gion des Abruzzes en Italie). Plus d'informations (en italien)&nbsp;: <a target="_blank" href="http://blog.2ndquadrant.it/it/2009/06/2ndquadrant-universita-aquila.html">http://blog.2ndquadrant.it/it/2009/06/2ndquadrant-universita-aquila.html</a></p> <p>L'"OpenSQL Camp" aura lieu les 22 &amp; 23 ao&ucirc;t &agrave; S<sup>t</sup> Augustin (All.), pr&egrave;s de Bonn et de Cologne. La date limite pour les propositions de conf&eacute;rences est le 19 juillet 2009&nbsp;: <a target="_blank" href="http://opensqlcamp.org/Events/2009/Call_for_Participation">http://opensqlcamp.org/Events/2009/Call_for_Participation</a></p> <p>L'appel &agrave; conf&eacute;rences pour la "PyCon Argentina" est lanc&eacute; jusqu'&agrave; la date du 29 juin 2009, 23h59 ART [ndt: UTC-3 ?]. La conf&eacute;rence elle-m&ecirc;me aura lieu &agrave; Buenos Aires les 4 &amp; 5 septembre 2009&nbsp;: <a target="_blank" href="http://ar.pycon.org/2009/rfp/">http://ar.pycon.org/2009/rfp/</a></p> <p><strong>Les nouveaut&eacute;s des produits d&eacute;riv&eacute;s</strong></p> <ul> <li>Benetl 2.8, un outil d'ETL utilisant PostgreSQL&nbsp;: <a target="_blank" href="http://www.benetl.net">http://www.benetl.net</a></li> <li>MicroOLAP Database Designer 1.2.8 pour PostgreSQL&nbsp;: <a target="_blank" href="http://microolap.com/products/database/postgresql-designer/">http://microolap.com/products/database/postgresql-designer/</a></li> <li>PostGIS 1.4.0 beta 1, un syst&egrave;me d'informations g&eacute;ospatiales pour PostgreSQL&nbsp;: <a target="_blank" href="http://postgis.refractions.net/">http://postgis.refractions.net/</a></li> <li>rubyrep 1.0.3, un syst&egrave;me de r&eacute;plication asynchrone ma&icirc;tre-ma&icirc;tre&nbsp;: <a target="_blank" href="http://www.rubyrep.org">http://www.rubyrep.org</a></li> </ul> <p><strong>La fonctionnalit&eacute; 8.4 de la semaine</strong></p> <p>EXPLAIN ANALYZE affiche l'utilisation de la m&eacute;moire par les diff&eacute;rents tris et hachage.</p> <p><strong>L'astuce de la semaine</strong></p> <p>User-set GUCs (system settings) such as work_mem and constraint_exclusion can be set as the property of a ROLE or of a function.</p> <p>(<a target="_blank" href="http://www.postgresql.org/community/weeklynews/pwn20090621">lien vers l'article original</a>)</p> <p><strong>Offres d'emplois autour de PostgreSQL en juin</strong></p> <ul> <li><a target="_blank" href="http://archives.postgresql.org/pgsql-jobs/2009-06/threads.php">http://archives.postgresql.org/pgsql-jobs/2009-06/threads.php</a></li> </ul> <p><strong>PostgreSQL Local</strong></p> <ul> <li>Le pgDay San Jose est programm&eacute; pour le dimanche 19 juillet, juste avant l'OSCON. Inscription ci-dessous&nbsp;: <a target="_blank" href="http://postgresql.meetup.com/1/calendar/10626647">http://postgresql.meetup.com/1/calendar/10626647</a></li> <li>L'appel aux conf&eacute;renciers est lanc&eacute; pour la "PGCon Brazil"&nbsp;! <a target="_blank" href="http://pgcon.postgresql.org.br/2009/chamadas.en.php">http://pgcon.postgresql.org.br/2009/chamadas.en.php</a></li> <li>La "PGCon Brazil" prendra place &agrave; l'Unicamp de Campinas (&Eacute;tat de S&atilde;o Paulo) les 23 &amp; 24 octobre 2009.</li> <li>Le PGDay.EU 2009 est programm&eacute; pour les 6 &amp; 7 novembre 2009 &agrave; Telecom ParisTech (ndt: ENST ?)&nbsp;: <a target="_blank" href="http://www.pgday.eu/">http://www.pgday.eu/</a></li> <li>Vos propositions de conf&eacute;rences sont attendues pour le 10<sup>&egrave;me</sup> anniversaire du JPUG. Le rassemblement aura lieu les 20 &amp; 21 novembre 2009 &agrave; Tokyo, Japan&nbsp;: <a target="_blank" href="http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php">http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php</a></li> </ul> <p><strong>PostgreSQL dans les m&eacute;dia</strong></p> <ul> <li>Planet PostgreSQL&nbsp;: <a target="_blank" href="http://planet.postgresql.org/">http://planet.postgresql.org/</a></li> <li>Planet PostgreSQLFr&nbsp;: <a target="_blank" href="http://planete.postgresql.fr/">http://planete.postgresql.fr/</a></li> </ul> <p><i>PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter et Josh Berkus. La traduction en est assur&eacute;e par l'&eacute;quipe PostgreSQLFr.</i></p> <p><i>Proposez vos articles ou annonces avant dimanche 15:00 (heure du Pacifique). Merci de les envoyer en anglais &agrave; david (a) fetter.org, en allemand &agrave; pwn (a) pgug.de, en italien &agrave; pwn (a) itpug.org.</i></p> <p><strong>Correctifs appliqu&eacute;s</strong></p> <p>Peter Eisentraut a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/pl/plpgsql/src/pl_exec.c, fix typo in error message: tgargv -&gt; tg_argv</li> <li>In pgsql/doc/src/sgml/maintenance.sgml, add another link of a GUC variable to where it is explained.</li> <li>Refine the use of terminology around bound and unbound cursors and cursor variables. Remove the confusing term "reference cursor".</li> <li>Add some more documentation and cross-links on using dblink with SQL/MED.</li> <li>In pgsql/doc/Makefile, don't attempt to "rm" directories on uninstall.</li> <li>Add manvolnum, so that man pages are generated.</li> <li>In pgsql/doc/src/sgml/Makefile, don't convert the man page names to lower case, so that the .so links work. This is pretty much a workaround for incomplete tools, but having the man page names in upper case looks more natural anyway.</li> <li>In pgsql/doc/Makefile, extend man page installation hackery so that the man page section is also fixed up in the .so links.</li> <li>Message fixes.</li> </ul> <p>Tom Lane a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/executor/nodeAgg.c, ExecAgg() failed to finish running out set-returning functions in the last aggregated tuple of a run. Per report from Laurenz Albe. This is a new bug in 8.4, but only because prior versions rejected SRFs in an Agg plan node altogether.</li> <li>Proofreading for Bruce Momjian's recent round of documentation proofreading. Most of those changes were good, but some not so good...</li> <li>Fix the just-reported problem that you can't specify all four trigger event types in CREATE TRIGGER. While at it, clean up the amazingly tedious and inextensible way that the trigger event type list was handled. Per report from Greg Sabino Mullane.</li> <li>Fix things so that array_agg_finalfn does not modify or free its input ArrayBuildState, per trouble report from Merlin Moncure. By adopting this fix, we are essentially deciding that aggregate final-functions should not modify their inputs ever. Adjust documentation and comments to match that conclusion.</li> </ul> <p>Heikki Linnakangas a commit&eacute;&nbsp;:</p> <ul> <li>Fix a few errors in comments. Patch by Fujii Masao, plus the one in visibilitymap.c by me.</li> </ul> <p><strong>Correctifs rejet&eacute;s (&agrave; ce jour)</strong></p> <ul> <li>Pas de d&eacute;ception cette semaine&nbsp;:-)</li> </ul> <p><strong>Correctifs en attente</strong></p> <ul> <li>Gurjeet Singh sent in a Perl program called neurodiff which allows comparing both regular expression matches and result sets independent of order.</li> <li>Robert Haas sent in a patch to change do_tup_output to take Datum arguments rather than cstring.</li> <li>Kevin Grittner sent in another version of his toast-main-out-of-line-reluctantly patch.</li> <li>Jeremy Kerr sent in another revision of his patch to compare word-at-a-time in src/backend/utils/adt/varchar.c's bcTruelen.</li> <li>Fujii Masao sent in another revision of the sync rep patch.</li> <li>Petr (PJMODOS) Jelinek sent in a patch which allows per-schema GRANT and REVOKE on database objects.</li> <li>Robert Haas sent in another revision of his "generic options for explain" patch.</li> <li>Robert Haas sent in another revision of his machine-readable explain output patch.</li> </ul>