From 20f064b71f4fdfe836bb4b5d58d5271777570f95 Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Mon, 28 Jun 2010 01:09:42 +0000
Subject: [PATCH] PostgreSQL Weekly News June 27, 2010

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

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index 433dda89..0fbbdd40 100644
--- a/portal/files/weeklynews.xml
+++ b/portal/files/weeklynews.xml
@@ -10,6 +10,18 @@
 <description></description>
 <language>en</language>
 
+<item>
+<title>PostgreSQL Weekly News June 27th 2010</title>
+<description>
+PostgreSQL is looking for quotes for the 9.0 release.  If you are
+excited about one or more 9.0 features, and represent a company, NGO
+or government, please send your quote about 9.0 to josh@postgresql.org
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20100627</guid>
+<pubDate>Sun, 27 Jun 2010 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News June 20th 2010</title>
 <description>
@@ -114,16 +126,5 @@ SEAPUG and PDXPUG will be staffing a booth at LFNW - stop by!
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20100425</guid>
 <pubDate>Sun, 25 Apr 2010 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News April 18th 2010</title>
-<description>
-Michael Renner will be speaking at AMOOCON, which goes from June 4-6, 2010.
-&#x3C;a href=&#x22;http://www.amoocon.de/speakers/214&#x22;&#x3E;http://www.amoocon.de/speakers/214&#x3C;/a&#x3E;
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20100418</guid>
-<pubDate>Sun, 18 Apr 2010 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 6b0e6f16..7e546ce5 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/pwn20100627">June 27th 2010</a></li>
     <li><a href="/community/weeklynews/pwn20100620">June 20th 2010</a></li>
     <li><a href="/community/weeklynews/pwn20100613">June 13th 2010</a></li>
     <li><a href="/community/weeklynews/pwn20100606">June 6th 2010</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20100627.html b/portal/template/en/community/weeklynews/pwn20100627.html
new file mode 100644
index 00000000..05c6e5e4
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20100627.html
@@ -0,0 +1,295 @@
+<!-- BEGIN page_title_block -->
+Weekly News - June 27 2010
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - June 27 2010</h1>
+
+<p>
+PostgreSQL is looking for quotes for the 9.0 release.  If you are
+excited about one or more 9.0 features, and represent a company, NGO
+or government, please send your quote about 9.0 to josh@postgresql.org
+</p>
+
+<p>
+PGXN, the PostgreSQL Extension Network, modelled on CPAN, has begun.
+<a href="http://www.pgxn.org/">http://www.pgxn.org/</a>
+</p>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+Slony-I 2.0.4, a master-to-multiple-cascading-replica system for
+PostgreSQL, released.
+<a href="http://www.slony.info/">http://www.slony.info/</a>
+</p>
+
+<p>
+Benetl 3.5, an ETL tool for files using PostgreSQL, released.
+<a href="http://www.benetl.net">http://www.benetl.net</a>
+</p>
+
+<p>
+Muldis-D 0.130.0, a specification for an object-relational language
+intended to run atop, among other systems, PostgreSQL, released.
+<a href="http://muldis.com/Muldis_D.html">http://muldis.com/Muldis_D.html</a>
+</p>
+
+<h2>PostgreSQL 9.0 Feature of the Week</h2>
+<h2>PostgreSQL Tip of the Week</h2>
+<h2>PostgreSQL Jobs for June</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2010-06/threads.php">http://archives.postgresql.org/pgsql-jobs/2010-06/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+CHAR(10), the PostgreSQL Conference on Clustering, High Availability
+and Replication is now open for online registration and bookings.
+July 2-3 2010, Oriel College, Oxford University, UK
+<a href="http://www.char10.org/">http://www.char10.org/</a>
+</p>
+
+<p>
+PDXPUG Day will be July 18, 2010 at the Oregon Convention Center in
+Portland, OR.  For more information, see:
+<a href="http://wiki.postgresql.org/wiki/PDXPUGDay2010">http://wiki.postgresql.org/wiki/PDXPUGDay2010</a>
+</p>
+
+<p>
+OSCON will take place in Portland, Oregon July 19-23, 2010.
+<a href="http://www.oscon.com/oscon2010">http://www.oscon.com/oscon2010</a>
+</p>
+
+<p>
+FrOSCon 2010 will take place in St. Augustin, Germany on August 21-22,
+2010.  The German PostgreSQL User Group got his own devroom and is=20
+looking for talks.  More info:
+<a href="http://andreas.scherbaum.la/blog/archives/711-FrOSCon-2010-PostgreSQL-devroom-Call-for-papers.html">http://andreas.scherbaum.la/blog/archives/711-FrOSCon-2010-PostgreSQL-devroom-Call-for-papers.html</a>
+</p>
+
+<p>
+
+== PostgreSQL in the News ==
+</p>
+
+<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
+and Josh Berkus.
+</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.  Spanish language
+to pwn@arpug.com.ar.
+</p>
+
+<h2>Applied Patches</h2>
+<p>
+Heikki Linnakangas committed:
+</p>
+
+<p>
+- In pgsql/src/pl/plpgsql/src/pl_exec.c, in a PL/pgSQL "FOR cursor"
+  statement, the statements executed in the loop might close the
+  cursor, rendering the Portal pointer to it invalid.  Closing the
+  cursor in the middle of the loop is not a very sensible thing to do,
+  but we must handle it gracefully and throw an error instead of
+  crashing.
+</p>
+
+<p>
+Robert Haas committed:
+</p>
+
+<p>
+- Minor markup improvements for Hot Standby documentation.
+</p>
+
+<p>
+- Deprecate the use of => as an operator name.  In HEAD, emit a
+  warning when an operator named => is defined.  In both HEAD and the
+  backbranches (except in 8.2, where contrib modules do not have
+  documentation), document that hstore's text => text operator may be
+  removed in a future release, and encourage the use of the
+  hstore(text, text) function instead.  This function only exists in
+  HEAD (previously, it was called tconvert), so backpatch it back to
+  8.2, when hstore was added.  Per discussion.
+</p>
+
+<p>
+- In pgsql/contrib/hstore/expected/hstore.out, updated expected-output
+  file for hstore.  This is an oversight in my previous patch to
+  deprecate => as an operator name.  Per buildfarm.
+</p>
+
+<p>
+- Add TCP keepalive support to libpq.  This adds four additional
+  connection parameters to libpq: keepalives, keepalives_idle,
+  keepalives_count, and keepalives_interval.  keepalives default to
+  on, per discussion, but can be turned off by specifying
+  keepalives=0.  The remaining parameters, where supported, can be
+  used to adjust how often keepalives are sent and how many can be
+  lost before the connection is broken.  The immediate motivation for
+  this patch is to make sure that walreceiver will eventually notice
+  if the master reboots without closing the connection cleanly, but it
+  should be helpful in other cases as well.  Tollef Fog Heen, Fujii
+  Masao, and me.
+</p>
+
+<p>
+- In pgsql/src/backend/postmaster/postmaster.c, add stray "else" that
+  seems to have gone missing.
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/release-9.0.sgml, further 9.0 release notes
+  updates.  Josh Berkus.
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/high-availability.sgml, some copy-editing of
+  the Hot Standby documentation.  Thanks to Joshua Tolley for the
+  review.
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/installation.sgml, make AIX suggestions about
+  disabling ipv6 more version-sensitive.  Chris Browne, based on a
+  report from John Pierce.
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/libpq.sgml, rewrite docs for new libpq
+  keepalive parameters.  The revised documentation makes it more clear
+  that these are client-side parameters, rather than server side
+  parameters.  It also puts the main point of each parameter first,
+  and consolidates the conditions under which it might be ignored in a
+  single list at the end.
+</p>
+
+<p>
+Bruce Momjian committed:
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/ref/pg_ctl-ref.sgml, update pg_ctl docs to
+  explain server output behavior differences on win32 and non-win32
+  platforms.
+</p>
+
+<p>
+- Fix pg_upgrade's use of pg_ctl on Win32 to not send command and
+  sever output to the same file, because it is impossible.  Also set
+  user name for pg_dumpall in pg_upgrade.
+</p>
+
+<p>
+- Add username designations to all pg_upgrade utility calls that
+  support it.
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/ref/alter_table.sgml, mention that when alter
+  rewrites a table, indexes are also rebuilt.
+</p>
+
+<p>
+Simon Riggs committed:
+</p>
+
+<p>
+- Fix log_temp_files docs and comments to say bytes not kilobytes.
+  stat(2) field st_size returns bytes not kilobytes.  Bug found during
+  recent performance tuning for PostgreSQL user.
+</p>
+
+<p>
+Tom Lane committed:
+</p>
+
+<p>
+- Fix thinko in tok_is_keyword(): it was looking at the wrong union
+  variant of YYSTYPE, and hence returning the wrong answer for cases
+  where a plpgsql "unreserved keyword" really does conflict with a
+  variable name.  Obviously I didn't test this enough :-(.  Per bug
+  #5524 from Peter Gagarinov.
+</p>
+
+<p>
+- In pgsql/src/bin/pg_dump/pg_backup_custom.c, fix pg_restore so
+  parallel restore doesn't fail when the input file doesn't contain
+  data offsets (which it won't, if pg_dump thought its output wasn't
+  seekable).  To do that, remove an unnecessarily aggressive error
+  check, and instead fail if we get to the end of the archive without
+  finding the desired data item.  Also improve the error message to be
+  more specific about the cause of the problem.  Per discussion of
+  recent report from Igor Neyman.  Back-patch to 8.4 where parallel
+  restore was introduced.
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Guillaume Lelarge sent in a patch to add a CHECK_FOR_INTERRUPTS call
+to the copy_relation_data(), copy_dir(), and copy_file() functions,
+which fixes an issue where cancelling ALTER TABLE ...  SET TABLESPACE
+and ALTER DATABASE ... SET TABLESPACE did not work.
+</p>
+
+<p>
+Heikki Linnakangas sent in a patch to fix an issue where the server
+would crash while trying to read an expression using pg_get_expr().
+</p>
+
+<p>
+Andrew Dunstan sent in a WIP patch to make ENUMs alterable.
+</p>
+
+<p>
+Kevin Grittner sent in a cleaned-up version of the patch to allow
+dividing money by money.
+</p>
+
+<p>
+Peter Eisentraut sent in a patch to make PostgreSQL compile under
+clang.
+</p>
+
+<p>
+Peter Eisentraut sent in another revision of the patch which allows
+ommission of non-aggregate columns in certain situations in GROUP BY.
+</p>
+
+<p>
+Pavel Baros sent in a patch to implement materialized views.
+</p>
+
+<p>
+Robert Haas sent in a patch to simplify emode_for_corrupt_record.
+</p>
+
+<p>
+Mark Fowler sent in another revision of the patch to add an
+xpath_exists function.
+</p>
+
+<p>
+Mark Fowler sent in another revision of the patch to add XMLEXISTS to
+the grammar.
+</p>
+
+<p>
+Robert Haas sent in a patch to allow suppressing crash recovery after
+a crash, per discussion on -performance about a volatile version of
+PostgreSQL.
+
+</p>
+
-- 
2.39.5