|From:||David Fetter <david-AT-fetter.org>|
|To:||PostgreSQL Announce <pgsql-announce-AT-postgresql.org>|
|Subject:||[ANNOUNCE] == PostgreSQL Weekly News - March 11 2007 ==|
|Date:||Sun, 11 Mar 2007 22:44:16 -0700|
== 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... == 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 email@example.com or in German at firstname.lastname@example.org 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/msg0... 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. ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: email@example.com
Copyright © 2007, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds