== PostgreSQL Weekly News - September 17 2006 == - Mailing list pgsql-announce

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