Communauté francophone de PostgreSQL

<p><strong>Nouvelles hebdomadaires de PostgreSQL - 14 mars 2010</strong></p> <p>Les mises &agrave; jour (pour cause de bug) 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24 et 7.4.28 seront disponibles sous peu. Pr&eacute;parez-vous &agrave; mettre &agrave; jour&nbsp;!</p> <p>Le PUG de San Francisco fera une "F&ecirc;te du Test" mondiale le samedi 3 avril. Que vous soyez dans pr&egrave;s de la Baie de San Francisco ou non, jetez un oeil sur les d&eacute;tails&nbsp;: <a target="_blank" href="http://it.toolbox.com/blogs/database-soup/april-3-postgresql-testfest-day-37458">http://it.toolbox.com/blogs/database-soup/april-3-postgresql-testfest-day-37458</a></p> <p>PostgreSQLfr tiendra un stand lors des Solutions Linux 2010 &agrave; Paris (16-18 mars, Porte de Versailles). Volontaires, n'h&eacute;sitez pas &agrave; contacter St&eacute;phane Schildknecht &agrave; l'adresse sas CHEZ postgresql POINT fr, ou sur la liste g&eacute;n&eacute;rale&nbsp;: bureau CHEZ postgresql POINT fr. Plus d'informations sur l'&eacute;v&eacute;nement&nbsp;: <a target="_blank" href="http://www.solutionslinux.fr">http://www.solutionslinux.fr</a></p> <p><strong>Les nouveaut&eacute;s des produits d&eacute;riv&eacute;s</strong></p> <ul> <li>Archiveopteryx 3.1.3, un gestionnaire de courriels bas&eacute; sur PostgreSQL&nbsp;: <a target="_blank" href="http://www.archiveopteryx.org/3.1.3">http://www.archiveopteryx.org/3.1.3</a></li> <li>pgAdmin 1.10.2, un outil graphique de gestion pour PostgreSQL&nbsp;: <a target="_blank" href="http://www.postgresql.org/ftp/pgadmin3/release/v1.10.2/">http://www.postgresql.org/ftp/pgadmin3/release/v1.10.2/</a></li> <li>PostGIS 1.4.2 et 1.5.1&nbsp;: <a target="_blank" href="http://postgis.org/download">http://postgis.org/download</a></li> </ul> <p><strong>La fonctionnalit&eacute; 9.0 de la semaine</strong></p> <p>En PL/pgsql, l'instruction MOVE fonctionne maintenant en accord avec les curseurs.</p> <p><strong>Offres d'emplois autour de PostgreSQL en mars</strong></p> <ul> <li>Internationales&nbsp;: <a target="_blank" href="http://archives.postgresql.org/pgsql-jobs/2010-03/threads.php">http://archives.postgresql.org/pgsql-jobs/2010-03/threads.php</a>;</li> <li>Francophones&nbsp;: <a target="_blank" href="http://forums.postgresql.fr/viewforum.php?id=4">http://forums.postgresql.fr/viewforum.php?id=4</a>.</li> </ul> <p><strong>PostgreSQL Local</strong></p> <ul> <li>Le PUG allemand aura un stand aux Linuxdays de Chemnitz les 13 et 14 mars 2010. Andreas (ads) Scherbaum y donnera une conf&eacute;rence sur PostgreSQL 9.0 et dirigera un atelier sur la configuration de PostgreSQL&nbsp;: <a target="_blank" href="http://andreas.scherbaum.la/blog/archives/652-PostgreSQL-stand-at-Chemnitz-Linux-Days-2010.html">http://andreas.scherbaum.la/blog/archives/652-PostgreSQL-stand-at-Chemnitz-Linux-Days-2010.html</a> <a target="_blank" href="http://chemnitzer.linux-tage.de/2010/vortraege/plan.html">http://chemnitzer.linux-tage.de/2010/vortraege/plan.html</a></li> <li>La "JDCon East" aura lieu &agrave; Philadelphie (Pennsylvanie, &Eacute;tats-Unis) du 25 au 28 mars 2010&nbsp;: <a target="_blank" href="http://www.postgresqlconference.org/2010/east">http://www.postgresqlconference.org/2010/east</a></li> <li>Le PUG de San Francisco fera une "F&ecirc;te du Test" le samedi 3 avril de 11h &agrave; 18h. Vid&eacute;o en direct. Aidez &agrave; en faire un &eacute;v&eacute;nement mondial&nbsp;! <a target="_blank" href="http://wiki.postgresql.org/wiki/SFPUG_Beta_Test_Day">http://wiki.postgresql.org/wiki/SFPUG_Beta_Test_Day</a></li> <li>La "Linuxfest Northwest 2010" aura lieu &agrave; Bellingham, Washington, &Eacute;tats-Unis les 24 et 25 avril. Conf&eacute;rences, r&eacute;unions et m&eacute;c&eacute;nat sont proposables&nbsp;: <a target="_blank" href="http://linuxfestnorthwest.org/">http://linuxfestnorthwest.org/</a></li> <li>Andreas (ads) Scherbaum enseignera au centre pour adultes de Magdeburg (All.) du 3 au 7 mai 2010 sur le sujet "PostgreSQL for Corporate Use". D&eacute;tails ci-apr&egrave;s&nbsp;: <a target="_blank" href="http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html">http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html</a></li> <li>La PgCon 2010 aura lieu les 20 &amp; 21 mai 2010 &agrave; Ottawa avec des tutoriels les 18 et 19&nbsp;: <a target="_blank" href="http://www.pgcon.org/2010/registration.php">http://www.pgcon.org/2010/registration.php</a></li> <li>L'appel aux conf&eacute;renciers pour l'OSBridge est lanc&eacute;&nbsp;! L'&eacute;v&eacute;nement aura lieu du 1er au 4 juin 2010 &agrave; Portland (Oregon)&nbsp;: <a target="_blank" href="http://opensourcebridge.org/events/2010/proposals/">http://opensourcebridge.org/events/2010/proposals/</a></li> <li>L'OSCON aura lieu &agrave; Portland (Oregon) du 19 au 23 juillet 2010&nbsp;: <a target="_blank" href="http://www.oscon.com/oscon2010">http://www.oscon.com/oscon2010</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. Traduction par l'&eacute;quipe PostgreSQLFr sous licence CC BY-NC-SA.</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>(<a target="_blank" href="http://www.postgresql.org/community/weeklynews/pwn20100314">lien vers l'article original</a>)</p> <p><strong>Correctifs appliqu&eacute;s</strong></p> <p>Magnus Hagander a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/libpq/hba.c, disallow gssapi authentication on local connections, since it requires a hostname to function. Noted by Zdenek Kotala.</li> <li>In pgsql/src/interfaces/libpq/fe-auth.c, require hostname to be set when using GSSAPI authentication. Without it, the GSSAPI libraries crash. Noted by Zdenek Kotala.</li> <li>In pgsql/doc/src/sgml/ref/psql-ref.sgml, add missing space in example. Tim Landscheidt.</li> </ul> <p>Michael Meskes a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/interfaces/ecpg/ecpglib/error.c, better test the content of the SQLSTATE string in ecpglib than the pointer.</li> <li>In pgsql/src/interfaces/ecpg/ecpglib/error.c, backport fix from HEAD that makes ecpglib give the right SQLSTATE if the connection disappears.</li> <li>Ecpg now adds a unique counter to its varchar struct definitions to make these definitions unique, too. It used to use the linenumber but in the rare case of two definitions in one line this was not unique.</li> </ul> <p>Bruce Momjian a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/bin/psql/command.c, return proper exit code (3) from psql when ON_ERROR_STOP=on and --single-transaction are both used and the failure happens in commit, e.g. failed deferred trigger. Also properly free BEGIN/COMMIT result structures from --single-transaction. Per report from Dominic Bevacqua</li> <li>In pgsql/doc/src/sgml/config.sgml, remove unnecessary comma in documentation.</li> <li>In pgsql/doc/src/sgml/config.sgml, re-add comma, oops.</li> <li>In pgsql/src/timezone/zic.c, small adjustment by pgindent.</li> <li>In pgsql/src/backend/tsearch/wparser_def.c, allow underscores in tsearch email addressses, per RFC 5322 and report by Dan O'Hara. Patch by Teodor Sigaev</li> <li>In pgsql/doc/src/sgml/textsearch.sgml, document what user name email symbols are supported by tsearch.</li> <li>Add libpq warning message if the .pgpass-retrieved password fails. Add ERRCODE_INVALID_PASSWORD sqlstate error code.</li> <li>In pgsql/src/backend/libpq/pqcomm.c, move TCP keepalive macro definition. Jaime Casanova</li> <li>In pgsql/src/backend/libpq/pqcomm.c, move more tcp keepalive macros to be consistent.</li> <li>In pgsql/src/backend/libpq/pqcomm.c, revert all keepalive moves, reevaluate.</li> </ul> <p>Andrew Dunstan a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/pl/plperl/plperl.c, add checks for valid encoding of query strings passed to SPI by plperl.</li> </ul> <p>Alvaro Herrera a commit&eacute;&nbsp;:</p> <ul> <li>Update time zone data files to tzdata release 2010e: DST law changes in Fiji, Samoa, Chile; corrections to recent changes in Paraguay and Bangladesh.</li> <li>Improve PL/Perl documentation of database access functions. (Backpatch to 8.4 of a patch previously applied by Bruce Momjian to CVS HEAD) Alexey Klyukin.</li> </ul> <p>Tom Lane a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/pl/plperl/plperl.c, use SvROK(sv) rather than directly checking SvTYPE(sv) == SVt_RV in plperl. The latter is considered unwarranted chumminess with the implementation, and can lead to crashes with recent Perl versions. Report and fix by Tim Bunce. Back-patch to all versions containing the questionable coding pattern.</li> <li>Preliminary release notes for releases 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24, 7.4.28.</li> <li>In pgsql/src/include/catalog/pg_constraint.h, update comment for pg_constraint.conindid to mention that it's used for exclusion constraints. Not sure how we managed to update the comment for it in catalogs.sgml but miss this one.</li> <li>Simplify a couple of pg_dump and psql \d queries about index constraints by joining to pg_constraint.conindid, instead of the former technique of joining indirectly through pg_depend. This is much more straightforward and probably faster as well. I had originally desisted from changing these queries when conindid was added because I was worried about losing performance, but if we join on conrelid as well as conindid then the index on conrelid can be used when pg_constraint is large.</li> <li>In pgsql/src/bin/psql/describe.c, modify psql's \d printout to fold exclusion constraints in with regular indexes, rather than printing them twice. Per my gripe when the exclusion constraint feature was committed.</li> <li>In pgsql/src/backend/access/common/reloptions.c, add missing reset of need_initialization in reloptions code. This resulted in useless extra work during every call of parseRelOptions, but no bad effects other than that. Noted by Alvaro Herrera.</li> <li>In pgsql/src/timezone/pgtz.c, fix a commented-out block of code that pgindent didn't understand properly; it's been making that comment uglier with each run.</li> <li>In pgsql/src/backend/postmaster/pgstat.c, add some logging code for unexpected cases, particularly being unable to read a stats file for reasons other than ENOENT, and having to reset last_statrequest because it's later than current time in the collector. Not clear if this will shed any light on the "pgstat wait timeout" business, but it seems like a good idea in general. In passing, do some message-style-police work on recently-added pgstat_reset_shared_counters code.</li> <li>Update oidjoins regression test for 9.0.</li> </ul> <p>ITAGAKI Takahiro a commit&eacute;&nbsp;:</p> <ul> <li>pg_start_backup() can use a share lock to lock ControlFileLock instead of an exclusive lock. The change is almost for code cleanup. Since there seems to be no performance benefits from it, backports should not be needed. Fujii Masao</li> </ul> <p>Robert Haas a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/commands/tablecmds.c, fix incorrect comment about permissions checking being done in utility.c. Noted while reviewing a patch from KaiGai Kohei.</li> </ul> <p>Heikki Linnakangas a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/src/backend/storage/ipc/standby.c, fix comment which was apparently copy-pasted from another function.</li> <li>In pgsql/src/backend/storage/ipc/procarray.c, fix bug in KnownAssignedXidsMany(). I saw this when looking at the assertion failure reported by Erik Rijkers, but this alone doesn't explain the failure.</li> </ul> <p>Marc Fournier a commit&eacute;&nbsp;:</p> <ul> <li>Tag 8.4.3, 8.3.10, 8.2.16, 8.1.20, 8.0.24, and 7.4.28.</li> </ul> <p>Peter Eisentraut a commit&eacute;&nbsp;:</p> <ul> <li>In pgsql/doc/src/sgml/runtime.sgml, update shared memory configuration information for Linux In particular, the assertion that shmall is sufficiently sized by default is slowly becoming untrue.</li> <li>In pgsql/doc/src/sgml/plpython.sgml, add some more structure and bits of information to PL/Python documentation</li> </ul> <p><strong>Correctifs rejet&eacute;s (&agrave; ce jour)</strong></p> <ul> <li>Dag-Erling Smorgrav's patch to address build issues on Windows XP with the MinGW toolkit. The actual fix will be to de-support --disable-shared.</li> </ul> <p><strong>Correctifs en attente</strong></p> <ul> <li>Fujii Masao sent in a patch which adds a new function pg_last_checkpoint_start_location() that reports the XLOG location where the last checkpoint or restartpoint started, i.e. the REDO starting location.</li> <li>Pavel Stehule sent in two revisions of a patch for 9.1 which adds a some string functions including format(), sprintf() and concat_*().</li> <li>Fujii Masao sent in a patch which makes it possible to interrupt walreceiver on win32.</li> <li>KaiGai Kohei sent in another revision of the patch to disallow renaming system-initialized objects such as the "columns" in sequences.</li> </ul>