== PostgreSQL Weekly News - June 21 2009 ==

== PostgreSQL Weekly News - June 21 2009 ==

The Call for Papers for pgday.eu is out.  Submit!
http://2009.pgday.eu/

On October 1st, 2ndQuadrant will offer free support to the students of
the L'Aquila University in the Abruzzi region over a 15 month period.
For more information (in Italian):
http://blog.2ndquadrant.it/it/2009/06/2ndquadrant-universita-aquila.html

OpenSQL Camp will take place August 22-23, 2009 in St. Augustin,
Germany, close to Bonn and Cologne.  Deadline for the CfP is July 19,
2009.  Get your proposals in!
http://opensqlcamp.org/Events/2009/Call_for_Participation

The CfP for PyCon Argentina is open until June 29th, 2009 23:59 ART.
The conference itself will be in Beunos Aires on September 4-5 2009.
http://ar.pycon.org/2009/rfp/

== PostgreSQL Product News ==

Benetl 2.8, an ETL tool for files using PostgreSQL, released.
http://www.benetl.net

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

PostGIS 1.4.0 beta 1, a Geographic Information System for PostgreSQL, released.
http://postgis.refractions.net/

rubyrep 1.0.3, an asynchronous master-master replication system, released.
http://www.rubyrep.org

== PostgreSQL 8.4 Feature of the Week ==

EXPLAIN ANALYZE shows you sort and hash memory usage.

== PostgreSQL Tip of the Week ==

User-set GUCs (system settings) such as work_mem and
constraint_exclusion can be set as the property of a ROLE or of a
function.

== PostgreSQL Jobs for June ==

http://archives.postgresql.org/pgsql-jobs/2009-06/threads.php

== PostgreSQL Local ==

pgDay San Jose is Sunday, July 19th 2009 immediately before OSCON.
Sign up below:
http://postgresql.meetup.com/1/calendar/10626647

The CfP for PGCon Brazil is open!
http://pgcon.postgresql.org.br/2009/chamadas.en.php

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
November 6-7, 2009.
http://www.pgday.eu/

JPUG 10th Anniversary Conference has started its Request for
Proposals.  The conference is November 20-21, 2009 in Tokyo, Japan.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter
and Josh Berkus

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.

== Applied Patches ==

Peter Eisentraut committed:

- In pgsql/src/pl/plpgsql/src/pl_exec.c, fix typo in error message:
  tgargv -> tg_argv

- In pgsql/doc/src/sgml/maintenance.sgml, add another link of a GUC
  variable to where it is explained.

- Refine the use of terminology around bound and unbound cursors and
  cursor variables. Remove the confusing term "reference cursor".

- Add some more documentation and cross-links on using dblink with
  SQL/MED.

- In pgsql/doc/Makefile, don't attempt to "rm" directories on
  uninstall.

- Add manvolnum, so that man pages are generated.

- In pgsql/doc/src/sgml/Makefile, don't convert the man page names to
  lower case, so that the .so links work.  This is pretty much a
  workaround for incomplete tools, but having the man page names in
  upper case looks more natural anyway.

- In pgsql/doc/Makefile, extend man page installation hackery so that
  the man page section is also fixed up in the .so links.

- Message fixes.

Tom Lane committed:

- In pgsql/src/backend/executor/nodeAgg.c, ExecAgg() failed to finish
  running out set-returning functions in the last aggregated tuple of
  a run.  Per report from Laurenz Albe.  This is a new bug in 8.4, but
  only because prior versions rejected SRFs in an Agg plan node
  altogether.

- Proofreading for Bruce Momjian's recent round of documentation
  proofreading.  Most of those changes were good, but some not so good...

- Fix the just-reported problem that you can't specify all four
  trigger event types in CREATE TRIGGER.  While at it, clean up the
  amazingly tedious and inextensible way that the trigger event type
  list was handled.  Per report from Greg Sabino Mullane.

- Fix things so that array_agg_finalfn does not modify or free its
  input ArrayBuildState, per trouble report from Merlin Moncure.  By
  adopting this fix, we are essentially deciding that aggregate
  final-functions should not modify their inputs ever.  Adjust
  documentation and comments to match that conclusion.

Heikki Linnakangas committed:

- Fix a few errors in comments.  Patch by Fujii Masao, plus the one in
  visibilitymap.c by me.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Gurjeet Singh sent in a Perl program called neurodiff which allows
comparing both regular expression matches and result sets independent
of order.

Robert Haas sent in a patch to change do_tup_output to take Datum
arguments rather than cstring.

Kevin Grittner sent in another version of his
toast-main-out-of-line-reluctantly patch.

Jeremy Kerr sent in another revision of his patch to compare
word-at-a-time in src/backend/utils/adt/varchar.c's bcTruelen.

Fujii Masao sent in another revision of the sync rep patch.

Petr (PJMODOS) Jelinek sent in a patch which allows per-schema GRANT
and REVOKE on database objects.

Robert Haas sent in another revision of his "generic options for
explain" patch.

Robert Haas sent in another revision of his machine-readable explain
output patch.