Skip site navigation (1) Skip section navigation (2)

== Wöchentlicher PostgreSQL Newsletter - 13. Mai 2007 ==

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: "pgsql-de-allgemein(at)postgresql(dot)org" <pgsql-de-allgemein(at)postgresql(dot)org>
Cc: "pgusers(at)postgres(dot)de" <pgusers(at)postgres(dot)de>
Subject: == Wöchentlicher PostgreSQL Newsletter - 13. Mai 2007 ==
Date: 2007-05-15 01:23:42
Message-ID: (view raw or whole thread)
Lists: pgsql-de-allgemein
Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter  - 13. Mai 2007 ==

Da sind einige andauernde Diskussionen auf der -patches Liste.

== PostgreSQL Produkt Neuigkeiten ==

PostgreSQL Code Factory erschienen.

EnterpriseDB ist jetzt für Red Hat Exchange verfügbar.

MediaWiki 1.10 erschienen.

PostgresDAC 2.3.9-beta2 erschienen.

== PostgreSQL Jobs im Mai ==

== PostgreSQL Lokal ==

Auf gehts zum PgDay!

Registrierung für PGCon 2007 ist noch offen.

== PostgreSQL in den News ==

Planet PostgreSQL:

General Bits, Archive und gelegentliche News Artikel:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David

Um deine Beiträge für die nächste Ausgabe zu übermitteln, sende diese
an david(at)fetter(dot)org oder in Deutsch an pwn(at)pgug(dot)de bis Sonntag, 15:00
Uhr Pazifischer Zeit.

== Angewandte Patches ==

Magnus Hagander committed:

- 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/, log directory we're installing
  into.  Per request from Andrew Dunstan.

Bruce Momjian committed:

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

- Added some more error logging to

- Synced parser and keyword list for ECPG.  Renamed update test in the
  hope that it will run on Vista.

Neil Conway committed:

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

- 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

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

- 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

Alvaro Herrera committed:

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

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

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Pavan Deolassee sent in a flock of patches for HOT, broken out per

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

Jim Nasby sent in a patch to have vacuum emit a warning when it runs
out of maintenance_work_mem.

CK Tan sent in a patch which improves the performance of scans on big

Gregory Stark sent in another revision of his concurrent psql patch.

				Andreas 'ads' Scherbaum
Deutsche PostgreSQL Usergroup:

pgsql-de-allgemein by date

Next:From: Andreas 'ads' ScherbaumDate: 2007-05-21 21:27:42
Subject: == Wöchentlicher PostgreSQL Newsletter - 20. Mai 2007 ==
Previous:From: Andreas 'ads' ScherbaumDate: 2007-05-08 20:48:32
Subject: == Wöchentlicher PostgreSQL Newsletter - 06. Mai 2007 ==

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group