<p><strong>Nouvelles hebdomadaires de PostgreSQL - 24 mai 2009</strong></p> <p>1&deg;) Publication de la beta 2 de la version 8.4 de PostgreSQL, 2&deg;) Tests&nbsp;: <a target="_blank" href="http://www.postgresql.org/developer/beta">http://www.postgresql.org/developer/beta</a></p> <p>PgCon fut un nouveau succ&egrave;s, avec une affluence accrue &agrave; contre-pied des autres conf&eacute;rences. Publication prochaine des vid&eacute;os des pr&eacute;sentations&nbsp;: <a target="_blank" href="http://www.pgcon.org/2009/">http://www.pgcon.org/2009/</a></p> <p>La vid&eacute;o de la r&eacute;union SFPUG du 23 mai 2009&nbsp;: "BIRT &amp; PostgreSQL" est &agrave; pr&eacute;sent disponible en lecture et t&eacute;l&eacute;chargement sur le serveur media.postgresql.org&nbsp;: <a target="_blank" href="http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov">http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov</a></p> <p>La conf&eacute;rence-anniversaire (10&egrave;me) du JPUG a lanc&eacute; son appel &agrave; participation&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></p> <p>La communaut&eacute; PostgreSQL/PostGIS se r&eacute;unira &agrave; Zurich le 6 juin 2009. D&eacute;tails (de_CH)&nbsp;: <a target="_blank" href="http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-H%C3%B6ck">http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-H&ouml;ck</a></p> <p><strong>Les nouveaut&eacute;s des produits d&eacute;riv&eacute;s</strong></p> <ul> <li>MicroOLAP Database Designer 1.2.8beta1, un syst&egrave;me de conception de BD pour PostgreSQL&nbsp;: <a target="_blank" href="http://microolap.com/products/database/postgresql-designer/">http://microolap.com/products/database/postgresql-designer/</a></li> </ul> <p><strong>La fonctionnalit&eacute; 8.4 de la semaine</strong></p> <p>Warm Standby&nbsp;: si, auparavant, configurer une reprise &agrave; chaud vous effrayait&nbsp;: re-tentez avec la 8.4, la prise en main est &agrave; pr&eacute;sent facilit&eacute;e.</p> <p><strong>L'astuce de la semaine</strong></p> <p>En attendant que les expressions de tables communes de la 8.4 et que le SQL/MED de la 8.5 soient disponibles, vous pouvez respectivement utiliser le module 'tablefunc' dans "contrib" et les fonctions d'inclusion pour, respectivement, des jointures via connectby() et consulter une base de donn&eacute;es depuis une autre.</p> <p>(<a target="_blank" href="http://www.postgresql.org/community/weeklynews/pwn20090524">lien vers l'article original</a>)</p> <p><strong>Offres d'emplois autour de PostgreSQL en mai</strong></p> <ul> <li><a target="_blank" href="http://archives.postgresql.org/pgsql-jobs/2009-05/threads.php">http://archives.postgresql.org/pgsql-jobs/2009-05/threads.php</a></li> </ul> <p><strong>PostgreSQL Local</strong></p> <ul> <li>Le PGDay de Junin / Buenos Aires aura lieu le 6 juin &agrave; l'Unnoba&nbsp;: <a target="_blank" href="http://www.arpug.com.ar/trac/wiki/PgDayUnnoba">http://www.arpug.com.ar/trac/wiki/PgDayUnnoba</a></li> <li>Notez la date&nbsp;: pgDay San Jose, dimanche 19 juillet juste avant l'OSCON. Appel &agrave; conf&eacute;renciers, plus d'infos sous peu&nbsp;!</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> </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> </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>Some documentation cleanup for the addition of the KOI8U encoding. Change all (remaining) mentions of KOI8 to the new canonical form KOI8R. Add information about the available conversions for KOI8U.</li> <li>Refer to tables by id, not by "the following table", because tables are in theory floating elements.</li> <li>In pgsql/src/backend/catalog/sql_features.txt, update SQL conformance entries for window functions functionality</li> <li>In pgsql/src/tools/editors/emacs.samples, add some instructions on how to customize emacs for working on the SGML sources.</li> <li>Add documentation string for LDFLAGS_SL in configure --help output.</li> <li>In pgsql/src/tools/editors/emacs.samples, fix sgml-mode example. Thanks, Andrew Dunstan.</li> <li>In pgsql/src/bin/pg_dump/pg_dump.c, convert some messages to use ngettext(). Author: Euler Taveira de Oliveira.</li> </ul> <p>Tom Lane a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/interfaces/libpq/fe-connect.c, make pwdfMatchesString() a little more careful about matching * fields.</li> <li>Fix bug #4814 (wrong subscript in consistent-function call), and add some minimal regression test coverage for matchPartialInPendingList().</li> <li>Fix LIKE's special-case code for % followed by _. I'm not entirely sure that this case is worth a special code path, but a special code path that gets the boundary condition wrong is definitely no good. Per bug #4821 from Andrew Gierth. In passing, clean up some minor code formatting issues (excess parentheses and blank lines in odd places). Back-patch to 8.3, where the bug was introduced.</li> <li>Use more-portable coding for the check on handing out the last available relopt_kind value in add_reloption_kind(). Per Zdenek Kotala.</li> </ul> <p>Heikki Linnakangas a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/commands/analyze.c, update relpages and reltuples estimates in stand-alone ANALYZE, even if there's no analyzable attributes or indexes. We also used to report 0 live and dead tuples for such tables, which messed with autovacuum threshold calculations. This fixes bug #4812 reported by George Su. Backpatch back to 8.1.</li> <li>In pgsql/src/backend/commands/tablecmds.c, silence a gcc compiler warning about non-literal format string with no args when compiling with -Wformat-security. Fujii Masao.</li> </ul> <p>Michael Meskes a commit&eacute;&nbsp;:</p> <ul> <li>Removed some unneeded variables and comparisons.</li> <li>More variables gcc moans about.</li> <li>Removed unsigned/signed mismatches.</li> <li>Removed comparison of unsigned expression &lt; 0.</li> </ul> <p>Teodor Sigaev a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/utils/adt/tsvector.c, re-sort tsvector's lexemes in tsvectorrecv instead of emitting an error. Basically, it's needed to support binary dump from 8.3 because the ordering rule was changed. Per discussion with Bruce Momjian.</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>Simon Riggs sent in two patches to improve read-only scalability.</li> <li>Pavel Stehule sent in another revision of the GROUPING SETS patch.</li> <li>Jim Nasby sent in a patch to add a feature to vacuumdb that allows analyze-only as an option.</li> <li>Robert Haas sent in a patch to add parenthesized options to EXPLAIN.</li> <li>Pavel Stehule sent in a patch to clean up some syntax warnings in tsquery_op.c</li> <li>Zdenek Kotala sent in two patches to do some cleanup to help pg_migrator.</li> <li>Tatsuhito Kasahara sent in a patch to fix ja.po.</li> <li>Steve Prentice sent in two versions of a patch to supplement Pavel Stehule's patch for named and mixed notation support in 8.5. Pavel sent in a followup that touches the main parser. Steve sent an updated patch.</li> <li>Dimitri Fontaine sent in a document patch for GiST extensions.</li> <li>Adriano Lange sent in a patch implementing 2PO, an alternative to the GEQO for optimizing large joins.</li> <li>Andres Freund sent in a patch to allow EXPLAIN ANALYZE to show counts of discarded tuples.</li> </ul>