Nouvelles hebdomadaires de PostgreSQL - 19 avril 2009

PostgreSQL 8.4 beta 1 est disponible. À vos tests ! http://www.postgresql.org/developer/beta

La vidéo "PostgreSQL in the Cloud" est disponible. Merci à Christophe Pettus pour le cadrage et Dirk Jagdmann pour le streaming en direct pendant l'événement : http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov http://www.vimeo.com/4144396

Les nouveautés des produits dérivés

• Archiveopteryx 3.1.1, un gestionnaire d'e-mail basé sur PostgreSQL : http://www.archiveopteryx.org/3.1.1
• Benetl 2.7, un ETL pour fichiers utilisant PostgreSQL : http://www.benetl.net
• DBD::Pg 2.13.0, un connecteur Perl pour PostgreSQL : http://search.cpan.org/dist/DBD-Pg/

La fonctionnalité 8.4 de la semaine

Réglage de la FSM : vous étiez fan des configurations max_fsm_relations et max_fsm_pages dans le GUC ? Tant pis pour vous, ça ne se fait plus. Grâce à Heikki Linnakangas, la FSM [ndt: Free Space Map] est stockée sur disque, sans limitation.

L'astuce de la semaine

Postgresql répond au standard SQL INFORMATION_SCHEMA, qui contient des informations sur les tables, vues, colonnes et contraintes dans un format tabulaire normalisé et que l'on retrouve chez Oracle, DB2 et MySQL. Tout cela est disponible dans le schéma interne "information_schema".

(lien vers l'article original)

Offres d'emplois autour de PostgreSQL en avril

• http://archives.postgresql.org/pgsql-jobs/2009-04/threads.php

PostgreSQL Local

• Le PgDay de Florianopolis aura lieu le 22 mai. Contactez Dickson S. Guedes (guedes AROBASE guedesoft DOT net) pour participer ou proposer une conférence : http://www.postgresql.org.br/eventos/pgday/sc
• La "Percona Performance Conference" prendra place au "Santa Clara Convention Center", Santa Clara, Californie : http://conferences.percona.com/
• L'appel aux conférences est lancé pour le PgDay de São Paulo, programmé le 24 avril. Contactez [marins (point) consultoria (a) gmail (point) com] ou [marcelojscosta (a) gmail (point) com] pour participer.
• "PostgreSQL Conference, U.S. (JDCon)" organise un PgDay lors de la "LinuxFest Northwest" (25 & 26 avril). L'appel aux conférences est consultable à l'adresse : http://www.postgresqlconference.org/
• Il y aura également des PgDays les 29 et 30 avril, respectivement à Porto Velho (RO) et Ji-Parana (RO). Contactez Luis Fernando Bueno : [proflfbueno (a) gmail (point) com] pour participer.
• Michael Renner animera un atelier sur la réplication PostgreSQL lors des "Netways OSDC", les 29 et 30 avril 2009, à Nuremberg (All.) : http://www.netways.de/english/osdc/y2009/programm/w/michael_renner_postgresql_repliziert_ein_ueberblick/
• La PGCon 2009 se tiendra à l'Université d'Ottawa les 21 et 22 mai 2009. Elle sera précédée de deux jours de tutoriels les 19 & 20 mai : http://www.pgcon.org/2009/
• 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.

PostgreSQL dans les média

• Planet PostgreSQL : http://planet.postgresql.org/

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é :

• In pgsql/doc/src/sgml/release.sgml, make a copy-editing pass over the 8.4 release notes.
• In pgsql/doc/src/sgml/textsearch.sgml, do some copy-editing on description of ts_headline().
• In pgsql/src/backend/parser/scan.l, fix broken {xufailed} production that made HEAD fail on select u&42 from table-with-a-u-column; Also fix missing SET_YYLLOC() in the {dolqfailed} production that I suppose this was based on. The latter is a pre-existing bug, but the only effect is to misplace the error cursor by one token, so probably not worth backpatching.
• Fix planner to restore its previous level of intelligence about pushing constants through full joins, as in SELECT * FROM tenk1 a FULL JOIN tenk1 b USING (unique1) WHERE unique1 = 42; which should generate a fairly cheap plan where we apply the constraint unique1 = 42 in each relation scan. This had been broken by my patch of 2008-06-27, which is now reverted in favor of a more invasive but hopefully less incorrect approach. That patch was meant to prevent incorrect extraction of OR'd indexclauses from OR conditions above an outer join. To do that correctly we need more information than the outerjoin_delay flag can provide, so add a nullable_relids field to RestrictInfo that records exactly which relations are nulled by outer joins that are underneath a particular qual clause. A side benefit is that we can make the test in create_or_index_quals more specific: it is now smart enough to extract an OR'd indexclause into the outer side of an outer join, even though it must not do so in the inner side. The old coding couldn't distinguish these cases so it could not do either.
• In pgsql/src/backend/optimizer/path/costsize.c, bump disable_cost up from 1e8 to 1e10, per gripe from Kris Jurka.
• Revise plpgsql's scanner to process comments and string literals in a way more nearly matching the core SQL scanner. The user-visible effects are: 1. Block comments (slash-star comments) now nest, as per SQL spec. 2. In standard_conforming_strings mode, backslash as the last character of a non-E string literal is now correctly taken as an ordinary character; formerly it was misinterpreted as escaping the ending quote. (Since the string also had to pass through the core scanner, this invariably led to syntax errors.) 3. Formerly, backslashes in the format string of RAISE were always treated as quoting the next character, regardless of mode. Now, they are ordinary characters with standard_conforming_strings on, while with it off, they introduce the same set of escapes as in the core SQL scanner. Also, escape_string_warning is now effective for RAISE format strings. These changes make RAISE format strings work just like any other string literal. This is implemented by copying and pasting a lot of logic from the core scanner. It would be a good idea to look into getting rid of plpgsql's scanner entirely in favor of using the core scanner. However, that involves more change than I can justify making during beta --- in particular, the core scanner would have to become re-entrant. In passing, remove the kluge that made the plpgsql scanner emit T_FUNCTION or T_TRIGGER as a made-up first token. That presumably had some value once upon a time, but now it's just useless complication for both the scanner and the grammar.
• Fix estimate_num_groups() to not fail on PlaceHolderVars, per report from Stefan Kaltenbrunner. The most reasonable behavior (at least for the near term) seems to be to ignore the PlaceHolderVar and examine its argument instead. In support of this, change the API of pull_var_clause() to allow callers to request recursion into PlaceHolderVars. Currently estimate_num_groups() is the only customer for that behavior, but where there's one there may be others.
• In pgsql/doc/src/sgml/textsearch.sgml, fix textsearch documentation examples to not recommend concatenating separate fields without putting a space between. Per gripe from Rick Schumeyer.
• Fix de-escaping checks so that we will reject \000 as well as other invalidly encoded sequences. Per discussion of a couple of days ago.
• Rethink the idea of having plpgsql depend on parser/gram.h. Aside from the fact that this is breaking the MSVC build, it's probably not really a good idea to expand the dependencies of gram.h any further than the core parser; for instance the value of SCONST might depend on which bison version you'd built with. Better to expose an additional call point in parser.c, so move what I had put into pl_funcs.c into parser.c. Also PGDLLIMPORT'ify the reference to standard_conforming_strings, per buildfarm results.
• Assorted portability fixes for Borland C, from Pavel Golub.

Alvaro Herrera a commité :

• In pgsql/src/bin/pg_dump/pg_restore.c, make new strings more alike previously existing messages.
• In pgsql/src/bin/pg_dump/pg_restore.c, pg_restore -jN does not equate "multiple jobs", so partly revert the previous patch. Per note from Tom Lane.
• In pgsql/src/backend/commands/dbcommands.c, add missing periods.
• In pgsql/src/backend/libpq/hba.c, add missing gettext calls around some strings. Also remove quotes around the %s that they expand to, per comment from Tom Lane.
• In pgsql/src/backend/utils/adt/arrayfuncs.c, substitute extraneous underscores with spaces.
• In pgsql/src/test/regress/expected/arrays.out, fix the regression test error message for array_fill, too. Per note from Andrew Dunstan.

Bruce Momjian a commité :

• In pgsql/src/interfaces/libpq/fe-secure.c, add libpq error message text on how to handle missing root.crt file.
• In pgsql/doc/src/sgml/libpq.sgml, reformat 'sslmode' options into an SGML table; improve wording.
• In pgsql/doc/src/sgml/libpq.sgml, fix SGML markup I broke yesterday.
• Remove mention of pre-7.1 inheritance behavior from /ref pages; keep mentions in main documentation.
• In pgsql/doc/src/sgml/release.sgml, add Ron Mayer as primary contributor for, "support the IS0 8601 interval syntax" based on private email from Ron.

Magnus Hagander a commité :

• In pgsql/contrib/pgcrypto/crypt-md5.c, remove beer-ware license from crypt-md5.c, per approval from Poul-Henning Kamp. This makes the file the same standard 2-clause BSD as the rest of PostgreSQL.

Correctifs rejetés (à ce jour)

• KaiGai Kohei's patch to separate the ACL for SELECT ... FOR UPDATE from UPDATE. Not needed.

Correctifs en attente

• Abhijit Menon-Sen sent in another revision of his patch to test quoting in PL/pgSQL.
• ITAGAKI Takahiro sent in a patch to implement GetPlatformEncoding() and convert absolute file paths from database encoding to platform encoding.
• David Fetter sent in three patches to make \df describe whether a function is normal, aggregate, trigger or windowing and let people choose any or all of those to see.
• ITAGAKI Takahiro sent in a WIP patch to solve server-side encoding issues.
• Fujii Masao sent in another revision of his trigger patch for pg_standby.
• Marko Kreen sent in a patch to add \u and \U as unicode escapes.
• KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.