== PostgreSQL Weekly News - September 17 2006 == There is a wide-ranging discussion on -hackers of how to reduce data type space usage.
Peter Eisentraut has put up a wiki for PostgreSQL XML discussion and planning. http://developer.postgresql.org/index.php/XML_Support Jim Nasby has joined EnterpriseDB. Kudos to both! == PostgreSQL Product News == MicroOLAP PostgresDAC 2.3.5 released. http://microolap.com/products/connectivity/postgresdac/ Slony-I 1.2RC4 has been tagged and released. Please test. http://pgfoundry.org/frs/?group_id=1000122 == PostgreSQL Jobs for September == http://archives.postgresql.org/pgsql-jobs/2006-09/threads.php == PostgreSQL Local == Everything this week was global. == 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 and Dave Page. == Applied Patches == Tom Lane committed: - contrib/isn updates from Jeremy Kronuz. - Remove unhelpful/misleading advice about how to use SPI_saveplan(). Per gripe from Jack Orenstein. - Fix dblink build for --enable-nls or --enable-openssl on AIX. Per Chris Browne. - Add LDAP_LIBS_FE to $(libpq) for static or AIX linking, per Albe Laurenz. - Install a cleaner solution to the AIX libpq linking problem, as per an earlier discussion. Centralize assumptions about what libpq depends on in one place in Makefile.global. - Fix unportable usage complained of by icc. Per buildfarm results. - Move set_pglocale_pgservice() from path.c to exec.c, so that pulling in path.c does not in itself force linking of both exec.c and libintl. This change should fix current ecpglib build failure on pickier platforms. - Fix omissions in contrib uninstall scripts. Michael Fuhr - Move xml2's PG_MODULE_MAGIC block to the right source file, per Michael Fuhr. - Some small editorialization on the description of CREATE INDEX CONCURRENTLY. - Rename the uninstall scripts for contrib/lo and contrib/tsearch2 to match the convention that foo's uninstall script is uninstall_foo.sql. Also, stop installing lo_test.sql, which really ought to be made into a regression test anyway (though it's unclear how to avoid a dependency on the current OID counter...) - Make logging of extended-protocol commands a bit more consistent, per discussion with Guillaume Smet. - Code review for patch to avoid second scan when vacuuming index-less table: avoid invoking LockBufferForCleanup without need, put out the same log message we would have before, minor code beautification. - Add a couple of information functions to support direct checks on whether a schema is our own temp schema or another backend's temp schema, and use these in place of some former kluges in information_schema. - Add a couple of information functions to support direct checks on whether a schema is our own temp schema or another backend's temp schema, and use these in place of some former kluges in information_schema. - Fix some uses in hstore of str[n]casecmp that should be pg_str[n]casecmp. - Fix some uses in libpq of str[n]casecmp that should be pg_str[n]casecmp, per Magnus Hagander. - Remove WINLDAPAPI decoration from ldap_start_tls_sA typedef, per Magnus Hagander. - Improve confusing comment for HeapTupleSatisfiesNow, per gripe from Greg Stark. - Several fixes from Magnus Hagander for the MSVC build scripts. - Update timezone data files to release 2006k of the zic database. - Rename xml_valid() to xml_is_well_formed(), but provide a temporary alias with the old name for backwards compatibility. Per discussion, the old name is actively wrong because validity and well-formedness have different meanings in XML. - Define errcode as __msvc_errcode not __vc_errcode for MSVC builds, per Magnus Hagander. - Fix some more uses of str[n]casecmp that should be pg_str[n]casecmp. - Change ANALYZE to take ShareUpdateExclusiveLock not AccessShareLock on the table being analyzed. This prevents two ANALYZEs from running concurrently on the same table and possibly suffering concurrent-update failures while trying to store their results into pg_statistic. - Fix CREATE TABLE ... AS VALUES ... to work rather than Assert'ing; oversight in original implementation of VALUES. Also fix an oversight in recent addition of options to CREATE TABLE AS: they weren't getting propagated if the query was a set-operation such as UNION. - Rename the recently-added pg_timezonenames view to pg_timezone_abbrevs, and create a new view pg_timezone_names that provides information about the zones known in the 'zic' database. Magnus Hagander, with some additional work by Tom Lane. Teodor Sigaev committed: - Add uninstall script for hstore. - Improve error message per discussion http://archives.postgresql.org/pgsql-general/2006-09/msg00186.php - GIN documentation and slightly improving GiST docs. Initial version by Christopher Kings-Lynne with edits by Jeff Davis. Peter Eisentraut committed: - Dave Page's fix for the README install for contrib/sslinfo. Michael Meskes committed: - Various fixes to ecpg - Added missing constuctor/destructor for interval and date. - Cygwin systems seem to have a different error message when trying to connect to port 0. Let's try port 20 instead. Tatsuo Ishii committed: - Change "tps" to "scale" to avoid confusion and fix bug with handling default scaling factor in the default scenarios. - Fix pgbench bug with handling default scaling factor in the default scenarios. Bruce Momjian committed: - Remove unnecessary brace pair. - Make postgresql.conf.sample match the initdb defaults. This fixes comment alignment on most systems. - Remove sslinfo copyright with author permission, keep author attribution. - Make various updates to the TODO list and release notes. - Add recent ICU URL. - Remove emacs info from footer of SGML files. - Simon Riggs's docs on Warm Standby for High Availability, including a sample standby script. - More docs from Simon Riggs to the effect that WAL recovery now uses checkpoints. - Remove emacs info from footer of SGML files. == Rejected Patches (for now) == Heikki Linnakangas's patch that removes currentItemData & currentMarkpos from IndexScanDesc, and adds equivalent fields in access method specific opaque structs for those access methods that need them. This is saved for 8.3. Bruce Momjian backed out a patch which allows to_char() "D" format specifiers for interval/time. == Pending Patches == D'Arcy J.M. Cain sent in a patch which changes the money type to use 64-bit math. David Fuhry patched the GIN docs. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
