== PostgreSQL Weekly News - March 11 2007 ==

== PostgreSQL Weekly News - March 11 2007 ==

A lively discussion continues on -hackers about automatically creating
partitions.

== PostgreSQL Product News ==

Phil Endecott has created a new C++ binding for PostgreSQL.
http://svn.chezphil.org/libpbe/trunk/doc/Database

Security Enhanced PostgreSQL (SE-PostgreSQL) 8.2.3-1.0 alpha released.
http://code.google.com/p/sepgsql/

Slony-I 1.1.7 and 1.2.7 released.
http://main.slony.info/

== PostgreSQL Jobs for March ==

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

== PostgreSQL Local ==

The Italian PostgreSQL community is looking for sponsors for its
PostgreSQL day in Prato, Italy this summer. Check the link below
to participate.
http://www.pgday.it

== PostgreSQL in the News ==

Planet PostgreSQL: http://www.planetpostgresql.org/

General Bits, Archives and occasional new articles:
http://www.varlena.com/GeneralBits/

PostgreSQL Weekly News is brought to you this week by David Fetter

To get your submission into the upcoming issue, make sure it arrives
at david(at)fetter(dot)org or in German at pwn(at)pgug(dot)de by Sunday at 3:00pm
Pacific Time.

== Applied 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.
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00671.php
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
request.

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
Deolasee.

- 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
site.

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
Yuzawa.

- 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
MSVC.

Neil Conway committed:

- Heikki Linnakangas patch which fixes a typo in a comment in
pgsql/src/backend/access/nbtree/nbtinsert.c.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

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

Nikolay Samokhvalov sent in another version of his xpath_array()
patch.

ITAGAKI Takahiro sent in a patch which automatically adjusts
bgwriter_lru_maxpages.

ITAGAKI Takahiro sent in a patch to speed up pg_bench.

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

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
LIKE INCLUDING INDEXES.

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:
log_autovacuum.

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
MVCC-safe.

Tom Lane sent in a WIP patch for plan invalidation.