Home
Reading
Searching
Subscribe
Sponsors
Statistics
Posting
Contact
Spam
Lists
Links
About
Hosting
Filtering
Features Download
Marketing
Archives
FAQ
Blog
 
Gmane
From: David Fetter <david <at> fetter.org>
Subject: == PostgreSQL Weekly News - March 07 2010 ==
Newsgroups: gmane.comp.db.postgresql.announce
Date: Monday 8th March 2010 07:16:23 UTC (over 6 years ago)
== 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!
http://wiki.postgresql.org/wiki/SFPUG_Beta_Test_Day

== PostgreSQL Product News ==

MicroOLAP Database Designer 1.2.10 for PostgreSQL released.
http://microolap.com/products/database/postgresql-designer/

The PGCon 2010 Schedule is now available.
http://www.pgcon.org/2010/schedule/

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
conference at:
http://www.solutionslinux.fr

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

== PostgreSQL Local ==

BWPUG will be meeting in Falls Church, VA, USA on March 10, 2010 at
6:30pm.
http://www.xzilla.net/blog/2010/Feb/BWPUG-March-10th,-Falls-Church-take-two..html

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
tuning PostgreSQL.
http://andreas.scherbaum.la/blog/archives/652-PostgreSQL-stand-at-Chemnitz-Linux-Days-2010.html
http://chemnitzer.linux-tage.de/2010/vortraege/plan.html

JDCon East will take place March 25-28, 2010 in Philadelphia, PA, USA.
http://www.postgresqlconference.org/2010/east

Linuxfest Northwest 2010 will take place in Bellingham, Washington,
USA on April 24 and 25.  Session, Booth and Sponsorship are available.
http://linuxfestnorthwest.org/

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:
http://andreas.scherbaum.la/blog/archives/650-PostgreSQL-Schulung-als-Bildungsurlaub-03.-07.05.2010-in-Magdeburg.html

PgCon 2010 will be held May 20-21 2010 in Ottawa with tutorials before
on the 18th and 19th.
http://www.pgcon.org/2010/registration.php

The CfP for OSBridge is open!  OSBridge will be June 1-4, 2010 in
Portland, Oregon.
http://opensourcebridge.org/events/2010/proposals/

OSCON will take place in Portland, Oregon July 19-23, 2010.
http://www.oscon.com/oscon2010


== 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 <
 
CD: 3ms