PostgreSQL Weekly News | Nouvelles neuves de PostgreSQL

Par N Bougain le 25/01/2008 - 20:21

Nouvelles hebdomadaires de PostgreSQL - 20 janvier 2008

PostgreSQL a remporté le prix Developer.com du Produit de l'Année 2008 :
http://www.developer.com/design/article.php/10925_3721761_1

IT-PUG a envoyé une lettre ouverte au ministre italien chargé de l'innovation technique à propos des fonds dédié à l'Open Source en 2007 :
http://www.gabrielebartolini.it/blog/index.php?/archives/40-IT-PUG-signs-a-letter-to-the-Italian-Ministry.html

Les nouveautés des produits dérivés

• DBD::Pg 2.0.0_5 (RC5) est disponible :
  http://search.cpan.org/~dbdpg/DBD-Pg/Pg.pm
• PGCluster-1.5.0rc17 est disponible :
  http://pgfoundry.org/projects/pgcluster/
• pg_proboscis 0.9.3 est sorti :
  http://pgfoundry.org/projects/python/
• IT-PUG a créé un plugin Firefox de recherche sur la documentation PostgreSQL :
  http://www.itpug.org/index.en.html
• Visual SQL Builder Pre-Alpha 0.3 est disponible, et a besoin de contributeurs et de testeurs :
  http://sourceforge.net/projects/vsqlbuilder

Offres d'emplois autour de Postgres en janvier

http://archives.postgresql.org/pgsql-jobs/2008-01/threads.php

PostgreSQL Local

• La première réunion du NYPUG se fera au Skylight Diner le 22 janvier à 19h30. RSVP to josh (a) postgresql (.) org :
  http://skylightdinernyc.com/
• Le PUG Européen va élire son nouveau bureau de direction. Si vous souhaitez suggérer un candidat ou pour le réglement du vote :
  http://www.pgug.eu/election.txt
• "Quoi de neuf dans PostgreSQL 8.3 ?" - petit déjeuner avec Bruce Momjian le 24 janvier 2008 à Londres. Envoyez un mail pour l'invitation : info.emea (a) enterprisedb (.) com
• Le "Prague PostgreSQL Developers' Day 2008" aura lieu le 13 février :
  http://www.dbsvet.cz/view.php?cisloclanku=2008011101
• Les PGCon 2008 auront lieu du 20 au 23 mai à Ottawa - propositions acceptées dès à présent :
  http://www.pgcon.org/2008/papers.php
• Les équipes BSD et PostgreSQL partageront un espace développeurs au FOSDEM 2008 de Bruxelles (23-24 février). Si vous souhaitez donner une conférence ou aider sur le stand, contactez fosdem (a) pgug (.) eu. Pour plus d'informations, jetez un œil sur :
  https://www.bsdwiki.de/FOSDEM_2008
• La PostgreSQL Conference East '08 est programmée les 28 et 29 mars 2008 à l'Université du Maryland, College Park . L'appel aux propositions a été lancé :
  http://www.postgresqlconference.org/
• Le FISL 9.0 se déroulera du 17 au 19 avril 2008 à la PUCRS de Porto Alegre (Brésil). Les propositions de conférences sont attendues avant le 11 janvier :
  https://fisl.softwarelivre.org/9.0/

PostgreSQL dans les média

• Planet PostgreSQL:
  http://www.planetpostgresql.org/
• General Bits, Archives et ses manchettes occasionnelles :
  http://www.varlena.com/GeneralBits/

Postgres Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter et Robert Treat. La traduction française est effectuée par l'équipe PostgreSQLFr.

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.

Correctifs appliqués

Michael Meskes a commité :

• In ecpg, set valid return values even in case of an error to prevent segfaults.
• In ecpg, re-enabled variables in fetch/move command.

Alvaro Herrera a commité :

• In pgsql/src/backend/postmaster/autovacuum.c, mark autovacuum entries in pg_stat_activity so that they can be easily distinguished from user-invoked commands. Per suggestion from Tom Lane.
• In pgsql/src/backend/postmaster/autovacuum.c, backpatch my fix of rev 1.48 to avoid a division-by-zero error in the cost-limit vacuum code. Per trouble report from Joshua Drake.

Tom Lane a commité :

• Fix an ancient oversight in libpq's handling of V3-protocol COPY OUT mode: we need to be able to swallow NOTICE messages, and potentially also ParameterStatus messages (although the latter would be a bit weird), without exiting COPY OUT state. Fix it, and adjust the protocol documentation to emphasize the need for this. Per off-list report from Alexander Galler.
• In pgsql/src/backend/utils/misc/guc.c, avoid cluttering the postmaster log with bogus complaints during transaction abort, per my note from a couple days ago.
• In pgsql/src/bin/pg_dump/pg_backup_archiver.c, prevent pg_dump from dumping the comment (if any) on the 'public' schema. This is to avoid uselessly requiring superuser permissions to restore the dump without errors. Pretty grotty, but no better alternative seems available, at least not in the near term.
• In pgsql/doc/src/sgml/errcodes.sgml, somebody forgot to add the "NOT AN XML DOCUMENT" ERRCODE everywhere it should go ...
• In pgsql/src/backend/tsearch/wparser.c, tweak new error message to conform to style guidelines.
• Revise memory management for libxml calls. Instead of keeping libxml's data in whichever context happens to be current during a call of an xml.c function, use a dedicated context that will not go away until we explicitly delete it (which we do at transaction end or subtransaction abort). This makes recovery after an error much simpler --- we don't have to individually delete the data structures created by libxml. Also, we need to initialize and cleanup libxml only once per transaction (if there's no error) instead of once per function call, so it should be a bit faster. We'll need to keep an eye out for intra-transaction memory leaks, though. Alvaro and Tom.
• In pgsql/src/backend/commands/cluster.c, prevent CLUSTER from decreasing a relation's relfrozenxid. Bug introduced in rewrite to make CLUSTER MVCC-safe.
• Be less wishy-washy in the documentation and comments about whether a ParameterStatus message can be sent during COPY OUT: it's definitely possible, since COPY from a SELECT subquery can trigger any user-defined function.
• - In pgsql/contrib/start-scripts/osx/PostgreSQL?,">http://example.com/new.php?page=PostgreSQL">?, remove inappropriate cd commands, per David Wheeler. Also make the PATH responsive to
• the installation prefix, which was the apparent intent of the previous edit, but not well executed.
• Fix ALTER INDEX RENAME so that if the index belongs to a unique or primary key constraint, the constraint is renamed as well. This avoids inconsistent situations that could confuse pg_dump (not to mention humans). We might at some point provide ALTER TABLE RENAME CONSTRAINT as a more general solution, but there seems no reason not to allow doing it this way too. Per bug #3854 and related discussions.
• Fix pgsql/src/backend/optimizer/plan/subselect.c to avoid assuming that a SubLink's testexpr references each subquery output column exactly once left-to-right. Although this is the case in the original parser output, it might not be so after rewriting and constant-folding, as illustrated by bug #3882 from Jan Mate. Instead scan the subquery's target list to obtain needed per-column information; this is duplicative of what the parser did, but only a couple dozen lines need be copied, and we can clean up a couple of notational uglinesses. Bug was introduced in 8.2 as part of revision of SubLink representation.
• Insert into getCopyDataMessage() the same logic that already existed in the main code path for enlarging libpq's input buffer in one swoop when needing to read a long data message. Without this, the code will double the buffer size, read more data, notice it still hasn't got the whole message, and repeat till it finally has a large enough buffer. Which wastes a lot of data-moving effort and also memory (since malloc probably can't do anything very useful with the freed-up smaller buffers). Not sure why this wasn't there already; certainly the COPY data path is a place where we're quite likely to see long data messages. I'm not backpatching though, since this is just a marginal performance issue rather than a real bug.
• In pgsql/src/test/regress/pg_regress.c, make pg_regress clean out the testtablespace directory only on Windows. On other platforms it's better to let the Makefile handle it, but we want the regression tests to be invokable without make on Windows. A batch file would be a better solution, but no time for that before 8.3. Per my discovery that this breaks testing under SELinux, and subsequent discussion.

Bruce Momjian a commité :

• Add to TODO: "Add the ability to automatically create materialized views. Right now materialized views require the user to create triggers on the main table to keep the summary table current. SQL syntax should be able to manager the triggers and summary table automatically. A more sophisticated implementation would automatically retrieve from the summary table when the main table is referenced, if possible."
• In FAQ, most recent Postgres version is 8.2.6, per report from Robert Treat.
• Improve usage message for pgindent.
• Update Japanese FAQ. Jun Kuwamura.
• Stamp release for 8.3RC2; configure will be stamped by packager.

Teodor Sigaev a commité :

• In pgsql/src/backend/tsearch/wparser.c, add check of headline method presence. Per report by Yoshiyuki Asaba.
• In pgsql/src/backend/tsearch/spell.c, fix core dump with buffer-overrun from too-long infinitive. Add checking of using fixed length arrays to prevent array's overrun. Per report by Hannes Dorbath and comments by Tom Lane.

Andrew Dunstan a commité :

• Document the fact that COPY always uses the client encoding.

Magnus Hagander a commité :

• In pgsql/doc/src/sgml/pgcrypto.sgml, typo fix per Erik Rijkers.
• Marko Kreen's updates to pgsql/doc/src/sgml/pgcrypto.sgml which touch on SHA1, SHA224, SHA256, SHA384 and SHA512 encryption and change references to RFC 2440 to RFC 4880.

Marc Fournier a commité :

• must commit after autoconf ... and yes, I used the right autoconf

Correctifs rejetés (à ce jour)

Pas de déception cette semaine !

Correctifs en attente

• Tom Lane sent in a revision of Alvaro Herrera's XML memory allocation patch.