== PostgreSQL Weekly News - March 07 2010 ==
Bug fix updates for PostgreSQL 7.4 through 8.4 will be out soon. Get
ready to upgrade!
The San Francisco PostgreSQL Users' Group will be having a Test Fest
Saturday April 3, 11am to 6pm. There will be live video. Help make
this a world-wide event!
== PostgreSQL Product News ==
MicroOLAP Database Designer 1.2.10 for PostgreSQL released.
The PGCon 2010 Schedule is now available.
PostgreSQLfr will have a booth at SolutionsLinux 2010 in Paris,
France March 16-18, 2010. Volunteers, please contact Stephane
Schildknecht at sas AT postgresql DOT fr, or the general PostgreSQLfr
address at bureau AT postgresql DOT fr. More information on the
== PostgreSQL 9.0 Feature of the Week ==
EXPLAIN output can be formatted as XML, JSON, and YAML, making machine
parsing much simpler. The traditional text format is still the
== PostgreSQL Local ==
BWPUG will be meeting in Falls Church, VA, USA on March 10, 2010 at
The German Language PostgreSQL User Group has a booth at Chemnitz Linuxdays
2010 on March 13 and 14, 2010 in Chemnitz, Germany. Andreas (ads)
Scherbaum will be giving a talk on PostgreSQL 9.0 and a workshop on
JDCon East will take place March 25-28, 2010 in Philadelphia, PA, USA.
Linuxfest Northwest 2010 will take place in Bellingham, Washington,
USA on April 24 and 25. Session, Booth and Sponsorship are available.
Andreas (ads) Scherbaum will be teaching a "PostgreSQL for Corporate
Use" course at the adult education center in Magdeburg, Germany May
3-7, 2010. Details below:
PgCon 2010 will be held May 20-21 2010 in Ottawa with tutorials before
on the 18th and 19th.
The CfP for OSBridge is open! OSBridge will be June 1-4, 2010 in
OSCON will take place in Portland, Oregon July 19-23, 2010.
== PostgreSQL in the News ==
Planet PostgreSQL: http://planet.postgresql.org/
PostgreSQL Weekly News is brought to you this week by David Fetter
Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to [email protected], German language
to [email protected], Italian language to [email protected]
== Applied Patches ==
Tom Lane committed:
- Back-patch today's memory management fixups in contrib/xml2. Prior
to 8.3, these changes are not critical for compatibility with core
Postgres, since core had no libxml2 calls then. However there is
still a risk if contrib/xml2 is used along with libxml2
functionality in Perl or other loadable modules. So back-patch to
all versions. Also back-patch addition of regression tests. I'm
not sure how many of the cases are interesting without the
interaction with core xml code, but a silly regression test is still
better than none at all.
- Remove xmlCleanupParser calls from contrib/xml2. These are
unnecessary and probably dangerous. I don't see any immediate risk
situations in the core XML support or contrib/xml2 itself, but there
could be issues with external uses of libxml2, and in any case it's
an accident waiting to happen.
- In pgsql/src/port/copydir.c, buildfarm still unhappy, so I'll bet
it's EACCES not EPERM.
- Fix contrib/xml2 so regression test still works when it's built
without libxslt. This involves modifying the module to have a
stable ABI, that is, the xslt_process() function still exists even
without libxslt. It throws a runtime error if called, but doesn't
prevent executing the CREATE FUNCTION call. This is a good thing
anyway to simplify cross-version upgrades.
- In pgsql/src/pl/plpgsql/src/gram.y, cause plpgsql to throw an error
if "INTO rowtype_var" is followed by a comma. Per bug #5352, this
helps to provide a useful error message if the user tries to do
something presently unsupported, namely use a rowtype variable as a
member of a multiple-item INTO list.
- In pgsql/src/pl/plpgsql/src/gram.y, instead of trying (and failing)
to allow <