Nouvelles hebdomadaires de PostgreSQL - 7 juin 2009

L'appel aux conférenciers est lancé pour la "PGCon Brazil" ! http://pgcon.postgresql.org.br/2009/chamadas.en.php

L'ITPUG sera à la Conférence Italienne pour le Logiciel Libre qui se tiendra à Bologne les 12 & 13 juin. Gabriele Bartolini sera présente, "Étudiants et open-source : le cas PostgreSQL", samedi 13 juin à 10h35 : http://www.confsl.org/

Les nouveautés des produits dérivés

• pgtheme, un thème développé spécialement pour Drupal 6.x, est disponible : http://drupal.org/project/pgtheme

La fonctionnalité 8.4 de la semaine

quote_nullable: similaire à quote_literal, mais retourne la chaîne "NULL" lorsque l'argument fourni est NULL.

L'astuce de la semaine

Le module 'ltree' des "contribs" est une implémentation des arborescences indexées et peut s'avérer utile pour représenter un système de fichier ou une hiérarchie similaire dans votre base.

(lien vers l'article original)

PostgreSQL Local

• Notez la date : pgDay San Jose, dimanche 19 juillet juste avant l'OSCON. Appel à conférenciers, plus d'infos sous peu !
• La "PGCon Brazil" prendra place à l'Unicamp de Campinas (État de São Paulo) les 23 & 24 octobre 2009.
• Le PGDay.EU 2009 est programmé pour les 6 & 7 novembre 2009 à Telecom ParisTech (ndt: ENST ?) : http://www.pgday.eu/
• Vos propositions de conférences sont attendues pour le 10^ème anniversaire du JPUG. Le rassemblement aura lieu les 20 & 21 novembre 2009 à Tokyo, Japan : http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

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 et Josh Berkus. La traduction en est assuré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

Tom Lane a commité :

• Fix DecodeInterval to report an error for multiple occurrences of DAY, WEEK, YEAR, DECADE, CENTURY, or MILLENIUM fields, just as it always has done for other types of fields. The previous behavior seems to have been a hack to avoid defining bit-positions for all these field types in DTK_M() masks, rather than something that was really considered to be desired behavior. But there is room in the masks for these, and we really need to tighten up at least the behavior of DAY and YEAR fields to avoid unexpected behavior associated with the 8.4 changes to interpret ambiguous fields based on the interval qualifier (typmod) value. Per my example and proposed patch.
• Change AdjustIntervalForTypmod to not discard higher-order field values on the grounds that they don't fit into the specified interval qualifier (typmod). This behavior, while of long standing, is clearly wrong per spec --- for example the value INTERVAL '999' SECOND means 999 seconds and should not be reduced to less than 60 seconds. In some cases there could be grounds to raise an error if higher-order field values are not given as zero; for example '1 year 1 month'::INTERVAL MONTH should arguably be taken as an error rather than equivalent to 13 months. However our internal representation doesn't allow us to do that in a fashion that would consistently reject all and only the cases that a strict reading of the spec would suggest. Also, seeing that for example INTERVAL '13' MONTH will print out as '1 year 1 mon', we have to be careful not to create a situation where valid data will fail to dump and reload. The present patch therefore takes the attitude of not throwing an error in any such case. We might want to revisit that in future but it would take more redesign than seems prudent in late beta. Per a complaint from Sebastien Flaesch and subsequent discussion. While at other times we might have just postponed such an issue to the next development cycle, 8.4 already has changed the parsing of interval literals quite a bit in an effort to accept all spec-compliant cases correctly. This seems like a change that should be part of that rather than coming along later.
• In pgsql/doc/src/sgml/config.sgml, Remove the old advice to keep from_collapse_limit less than geqo_threshold, instead just pointing out that a larger value may trigger use of GEQO. Per Robert Haas. In passing, do a bit of wordsmithing on the Genetic Query Optimizer section.
• In pgsql/src/backend/commands/copy.c, improve comment about 'if (1)' hack in copy.c macros.
• In pgsql/src/bin/initdb/initdb.c, change rather bizarre code ordering in get_id(). This isn't strictly cosmetic --- I'm wondering if geteuid could have side effects on errno, thus possibly resulting in a misleading error message after failure of getpwuid.
• In pgsql/src/backend/tsearch/ts_selfuncs.c, fix tsquerysel() to not fail on an empty TSQuery. Per report from Tatsuo Ishii.
• Clean up ecpg's use of mmerror(): const-ify the format argument, add an __attribute__() marker so that gcc can validate the format string against the actual arguments, get rid of overcomplicated and unsafe usage in base_yyerror().
• Improve the recently-added support for properly pluralized error messages by extending the ereport() API to cater for pluralization directly. This is better than the original method of calling ngettext outside the elog.c code because (1) it avoids double translation, which wastes cycles and in the worst case could give a wrong result; and (2) it avoids having to use a different coding method in PL code than in the core backend. The client-side uses of ngettext are not touched since neither of these concerns is very pressing in the client environment. Per my proposal of yesterday.
• Remove a couple of debugging messages that have been #ifdef'd out for ages. Seems silly to ask translators to expend work on these, especially in pluralized variants.
• Trivial code style cleanup around a couple of ngettext calls.
• GIN's ItemPointerIsMin, ItemPointerIsMax, and ItemPointerIsLossyPage macros should use GinItemPointerGetBlockNumber/ GinItemPointerGetOffsetNumber, not ItemPointerGetBlockNumber/ ItemPointerGetOffsetNumber, because the latter will Assert() on ip_posid == 0, ie a "Min" pointer. (Thus, ItemPointerIsMin has never worked at all, but it seems unused at present.) I'm not certain that the case can occur in normal functioning, but it's blowing up on me while investigating Tatsuo-san's data corruption problem. In any case it seems like a problem waiting to bite someone. Back-patch just in case this really is a problem for somebody in the field.
• Fix a serious bug introduced into GIN in 8.4: now that MergeItemPointers() is supposed to remove duplicate heap TIDs, we have to be sure to reduce the tuple size and posting-item count accordingly in addItemPointersToTuple(). Failing to do so resulted in the effective injection of garbage TIDs into the index contents, ie, whatever happened to be in the memory palloc'd for the new tuple. I'm not sure that this fully explains the index corruption reported by Tatsuo Ishii, but the test case I'm using no longer fails.
• In pgsql/src/pl/plperl/plperl.c, move variable declaration to avoid 'unused variable' warning when the ifdef doesn't trigger. Not worth back-patching. Per buildfarm reports.
• Improve the IndexVacuumInfo/IndexBulkDeleteResult API to allow somewhat sane behavior in cases where we don't know the heap tuple count accurately; in particular partial vacuum, but this also makes the API a bit more useful for ANALYZE. This patch adds "estimated_count" flags to both structs so that an approximate count can be flagged as such, and adjusts the logic so that approximate counts are not used for updating pg_class.reltuples. This fixes my previous complaint that VACUUM was putting ridiculous values into pg_class.reltuples for indexes. The actual impact of that bug is limited, because the planner only pays attention to reltuples for an index if the index is partial; which probably explains why beta testers hadn't noticed a degradation in plan quality from it. But it needs to be fixed. The whole thing is a bit messy and should be redesigned in future, because reltuples now has the potential to drift quite far away from reality when a long period elapses with no non-partial vacuums. But this is as good as it's going to get for 8.4.
• Revert my patch of 2009-04-04 that removed contrib/intarray's definitions of the <@ and @> operators. These are not in fact equivalent to the built-in anyarray operators of the same names, because they have different behavior for empty arrays, namely they don't think empty arrays are contained in anything. That is mathematically wrong, no doubt, but until we can persuade GIN indexes to implement the mathematical definition we should probably not change this. Another reason for not changing it now is that we can't yet ensure the opclasses will be updated correctly in a dump-and-reload upgrade. Per recent discussions.

Joe Conway a commité :

• In pgsql/contrib/dblink/dblink.c, fix dblink_get_result() as reported by Oleksiy Shchukin. Refactor a bit while we're at it per request by Tom Lane. Specifically, don't try to perform dblink_send_query() via dblink_record_internal() -- it was inappropriate and ugly.
• Add support for using SQL/MED compliant FOREIGN DATA WRAPPER, SERVER, and USER MAPPING as method to supply dblink connect parameters. Per mailing list and PGCon discussions.

Heikki Linnakangas a commité :

• In pgsql/src/backend/access/transam/xlog.c, only recycle normal files in pg_xlog as WAL segments. pg_standby creates symbolic links with the -l option, and as Fujii Masao pointed out we ended up overwriting files in the archive directory before this patch. Patch by Aidan Van Dyk, Fujii Masao and me.

Bruce Momjian a commité :

• In pgsql/doc/src/sgml/config.sgml, add example of how to generate the session identifier from pg_stat_activity.
• In pgsql/src/backend/commands/copy.c, add comment about why "((void) 0)" is used in copy macros.
• Wording improvement for recent sesssion identifier SQL query.
• In pgsql/doc/src/sgml/config.sgml, wording improvement for recent sesssion identifier SQL query.
• In pgsql/doc/src/sgml/backup.sgml, remove sleep() from backup script example; not needed anymore. Fujii Masao.

Andrew Dunstan a commité :

• Initialise perl library as documented in perl API. Backpatch to release 7.4.
• Search for versioned perl library instead of using hardcoded name on Windows. Backpatch to release 8.3
• Adjust recent PERL_SYS_INIT3 call to avoid platforms where it might fail, and to remove compilation warning. Backpatch the release 7.4.

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente