From ad4381c0a4892d4020ae3847a08a47d8c093f2bc Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Mon, 6 Jul 2009 03:26:11 +0000
Subject: [PATCH] PostgreSQL Weekly News July 05, 2009

git-svn-id: file:///Users/dpage/pgweb/svn-repo/trunk@2524 8f5c7a92-453e-0410-a47f-ad33c8a6b003
---
 portal/files/weeklynews.xml                   |  22 +-
 portal/template/en/community/weeklynews.html  |   1 +
 .../en/community/weeklynews/pwn20090705.html  | 270 ++++++++++++++++++
 3 files changed, 282 insertions(+), 11 deletions(-)
 create mode 100644 portal/template/en/community/weeklynews/pwn20090705.html

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index 2534fa68..8eac4c98 100644
--- a/portal/files/weeklynews.xml
+++ b/portal/files/weeklynews.xml
@@ -10,6 +10,17 @@
 <description></description>
 <language>en</language>
 
+<item>
+<title>PostgreSQL Weekly News July 5th 2009</title>
+<description>
+PostgreSQL 8.4.0 released.
+&#x3C;a href=&#x22;http://www.postgresql.org/about/press/features84.html&#x22;&#x3E;http://www.postgresql.org/about/press/features84.html&#x3C;/a&#x3E;
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20090705</guid>
+<pubDate>Sun, 05 Jul 2009 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News June 28th 2009</title>
 <description>
@@ -113,16 +124,5 @@ OpenStreetMap moves to PostgreSQL:
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20090503</guid>
 <pubDate>Sun, 03 May 2009 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News April 26th 2009</title>
-<description>
-The Spanish-speaking PostgreSQL community now has its own web site.  Kudos!
-&#x3C;a href=&#x22;http://www.postgresql-es.org/&#x22;&#x3E;http://www.postgresql-es.org/&#x3C;/a&#x3E;
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20090426</guid>
-<pubDate>Sun, 26 Apr 2009 00:00:00 PST</pubDate>
-</item>
 </channel>
 </rss>
\ No newline at end of file
diff --git a/portal/template/en/community/weeklynews.html b/portal/template/en/community/weeklynews.html
index fded7439..eb15a8d4 100644
--- a/portal/template/en/community/weeklynews.html
+++ b/portal/template/en/community/weeklynews.html
@@ -9,6 +9,7 @@ Weekly News
 <p>To receive the Weekly News in your inbox, please subscribe to the <a href="/community/lists/subscribe">pgsql-announce@postgresql.org</a> mailing list.</p>
 
 <ul>
+    <li><a href="/community/weeklynews/pwn20090705">July 5th 2009</a></li>
     <li><a href="/community/weeklynews/pwn20090628">June 28th 2009</a></li>
     <li><a href="/community/weeklynews/pwn20090621">June 21st 2009</a></li>
     <li><a href="/community/weeklynews/pwn20090614">June 14th 2009</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20090705.html b/portal/template/en/community/weeklynews/pwn20090705.html
new file mode 100644
index 00000000..39b9b85d
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20090705.html
@@ -0,0 +1,270 @@
+<!-- BEGIN page_title_block -->
+Weekly News - July 05 2009
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - July 05 2009</h1>
+
+<p>
+PostgreSQL 8.4.0 released.
+<a href="http://www.postgresql.org/about/press/features84.html">http://www.postgresql.org/about/press/features84.html</a>
+</p>
+
+<p>
+Round-Robin Reviewers needed ASAP!  Mail robertmhaas AT gmail DOT com
+to volunteer.
+<a href="http://wiki.postgresql.org/wiki/Reviewing_a_Patch">http://wiki.postgresql.org/wiki/Reviewing_a_Patch</a>
+</p>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+PostgreSQL + Replication 8.3-1.8 Beta 6, formerly known as Mammoth
+Replicator, released.
+<a href="https://projects.commandprompt.com/public/replicator">https://projects.commandprompt.com/public/replicator</a>
+</p>
+
+<p>
+pgAdmin 1.10, a GUI management tool for PostgreSQL, released.
+<a href="http://www.pgadmin.org/">http://www.pgadmin.org/</a>
+</p>
+
+<p>
+pgloader 2.3.2, a bulk loader for PostgreSQL, released.
+<a href="http://pgfoundry.org/projects/pgloader/">http://pgfoundry.org/projects/pgloader/</a>
+</p>
+
+<p>
+pgSphere 1.1.0, a module for working with spherical coordinates, released.
+<a href="http://pgfoundry.org/projects/pgsphere/">http://pgfoundry.org/projects/pgsphere/</a>
+</p>
+
+<h2>PostgreSQL Jobs for July</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2009-07/threads.php">http://archives.postgresql.org/pgsql-jobs/2009-07/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+pgDay San Jose is Sunday, July 19th 2009 immediately before OSCON.
+Sign up below:
+<a href="http://postgresql.meetup.com/1/calendar/10626647">http://postgresql.meetup.com/1/calendar/10626647</a>
+</p>
+
+<p>
+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!
+<a href="http://opensqlcamp.org/Events/2009/Call_for_Participation">http://opensqlcamp.org/Events/2009/Call_for_Participation</a>
+</p>
+
+<p>
+The German PostgreSQL User Group will have a dev-room at FrOSCon on
+Sunday, August 23, 2009.  The Call for Papers is open:
+<a href="http://andreas.scherbaum.la/blog/archives/573-Call-for-Papers-fuer-den-PostgreSQL-Devroom-auf-der-FrOSCon-2009.html">http://andreas.scherbaum.la/blog/archives/573-Call-for-Papers-fuer-den-PostgreSQL-Devroom-auf-der-FrOSCon-2009.html</a>
+</p>
+
+<p>
+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.
+<a href="http://ar.pycon.org/2009/rfp/">http://ar.pycon.org/2009/rfp/</a>
+</p>
+
+<p>
+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:
+<a href="http://andreas.scherbaum.la/blog/archives/574-PostgreSQL-als-Bildungsurlaub.html">http://andreas.scherbaum.la/blog/archives/574-PostgreSQL-als-Bildungsurlaub.html</a>
+</p>
+
+<p>
+There will be a conference in Athens, Georgia, USA on September 19,
+2009.  The CfP is open.
+<a href="http://www.postgresqlconference.org/2009/pgday/athens">http://www.postgresqlconference.org/2009/pgday/athens</a>
+</p>
+
+<p>
+There will be a conference in Seattle, Washington, USA October 16-18,
+2009.  The CfP is open.
+<a href="http://www.postgresqlconference.org/2009/west">http://www.postgresqlconference.org/2009/west</a>
+</p>
+
+<p>
+PGCon Brazil will be take place October 23-24 2009 at Unicamp in
+Campinas, Sao Paulo state.  The CfP is open!
+<a href="http://pgcon.postgresql.org.br/2009/chamadas.en.php">http://pgcon.postgresql.org.br/2009/chamadas.en.php</a>
+</p>
+
+<p>
+PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
+November 6-7, 2009.  The CfP is out.  Submit!
+<a href="http://www.pgday.eu/">http://www.pgday.eu/</a>
+</p>
+
+<p>
+JPUG 10th Anniversary Conference has started its Request for
+Proposals.  The conference is November 20-21, 2009 in Tokyo, Japan.
+<a href="http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php">http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php</a>
+</p>
+
+<h2>PostgreSQL in the News</h2>
+<p>
+Planet PostgreSQL: <a href="http://planet.postgresql.org/">http://planet.postgresql.org/</a>
+</p>
+
+<p>
+PostgreSQL Weekly News is brought to you this week by David Fetter,
+Josh Berkus, and Devrim GUNDUZ.
+</p>
+
+<p>
+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.
+</p>
+
+<h2>Applied Patches</h2>
+<p>
+Tom Lane committed:
+</p>
+
+<p>
+- In pgsql/src/include/Makefile, add missed src/include/foreign
+  subdirectory to the set installed into INSTALLDIR/include/server/.
+  Itagaki Takahiro
+</p>
+
+<p>
+- Stamp HEAD as 8.5devel.
+</p>
+
+<p>
+- Remove useless References column for pg_listener catalog
+  description.  Per Shigehiro Honda.
+</p>
+
+<p>
+- 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.
+</p>
+
+<p>
+- 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.
+</p>
+
+<p>
+- 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.
+</p>
+
+<p>
+Peter Eisentraut committed:
+</p>
+
+<p>
+- 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.
+</p>
+
+<p>
+- 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.
+</p>
+
+<p>
+- 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
+</p>
+
+<p>
+- Add log_line_prefix placeholder %e to contain the current SQL state.
+  Guillaume Smet
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Lars Kanis sent in a patch to extend user mappings in pg_ident.conf.
+</p>
+
+<p>
+Robert Haas sent in another revision of his generated header file
+handling patch.
+</p>
+
+<p>
+Jeremy Kerr sent in three revisions of a patch to avoid manual
+shift-and-test logic in AllocSetFreeIndex.
+</p>
+
+<p>
+Robert Haas sent in a patch to autogenerate headers and bki.
+</p>
+
+<p>
+KaiGai Kohei sent in another revision of his SE-PostgreSQL patches.
+</p>
+
+<p>
+Hans-Juergen Schoenig sent in a patch to transform a tsvector to table
+format.
+</p>
+
+<p>
+Petr (PJMODOS) Jelinek sent in another revision of his GRANT ON ALL IN
+SCHEMA patch.
+</p>
+
+<p>
+Fujii Masao sent in a patch to provide support for multiplexing the
+SIGUSR1 signal.
+</p>
+
+<p>
+Fujii Masao sent in a patch to provide support for non-blocking
+communication between a frontend and a backend.
+</p>
+
+<p>
+Zoltan Boszormenyi sent in two revisions of a patch to add a "string"
+pseudo-type to ECPG.
+</p>
+
+<p>
+Gregory Stark sent in a WIP patch to add a Merge Append node, part of
+querying partitioned tables more efficiently.
+</p>
+
+<p>
+Jeff Davis sent in a WIP patch to allow generalized UNIQUE constraints
+such as "doesn't overlap."
+</p>
+
+<p>
+Dimitri Fontaine sent in a patch to allow people to run
+process_local_preload_libraries from within a transaction.
+
+</p>
+
-- 
2.39.5