Nouvelles hebdomadaires de PostgreSQL - 1er février 2009
Des corrections de bugs seront bientôt disponibles pour les séries 8.3, 8.2, 8.1, 8.0 et 7.4. Préparez-vous à mettre à jour !
Greg Smith a publié la version 0.90 de pgtune sur pgfoundry :
http://pgfoundry.org/projects/pgtune/
L'association des utilisateurs bulgares de PostgreSQL se réuniront le 12 février 2009 à 19h au Vinarnata, 19 rue Lavele à Sofia :
http://www.doodle.com/participation.html?pollId=vb788q7v8ybi4z39
(lien vers l'article original)
Les nouveautés des produits dérivés
L'astuce de la semaine
Besoin d'unicité sur seulement une partie d'une table, comme par exemple les noms des utilisateurs actifs ? Utilisez un index partiel d'unicité : CREATE UNIQUE INDEX ON logins ( username ) WHERE active = true;
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.