== PostgreSQL Weekly News - September 17 2006 ==

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