PostgreSQL Local

PostgreSQL dans les média

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

Peter Eisentraut a commité :

  • Message format tuning in ecpg.
  • Revert updatable views.
  • Message fix in pgsql/src/interfaces/ecpg/preproc/parse.pl
  • Translation updates.
  • In pgsql/src/interfaces/ecpg/preproc/ecpg.c, whitespace fix in message.
  • In ecpg, Make messages consistent with existing ones.

Alvaro Herrera a commité :

  • Allow extracting and parsing of reloptions from a bare pg_class tuple, and refactor the relcache code that used to do that. This allows other callers (particularly autovacuum) to do the same without necessarily having to open and lock a table.

Magnus Hagander a commité :

  • In pgsql/src/backend/utils/adt/pg_locale.c, silence compiler warnings in new win32 locale code when building on mingw. ITAGAKI Takahiro.
  • In pgsql/src/test/regress/pg_regress.c, silence compiler warning on win32. ITAGAKI Takahiro
  • In pgsql/src/bin/pg_ctl/pg_ctl.c, support running as a service on Windows 7, by not specifying the JOB_OBJECT_UILIMIT_HANDLES flag. Dave Page & Magnus Hagander
  • Go over all OpenSSL return values and make sure we compare them to the documented API value. The previous code got it right as it's implemented, but accepted too much/too little compared to the API documentation. Per comment from Zdenek Kotala.
  • In pgsql/src/test/regress/pg_regress.c, change warning-silencing code not to cast the pointer type, instead casting the value of the variable later. Per comments from Tom Lane.

Teodor Sigaev a commité :

  • In pgsql/contrib/tsearch2/tsearch2.c, fix bug with multiple evaluation of tsearch2 compatibility trigger, trigger data should be restored. Backpatch only to 8.3 because previous versions don't have such layer.
  • In pgsql/src/backend/tsearch/spell.c, fix incorrect dereferencing of char* to array's index. Per report from Tommy Gildseth.

Tom Lane a commité :

  • Replace argument-checking Asserts with regular test-and-elog checks in all encoding conversion functions. These are not can't-happen cases because it's possible to create a conversion with the wrong conversion function for the specified encoding pair. That would lead to an Assert crash in an Assert-enabled build, or incorrect conversion otherwise, neither of which is desirable. This would be a DOS issue if production databases were customarily built with asserts enabled, but fortunately that's not so. Per an observation by Heikki. Back-patch to all supported branches.
  • Update time zone data files to tzdata release 2009a: introduces Asia/Kathmandu as the preferred spelling of that zone name, corrects historical DST information for Switzerland and Cuba.
  • In pgsql/doc/src/sgml/release.sgml, update back-branch release notes.
  • Defend against null input in analyze_requires_snapshot(), per report from Rushabh Lathia. Back-patch of patch of 2009-01-08. This is necessary in 8.3, as reported by Bjorn Munch. It's not currently necessary in 8.2, AFAICS, but seems best to include it there too.
  • In pgsql/src/backend/utils/adt/arrayfuncs.c, fix unnest() to handle a toasted input array safely. Per report from Alvaro Herrera.

Heikki Linnakangas a commité :

  • Check that connection limit is within valid range. IOW, not < -1. It's missing in older versions too, but it doesn't seem worth back-porting. All negative are just harmlessly treated as "no limit", and tightening the check might even brake an application that relies on it.

Correctifs rejetés (à ce jour)

  • Pas de déception cette semaine :-)

Correctifs en attente

  • KaiGai Kohei sent in another revision of his SE-PostgreSQL patch.
  • KaiGai Kohei sent in two doc patches atop his SE-PostgreSQL patches.
  • Brendan Jurd sent in an updated patch to correct the meridiem markers.
  • Zdenek Kotala sent in another revision of his space reservation patch.
  • Fujii Masao sent in another revision of the synchronous replication patch.
  • Simon Riggs sent in a bug fix atop the Hot Standby patch.
  • Heikki Linnakangas sent in two more revisions of the Recovery Infrastructure patch.
  • Kenneth Marshall sent in another revision of the updated hash functions patch.
  • Timo Savola sent in a patch which allows people to set a sample percentage for logging.
  • Alvaro Herrera sent in two more revisions of his patch to add namespaces to reloptions.
  • Fernando Ike de Oliveira sent in a patch to add \dL, which lists languages, to psql.
  • Andrew Dunstan sent in another revision of his parallel pg_dump patch.
  • Euler Taveira de Oliveira sent in two patchs atop Alvaro Herrera's reloptions patch.
  • Hiroshi Saito sent in three revisions of a patch to generate a .def (DLL symbol export) file for the event log plugin on mingw.
  • Robert Haas sent in a patch to optimize add_path in the planner.