Skip site navigation (1) Skip section navigation (2)

== PostgreSQL Weekly News - July 05 2009 ==

From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)postgresql(dot)org>
Subject: == PostgreSQL Weekly News - July 05 2009 ==
Date: 2009-07-06 03:29:42
Message-ID: 20090706032942.GN17450@fetter.org (view raw or flat)
Thread:
Lists: pgsql-announce
== PostgreSQL Weekly News - July 05 2009 ==

PostgreSQL 8.4.0 released.
http://www.postgresql.org/about/press/features84.html

Round-Robin Reviewers needed ASAP!  Mail robertmhaas AT gmail DOT com
to volunteer.
http://wiki.postgresql.org/wiki/Reviewing_a_Patch

== PostgreSQL Product News ==

PostgreSQL + Replication 8.3-1.8 Beta 6, formerly known as Mammoth
Replicator, released.
https://projects.commandprompt.com/public/replicator

pgAdmin 1.10, a GUI management tool for PostgreSQL, released.
http://www.pgadmin.org/

pgloader 2.3.2, a bulk loader for PostgreSQL, released.
http://pgfoundry.org/projects/pgloader/

pgSphere 1.1.0, a module for working with spherical coordinates, released.
http://pgfoundry.org/projects/pgsphere/

== PostgreSQL Jobs for July ==

http://archives.postgresql.org/pgsql-jobs/2009-07/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

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 German PostgreSQL User Group will have a dev-room at FrOSCon on
Sunday, August 23, 2009.  The Call for Papers is open:
http://andreas.scherbaum.la/blog/archives/573-Call-for-Papers-fuer-den-PostgreSQL-Devroom-auf-der-FrOSCon-2009.html

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/

Andreas (ads) Scherbaum will be teaching a "PostgreSQL for Corporate
Use" course at the adult education center in Magdeburg, Germany on
September 7-11, 2009.  Details below:
http://andreas.scherbaum.la/blog/archives/574-PostgreSQL-als-Bildungsurlaub.html

There will be a conference in Athens, Georgia, USA on September 19,
2009.  The CfP is open.
http://www.postgresqlconference.org/2009/pgday/athens

There will be a conference in Seattle, Washington, USA October 16-18,
2009.  The CfP is open.
http://www.postgresqlconference.org/2009/west

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.  The CfP is open!
http://pgcon.postgresql.org.br/2009/chamadas.en.php

PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
November 6-7, 2009.  The CfP is out.  Submit!
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,
Josh Berkus, and Devrim GUNDUZ.

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

== Applied Patches ==

Tom Lane committed:

- In pgsql/src/include/Makefile, add missed src/include/foreign
  subdirectory to the set installed into INSTALLDIR/include/server/.
  Itagaki Takahiro

- Stamp HEAD as 8.5devel.

- Remove useless References column for pg_listener catalog
  description.  Per Shigehiro Honda.

- In pgsql/src/bin/pg_dump/pg_dump.c, fix up pg_dump's
  --binary-upgrade option so that it behaves properly with inherited
  columns and check constraints.  Per my recent trouble report.

- Fix handling of changed-Param signaling for CteScan plan nodes.  We
  were using the "cteParam" as a proxy for the possibility that the
  underlying CTE plan depends on outer-level variables or Params, but
  that doesn't work very well because it sometimes causes calling
  subqueries to be treated as SubPlans when they could be InitPlans.
  This is inefficient and also causes the outright failure exhibited
  in bug #4902.  Instead, leave the cteParam out of it and copy the
  underlying CTE plan's extParams directly.  Per bug #4902 from Marko
  (johto) Tiikkaja.

- In pgsql/src/backend/parser/gram.y, per SQL spec (in particular, the
  grammar in SQL:2008 7.13) we should allow parentheses around the
  <query expression body> that follows a WITH clause, eg with cte(foo)
  as ( values(0) ) ((select foo from cte)); This seems to be just an
  oversight/thinko in gram.y.  Noted while experimenting with bug
  #4902.

Peter Eisentraut committed:

- Regression test for XML mapping functionality.  I wrote this one
  while chasing down some bugs in the closing days of 8.4.  It could
  be useful in the long run.  This area of the code had no test
  coverage at all before.

- Upgrade to Autoconf 2.63.  This upgrades the configure
  infrastructure to the latest Autoconf version.  Some notable news
  are: the workaround for the broken fseeko() test is gone, checking
  for unknown options is now provided by Autoconf itself, and fixes
  for Mac OS X.

- In pgsql/src/bin/psql/describe.c, have \d show child tables that
  inherit from the specified parent.  As per discussion, \d shows only
  the number of child tables, because that could be hundreds, when
  used for partitioning.  \d+ shows the actual list.  Damien Clochard

- Add log_line_prefix placeholder %e to contain the current SQL state.
  Guillaume Smet

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Lars Kanis sent in a patch to extend user mappings in pg_ident.conf.

Robert Haas sent in another revision of his generated header file
handling patch.

Jeremy Kerr sent in three revisions of a patch to avoid manual
shift-and-test logic in AllocSetFreeIndex.

Robert Haas sent in a patch to autogenerate headers and bki.

KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.

Hans-Juergen Schoenig sent in a patch to transform a tsvector to table
format.

Petr (PJMODOS) Jelinek sent in another revision of his GRANT ON ALL IN
SCHEMA patch.

Fujii Masao sent in a patch to provide support for multiplexing the
SIGUSR1 signal.

Fujii Masao sent in a patch to provide support for non-blocking
communication between a frontend and a backend.

Zoltan Boszormenyi sent in two revisions of a patch to add a "string"
pseudo-type to ECPG.

Gregory Stark sent in a WIP patch to add a Merge Append node, part of
querying partitioned tables more efficiently.

Jeff Davis sent in a WIP patch to allow generalized UNIQUE constraints
such as "doesn't overlap."

Dimitri Fontaine sent in a patch to allow people to run
process_local_preload_libraries from within a transaction.


pgsql-announce by date

Next:From: Bruce MomjianDate: 2009-07-07 20:32:39
Subject: pg_migrator 8.4 released
Previous:From: Dave PageDate: 2009-07-03 07:58:25
Subject: Re: Contest: PostgreSQL Website Redesign

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group