Skip to content

Wöchentlicher PostgreSQL Newsletter - 11. März 2007

Der Originalartikel befindet sich unter:

== Wöchentlicher PostgreSQL Newsletter - 11. März 2007 ==

Eine lebhafte Diskussion ist auf -hackers in Gange über das automatische Erstellen von Partitionen.

== PostgreSQL Produkt Neuigkeiten ==

Phil Endecott hat neue C++ Bindings für PostgreSQL erstellt.

Security Enhanced PostgreSQL (SE-PostgreSQL) 8.2.3-1.0 alpha erschienen.

Slony-I 1.1.7 und 1.2.7 erschienen.

== PostgreSQL Jobs für März ==

== PostgreSQL Lokal ==

Die italienische PostgreSQL Community ist auf der Suche nach Sponsoren für ihren PostgreSQL Tag in Prato, Italien im Sommer. Mehr Informationen unter untenstehendem Link.

== PostgreSQL in den News ==

Planet PostgreSQL:

General Bits, Archive und gelegentliche News Artikel:

Dieser wöchentliche PostgreSQL Newsletter wurde erstellt von David Fetter

Um deine Beiträge für die nächste Ausgabe zu übermitteln, sende diese an oder in Deutsch an bis Sonntag, 15:00 Uhr Pazifischer Zeit.

== Angewandte Patches ==

Andrew Dunstan committed:

- In pgsql/src/test/regress/output/largeobject_1.source, add alternate
result file for large object tests to handle Windows line ends.

Teodor Sigaev committed:

- Athough cube is a varlena type, nowhere was a detoasting of cube's
value, so fix it. Add macroses DatumGetNDBOX, PG_GETARG_NDBOX and
PG_RETURN_NDBOX. Backpatch for 8.2 too. Previous versions use
version 0 calling conventions. And fmgr code detoast values for
user-defined functions.

Alvaro Herrera committed:

- Fix a race condition that caused pg_database_size() and
pg_tablespace_size() to fail if an object was removed between calls
to ReadDir() and stat(). Per discussion in pgsql-hackers.
Bug report and patch by Michael Fuhr.

- Clean up the bootstrap code a little, and rename "dummy procs" in
the code comments and variables to "auxiliary proc", per Heikki's

Tom Lane committed:

- Fix vac_update_relstats to ensure it always sends a relcache inval
message, even if none of the fields in the pg_class row change.
This behavior is necessary to ensure other backends flush
rd_targblock values that might point to truncated-away pages. We
got this right pre-8.2 but it was broken by overoptimistic change to
not write out the pg_class row if unchanged. Per report from Pavan

- Fix oversight in original coding of inline_function(): since
check_sql_fn_retval allows binary-compatibility cases, the
expression extracted from an inline-able SQL function might have a
type that is only binary-compatible with the declared function
result type. To avoid possibly changing the semantics of the
expression, we should insert a RelabelType node in such cases. This
has only been shown to have bad consequences in recent 8.1 and up
releases, but I suspect there may be failure cases in the older
branches too, so patch it all the way back. Per bug #3116 from Greg
Mullane. Along the way, fix an omission in
eval_const_expressions_mutator: it failed to copy the relabelformat
field when processing a RelabelType. No known observable failures
from this, but it definitely isn't intended behavior.

Peter Eisentraut committed:

- Toru SHIMOGAKI's patch which adds more information about avoiding
Linux OOM killer.

Bruce Momjian committed:

- Minor edits to pgsql/doc/src/sgml/runtime.sgml

- Revert temp_tablespaces because of coding problems, per Tom Lane.

- In pgsql/src/backend/utils/adt/geo_ops.c, remove copied comments
from geo_ops.c source file and replace with new comments, and
cleanup functions. Remove copyright that is no longer relevant.

- Remove timeline for 8.3 release from FAQ_DEV, as it is now on web

Magnus Hagander commmitted:

- Remove unsafe calling of WSAStartup and WSACleanup from DllMain.
Move the inline cleanup call around so it will be called in the
right order, and be called on errors. Per report from Tokuharu

- Add script to build documentation on win32 without mingw.

- Remove old-style win32 client-only visual c++ build infrastructure
for everything except libpq. We need to keep libpq to build static
libraries and to use PQtrace with clients using older versions of

Neil Conway committed:

- Heikki Linnakangas patch which fixes a typo in a comment in

== Abgelehnte Patches (bis jetzt) ==

No one was disappointed this week :-)

== Eingesandte Patches ==

Zoltan Boszormenyi sent in one more version of his IDENTITY/GENERATED

Nikolay Samokhvalov sent in another version of his xpath_array()

ITAGAKI Takahiro sent in a patch which automatically adjusts

ITAGAKI Takahiro sent in a patch to speed up pg_bench.

Simon Riggs sent in a patch which lets people do some heap page

Mike Rylander sent in a patch against contrib/xml2 which adds support
for default XML namespaces.

Trevor Hardcastle sent in a patch which adds support for CREATE TABLE

Tatsuhito Kasahara sent in a patch to fix a bug reporting a value of
strange leaf_fragmentation.

Pavan Deolasee sent in version 4.1 of his HOT WIP patch, this one with
some optimizations for efficiently looking up LP_DELETEd tuples and
some new logic to clean up row level fragmentation.

Gregory Stark sent in another version of his packed varlenas patch,
now with bug fixes and new regression tests.

Simon Riggs sent in a patch to add new functions that examine the
contents of heap pages, as discussed recently on -hackers.

Simon Riggs sent in a patch which adds a new GUC variable:

Simon Riggs sent in two versions of a patch to implement buffer cache
recycling for scans, as being discussed on pgsql-hackers.

Gregory Stark sent in a patch which implements WITH (not RECURSIVE).

Gregory Stark sent in another version of his compact varlena patch,
now with a special case for little-endian machines.

Heikki Linnakangas sent in a patch documenting that CLUSTER isn't

Tom Lane sent in a WIP patch for plan invalidation.