Nouvelles hebdomadaires de PostgreSQL - 6 février 2011
Entretien de Simon Riggs dans O'Reilly GMT :
http://www.oreillygmt.eu/open-sourcefree-software/all-about-postgresql-%E2%80%93-the-world%E2%80%99s-most-advanced-open-source-database/
Les nouveautés des produits dérivés
Offres d'emplois autour de PostgreSQL en février
PostgreSQL Local
- Selena Deckelmann parlera de la communauté et du développement PostgreSQL le 7 février 2010 à 16h, à l'université d'état de l'Oregon à Corvallis.
- L'appel à conférenciers pour l'annuel "Prague PostgreSQL Developers' Day", 4ème édition, est lancé. L'événement sera tenu le 10 février 2011 à l'Universitas Carolinas :
http://www.p2d2.cz
- Le PUG de New-York se réunira le 15 février 2011 à 18h15 dans les bureaux de Yodle, au 50 de la 23ème rue Ouest à New-York. Plus d'infos et RSVP :
http://www.meetup.com/postgresql-3/events/16123790/
- Le PGDay.US est au programme du Southern California Linux Exposition (SCALE) de cette année, tenu à l'hôtel LAX Hilton de Los Angeles (Californie) le vendredi 25 février 2011.
- PostgreSQL Conference East 2011 : New-York City, du 22 au 25 mars :
http://www.postgresqlconference.org
- L'Open Database Camp aura lieu du 7 au 9 mai 2011 en Sardaigne (Italie) :
http://datacharmer.blogspot.com/2011/01/announcing-open-database-camp-sardinia.html
- PGCon aura lieu les 19 & 20 mai 2011 à l'Université d'Ottawa, précédé par deux jours de tutoriels les 17 & 18 mai . L'appel à conférenciers a été lancé !
http://www.pgcon.org/2011/
PostgreSQL dans les média
PostgreSQL Weekly News / les nouvelles hebdomadaires vous sont offertes cette semaine par David Fetter. Traduction par l'équipe PostgreSQLFr sous licence CC BY-NC-SA.
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 et en espagnol à pwn (a) arpug.com.ar.
(lien vers l'article original)
Revues de code
Correctifs appliqués
Heikki Linnakangas a poussé :
Bruce Momjian a poussé :
- Move upgrade instructions into its own section under "Server Setup and Operation", merged from upgrade sections in "Installation from Source Code" and "Backup and Restore". This now gives a single place for all upgrade information.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c5ba11f8fb1701441b96a755ea410b96bfe36170
- Fix SGML markup for upgrade doc addition.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ff20fbd6c21929cd5c78f154c8364ce746de9c03
- Update pg_upgrade docs to mention its use in a less risk-warning way, and update the pg_upgrade docs to mention its reliance on no changes to the storage format (the later based on Robert Haas's patch).
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=49450f01eca39308989cf668f60b7c345e72fc7b
- Fix pg_upgrade to create pg_authid restore functions in the 'postgres' database, not in the os-user database, per report from Magnus.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6238473adb119a5a11061e40e159e8c5187fe492
- In pg_authid.rolpassword docs, make "md5" appear as a literal.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2dbed56c5a86d45a66f41e6a8a16295bbfe46646
- Improve docs for pg_authid encryption description with better markup and a mention of unencrypted passwords.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=00dd340210ed67900e03703eb088fdd5ab12c099
- Add pg_upgrade comment for why we can't use template1 inheritance for the support functions.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2bb87a61a84ab74b7ba820aac787443a78897bf4
- Add missing period "." in pg_upgrade documentation.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d2888d1ca36c266900eeea95401269c782074251
- Clarify pg_upgrade install instructions, per suggestion from Robert Haas.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=902aae5ec58f71b8d9f7efb5ed474d0f5439439d
- Document that Slony can do upgrades easier _because_ it supports replication between different Postgres major versions.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e8cdc238cfa3fda4185fe6a9826dbdf0a107f789
- Document that effective cache size does not assume data remains in the cache between queries.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c6e6f7fd3ffa984a202b910ef3237e26f9d3c2e
- Clarify documentation to state that "zero_damaged_pages" does not force data to disk, so the table or index should be recreated before the parameter is turned off again.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7106f74e2a6feb31c022dd98e7d93ab656dc079d
- Properly capitalize hyphenated words in documentation titles.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d56d246e70184692408cd6a444e6824ae8491587
- Document that CREATE VIEW that uses "*" for the column list will not auto-add columns later added to the base table.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5a6ba62be5364dbf973fd9b8631fd60acda03440
- Simplify pg_upgrade checking of executable permissions.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9d220fc17eafcbc99fcea7bdbbb246fee473eac7
- Fix wrong verb in pg_upgrade text message, per Robert Haas.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2b6e2dee7805ec5b477af00c01c54c208bf106eb
- Mark all GUC variables with <varname> markup, rather than <literal>.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03c25dd900d97c0868ad20b925a78d41ec603578
- Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is a path variable, not a directory path.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=bffb638d16999ee7d3c8796e77dd87ac82719c7d
- Rename function to first_path_var_separator() to clarify it works with path variables, not directory paths.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=426227850be145b52cb610455000fc005df5ce4e
- Simplify code used in is_absolute_path() macro; also add comment about 'E:abc' Win32 path handling.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=35b0a6b205c25d592b966aa17d3c6f9e5a88eb62
- In docs, PL is Procedural Language, not Programming Language. Satoshi Nagayasu.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=df63aac678343cec522bc58588b70ab1374a6c93
- ALTER TABLE sometimes takes only ShareUpdateExclusiveLock. Along the way, be more consistent about the wording we use here.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7212c77d0cabcc468fec0b9cd7f2413b64b77050
- In docs, move PQrequestCancel() deprecation mention up to match other libpq doc mentions.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b157a1d5554d6dfbd13fb605f08d51ce17532375
- Add doc comment that installation.sgml can't use xrefs.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8e6ae3d79c16ad8876c34f2cff8d667ca1cffb09
- Add C comment about why older compilers complain about basebackup.c's longjump.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51dbc87dff5c32bfe627ec7b22c575c263de8251
- Rename macro DECIMAL to DECIMAL_T to help pgindent; this is already done for a few other macros in that file, for other reasons. I also remove pgindent/README mention of the file.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=97116ca4170b974d734cea364789c389b30e6ce1
- Adjust libpq docs to be clearer about 'hostaddr' usage by rewording and using an itemized list.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5ed45ac09c604555740e7365a722b641f3bce498
Andrew Dunstan a poussé :
Simon Riggs a poussé :
Tom Lane a poussé :
ITAGAKI Takahiro a poussé :
Magnus Hagander a poussé :
Peter Eisentraut a poussé :
Robert Haas a poussé :
- Log restartpoints in the same fashion as checkpoints. Prior to 9.0, restartpoints never created, deleted, or recycled WAL files, but now they can. This code makes log_checkpoints treat checkpoints and restartpoints symmetrically. It also adjusts up the documentation of the parameter to mention restartpoints. Fujii Masao. Docs by me, as suggested by Itagaki Takahiro.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0af695fd43b6889613a4035e3cdfcc0fc1b7936a
- Various sepgsql corrections. KaiGai Kohei
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c7689ee73346d198177dee538501bb1148c8cebb
- Minor sepgsql regression test fixes.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=87d967f70f4866c17404f6a9b8062f892ed31e08
- sepgsql doc fix. KaiGai Kohei
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4ff9dec1386b714f6c26a52ca6880b14e94dd1db
- Further sepgsql documentation cleanup.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4c4daf671074cc64290e9255c14365b55bf7a47b
- Avoid maintaining three separate copies of the error codes list. src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a big chunk of errcodes.sgml are now automatically generated from a single file, src/backend/utils/errcodes.txt. Jan Urbański, reviewed by Tom Lane.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ddfe26f6441c24660595c5efe5fd0bd3974cdc5c
- Preserve copyright notice from old errcodes.h file.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b8a0467e10a41d32ecf889d40de81223e0439c5b
- Unbreak the VPATH build. My commit ddfe26f6441c24660595c5efe5fd0bd3974cdc5c of 2010-02-03 broke it. Per buildfarm.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=dde9684d65ed66656f765d3fd97f2e522a189132
- Unbreak 'configure' followed immediately by 'make install'. More fallout from ddfe26f6441c24660595c5efe5fd0bd3974cdc5c. Report by Fujii Masao.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b87811ee273360c45d92b0e7bb7e67670312c221
- Make handling of errcodes.h more consistent with other generated headers. This fixes make distprep, and seems more robust in other ways as well. Some special handling is required because errcodes.txt is needed by some stuff in src/port, but just by src/backend as is the case for the other generated headers. While I'm at it, fix a few other things that were overlooked in the original patch.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=356f2cbbb42811596820c94aaec2e32ad1ec58d8
- Use $(MAKE) rather than make. Per buildfarm.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6f59a5e5dd73ec2c448dd7038accf5aaba6dc04b
- Update ALTER TABLE docs to mention using VACUUM FULL for rewrites. Remove the claim that ALTER TABLE .. SET DATA TYPE is the fastest way of rewriting a table, since it no longer is. Noah Misch and Robert Haas, based on a suggestion from Tom Lane.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=edad08ba545b43261b4d54d65122b45c9b5ee801
- Avoid including postgres.h in frontend compiles of src/port. This isn't kosher, and doesn't play nicely with my recent changes to the Makefile in this directory.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8201aea90c2b171808c65836fcce4f29b22a9dbb
- Move pipe.c into the backend. It's full of backend-specific error reporting, so it's neither possible nor necessary for this to be used from frontend code.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b1e65c32168a2b64276a57be8c4dc5a63d33e12d
- Clarify comment in ATRewriteTable(). Make sure it's clear that the prohibition on adding a column with a default when the rowtype is used elsewhere is intentional, and be a bit more explicit about the other cases where we perform this check.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9e7e1172a53054dc14574e42865ea8213bc06371
- Tighten ALTER FOREIGN TABLE .. SET DATA TYPE checks. If the foreign table's rowtype is being used as the type of a column in another table, we can't just up and change its data type. This was already checked for composite types and ordinary tables, but we previously failed to enforce it for foreign tables.
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=65377e0b9c0e0397b1598b38b6a7fb8b6f740d39
Correctifs rejetés (à ce jour)
- Pas de déception cette semaine :-)
Correctifs en attente
- Greg Smith sent in another revision of the patch to do spread checkpoint syncs.
- Marko (johto) Tiikkaja sent in another revision of the patch to add transaction-scoped advisory locks.
- Joachim Wieland sent in another revision of that patch to do parallel pg_dump using a new directory-based format.
- Simon Riggs sent in a patch to add a FORCE option to DROP DATABASE.
- ITAGAKI Takahiro sent in another revision of the patch to add MULTISETs.
- Fujii Masao sent in a patch to change pg_stop_backup so that it only creates the backup history file if archiving is enabled.
- Alexey Klyukin sent in another revision of the patch to transform between PostgreSQL arrays and Perl arrays in PL/Perl.
- Hitoshi Harada sent in three more revisions of the patch to add ENCODING to COPY.
- Euler Taveira de Oliveira sent in another revision of the patch to add named restore points.
- Peter Eisentraut sent in another revision of the patch to add per-column collations.
- ITAGAKI Takahiro and Dimitri Fontaine traded patches to add support for EXTENSIONs to pg_dump.
- Kevin Grittner sent in another revision of the patch to add SSI (serializable snapshot isolation).
- Heikki Linnakangas sent in a patch to add regression tests for SSI.
- YAMAMOTO Takahashi sent in another revision of the patch to avoid de-TOAST'ing large objects.
- Andrew Dunstan sent in a patch to the docs to describe how to build PostgreSQL for Win64 using certain toolkits.
- Dimitri Fontaine sent in another revision of the ALTER EXTENSION patch.
- Tomas Vondra and Greg Smith traded patches to keep the timestamp of the latest stats reset.
- Magnus Hagander sent in three revisions of a patch to move the WAL warning.
- Bruce Momjian sent in a patch to simplifiy the pg_upgrade executable checks per suggestion from Robert Haas.
- Robert Haas sent in another revision of the patch to limit hint bit I/O.
- Bruce Momjian sent in two more revisions of the patch to fix is_absolute_path on Windows.
- ITAGAKI Takahiro sent in a patch to implement a jagged row CSV API, to be applied atop Andrew Dunstan's patch to expose the COPY API.
- Thom Brown sent in a patch to fix an issue where generate_series() misbehaved by returning if the series hits either the upper or lower boundary during increment, or goes beyond it, none of which should happen.
- Jan Urbanski sent in another flock of patches to improve PL/Python.
- Robert Haas sent in another revision of the patch to skip table rewrites in cases where it can be proven that this will not actually change anything when someone issues an ALTER TABLE.
- Alex Hunsaker sent in another revision of the patch to convert between PostgreSQL arrays an Perl arrays in PL/Perl.
- Stephen Frost sent in another revision of the patch to allow logging the current role.
- Jeff Davis sent in another revision of the patch to add range types.
- Simon Riggs sent in a patch to fix commit performance in SAVEPOINTs, which had O(n2) behavior.
- Bruce Momjian sent in a doc patch for Streaming Replication.