PostgreSQL Weekly News | Nouvelles neuves de PG

Par SAS le 15/05/2007 - 14:51

Nouvelles hebdomadaires de PostgreSQL - 13 Mai 2007

Il y a quelques discussions animées sur la
mailing list -patches.

Les nouveautés des produits dérivés

• PostgreSQL Code Factory est sortie.
  http://www.sqlmaestro.com/products/postgresql/codefactory/
• EnterpriseDB est à présent disponible sur Red Hat Exchange.
  http://www.marketwire.com/mw/release_html_b1?release_id=250943
• MediaWiki 1.10 a été publié.
  http://www.mediawiki.org/wiki/MediaWiki
• Sortie de PostgresDAC 2.3.9-beta2.
  http://microolap.com/products/connectivity/postgresdac/

Les jobs PostgreSQL en Mai

http://archives.postgresql.org/pgsql-jobs/2007-05/threads.php

PostgreSQL Local

En route pour le PgDay!
http://www.pgday.it/en/node/95

Les inscriptions sont toujours ouvertes pour les PGCon 2007
http://www.pgcon.org/2007/registration.php

PostgreSQL dans les média

• Planet PostgreSQL :

  http://www.planetpostgresql.org/

• General Bits, Archives et articles occasionnels :
  http://www.varlena.com/GeneralBits/

Les PostgreSQL Weekly News vous sont présentées cette semaine par David Fetter. Adaptation francophone de ...

Vos propositions d'informations doivent parvenir avant dimanche minuit à david@fetter.org. Les propositions en allemand peuvent être envoyées à pwn@pgug.de.

Correctifs appliqués

Magnus Hagander a commité :

• Document that CLUSTER breaks MVCC visibility rules. (Not needed in cvs head, because CLUSTER itself is fixed there). Heikki Linnakangas. Back-patched to 7.4.
• In pgsql/src/tools/msvc/Install.pm, log directory we're installing into. Per request from Andrew Dunstan.

Bruce Momjian a commité :

• Mark TODO as done: "Add support for arrays of complex types."
• Add to TODO: "Have configure choose integer datetimes by default."
• Add to TODO: "Allow data to be passed in native language formats, rather than only text.

Michael Meskes a commité :

• Added some more error logging to pgsql/src/interfaces/ecpg/ecpglib/data.c.
• Synced parser and keyword list for ECPG. Renamed update test in the hope that it will run on Vista.

Neil Conway a commité :

• Improvements to the SGML docs for TRUNCATE and CLUSTER.
• Add a hash function for "numeric". Mark the equality operator for numerics as "oprcanhash", and make the corresponding system catalog updates. As a result, hash indexes, hashed aggregation, and hash joins can now be used with the numeric type. Bump the catversion. The only tricky aspect to doing this is writing a correct hash function: it's possible for two Numerics to be equal according to their equality operator, but have different in-memory bit patterns. To cope with this, the hash function doesn't consider the Numeric's "scale" or "sign", and explictly skips any leading or trailing zeros in the Numeric's digit buffer (the current implementation should suppress any such zeros, but it seems unwise to rely upon this). See discussion on pgsql-patches for more details.

Tom Lane a commité :

• Ajout du support pour les tableaux d'éléments composites, incluant les lignes de tables régulières et de vues (mais pas des catalogues systèmes, ni des séquences ou des
  tables TOASTées).

  Se débarasser des conventions voulant que le type d'un tableau soit exactement "_type". On utilise plutôt une nouvelle colonne pg_type.typarray pour assurer le lien. (Ca sera toujours nommé "_type" pourtant, à l'exception de cas extraordinaires comme les noms de types de longueur maximale.)
  Dans la foulée, le suivi des dépendances du schéma et du propriétaire pour le types est rendu plus uniforme : un type créé par l'utilisateur a ces dépendances tandis qu'une ligne de table ou un tableau auto-produit ne l'auront pas, mais dépendront de l'objet parent. David Fetter, Andrew Dunstan, Tom Lane

• Improve predicate_refuted_by_simple_clause() to handle IS NULL and IS NOT NULL more completely. The motivation for having it understand IS NULL at all was to allow use of "foo IS NULL" as one of the subsets of a partitioning on "foo", but as reported by Aleksander Kmetec, it wasn't really getting the job done. Backpatch to 8.2 since this is arguably a performance bug.
• Fix the problem that creating a user-defined type named _foo, followed by one named foo, would work but the other ordering would not. If a user-specified type or table name collides with an existing auto-generated array name, just rename the array type out of the way by prepending more underscores. This should not create any backward-compatibility issues, since the cases in which this will happen would have failed outright in prior releases. Also fix an oversight in the arrays-of-composites patch: ALTER TABLE RENAME renamed the table's rowtype but not its array type.
• Fix my oversight in enabling domains-of-domains: ALTER DOMAIN ADD CONSTRAINT needs to check the new constraint against columns of derived domains too. Also, make it error out if the domain to be modified is used within any composite-type columns. Eventually we should support that case, but it seems a bit painful, and not suitable for a back-patch. For the moment just let the user know we can't do it. Backpatch to 8.2, which is the only released version that allows nested domains. Possibly the other part should be back-patched further.
• Support arrays of composite types, including the rowtypes of regular tables and views (but not system catalogs, nor sequences or toast tables). Get rid of the hardwired convention that a type's array type is named exactly "_type", instead using a new column pg_type.typarray to provide the linkage. (It still will be named "_type", though, except in odd corner cases such as maximum-length type names.) Along the way, make tracking of owner and schema dependencies for types more uniform: a type directly created by the user has these dependencies, while a table rowtype or auto-generated array type does not have them, but depends on its parent object instead. David Fetter, Andrew Dunstan, Tom Lane
• Reserve some pg_statistic "kind" codes for use by the ESRI ST_Geometry datatype project. Per request from Ale Raza (araza at esri.com).
• Add an explicit comment about POSIX time zone names having the reverse sign convention from everyplace else in Postgres. I don't suppose that this will stop people from being confused, but at least we can say that it's documented.

Peter Eisentraut a commité:

• The appended patch addresses the outstanding issues of the recent guc patch. It makes PGCLIENTENCODING work again and uses bsearch() instead of iterating over the array of guc variables in guc_get_index().

Alvaro Herrera a commité:

• Make sure we don't skip databases that are supposed to be vacuumed "exactly now". This can happen if the time granularity is not very high. Per ITAGAKI Takahiro.

Peter Eisentraut a commité:

• Grammar correction in pgsql/doc/src/sgml/func.sgml.

Correctifs rejetés (à ce jour)

• Pas de déception cette semaine :-)

Correctifs en attente

• Pavan Deolassee sent in a flock of patches for HOT, broken out per discussion.
• William Lawrance sent in two revisions of a patch for ECPG that makes it use PQprepare and PQexecPrepared functions to cache SQL statements.
• Tomas Doran sent in three revisions of a patch which exposes a current_query() function to SQL.
• Zoltan Boszormenyi sent in another version of his GENERATED patch.
• Gregory Stark sent in a doc patch explaining how to use packed varlenas.
• Jim Nasby a proposé un patch pour que les vacuums émettent un warning lorsqu'ils tombent à court de maintenance_work_mem.
• CK Tan sent in a patch which improves the performance of scans on big relations.
• Gregory Stark sent in another revision of his concurrent psql patch.