From e148f87d1060a269867261991129409daf8e1a71 Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Sun, 6 Feb 2011 23:58:35 +0000
Subject: [PATCH] PostgreSQL Weekly News February 06, 2011

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

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index b36e8d4d..dfd4daab 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 February 6th 2011</title>
+<description>
+Simon Riggs interviewed in O&#x27;Reilly GMT
+&#x3C;a href=&#x22;http://www.oreillygmt.eu/open-sourcefree-software/all-about-postgresql-%E2%80%93-the-world%E2%80%99s-most-advanced-open-source-database/&#x22;&#x3E;http://www.oreillygmt.eu/open-sourcefree-software/all-about-postgresql-%E2%80%93-the-world%E2%80%99s-most-advanced-open-source-database/&#x3C;/a&#x3E;
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20110206</guid>
+<pubDate>Sun, 06 Feb 2011 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News January 30th 2011</title>
 <description>
@@ -118,16 +129,5 @@ MicroOLAP Database Designer 1.3.0 for PostgreSQL released.
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20101205</guid>
 <pubDate>Sun, 05 Dec 2010 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News November 28th 2010</title>
-<description>
-PostgreDAC 2.6.0, a Delphi/C++ builder for PostgreSQL, released.
-&#x3C;a href=&#x22;http://microolap.com/products/connectivity/postgresdac/download/&#x22;&#x3E;http://microolap.com/products/connectivity/postgresdac/download/&#x3C;/a&#x3E;
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20101128</guid>
-<pubDate>Sun, 28 Nov 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 177e6c57..2440ffe4 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/pwn20110206">February 6th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110130">January 30th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110123">January 23rd 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110116">January 16th 2011</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20110206.html b/portal/template/en/community/weeklynews/pwn20110206.html
new file mode 100644
index 00000000..3860568e
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20110206.html
@@ -0,0 +1,741 @@
+<!-- BEGIN page_title_block -->
+Weekly News - February 06 2011
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - February 06 2011</h1>
+
+<p>
+Simon Riggs interviewed in O'Reilly GMT
+<a href="http://www.oreillygmt.eu/open-sourcefree-software/all-about-postgresql-%E2%80%93-the-world%E2%80%99s-most-advanced-open-source-database/">http://www.oreillygmt.eu/open-sourcefree-software/all-about-postgresql-%E2%80%93-the-world%E2%80%99s-most-advanced-open-source-database/</a>
+</p>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+PGSI 1.6.0, a tool which reports overall impact of PostgreSQL queries
+on a server, released:
+<a href="http://bucardo.org/wiki/Pgsi">http://bucardo.org/wiki/Pgsi</a>
+</p>
+
+<h2>PostgreSQL Jobs for February</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2011-02/threads.php">http://archives.postgresql.org/pgsql-jobs/2011-02/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+Selena Deckelmann will be speaking on PostgreSQL Community and
+Development February 7, 2010, 4pm at Oregon State University in
+Corvallis, OR.
+</p>
+
+<p>
+The fourth annual Prague PostgreSQL Developers' Day will be held
+February 10, 2011 at Charles University in Prague.
+<a href="http://www.p2d2.cz">http://www.p2d2.cz</a>
+</p>
+
+<p>
+NYPUG is having a meetup on February 15, 2011 at 6:15PM at the Yodle
+offices on 50 W 23rd St, New York, NY.  More info and RSVP at:
+<a href="http://www.meetup.com/postgresql-3/events/16123790/">http://www.meetup.com/postgresql-3/events/16123790/</a>
+</p>
+
+<p>
+PGDay is scheduled at this year's Southern California Linux Exposition
+(SCALE) held in the LAX Hilton Hotel in the city of Los Angeles,
+California, on Friday February 25th, 2011.
+</p>
+
+<p>
+PostgreSQL Conference East 2011: NYC March 22nd - 25th
+<a href="http://www.postgresqlconference.org">http://www.postgresqlconference.org</a>
+</p>
+
+<p>
+Open Database Camp will be on May 7-9, 2011 in Sardinia, Italy
+<a href="http://datacharmer.blogspot.com/2011/01/announcing-open-database-camp-sardinia.html">http://datacharmer.blogspot.com/2011/01/announcing-open-database-camp-sardinia.html</a>
+</p>
+
+<p>
+PGCon will be May 19-20, 2011 at the University of Ottawa, preceded by
+two days of tutorials on May 17-18.  The Call for Papers is open!
+<a href="http://www.pgcon.org/2011/">http://www.pgcon.org/2011/</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
+</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>Reviews</h2>
+<h2>Applied Patches</h2>
+<p>
+Heikki Linnakangas pushed:
+</p>
+
+<p>
+- Support multiple concurrent pg_basebackup backups.  With this patch,
+  pg_basebackup doesn't write a backup_label file in the data
+  directory, so it doesn't interfere with a pg_start/stop_backup()
+  based backup anymore. backup_label is still included in the backup,
+  but it is injected directly into the tar stream.  Heikki
+  Linnakangas, reviewed by Fujii Masao and Magnus Hagander.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=997b48ed96c476650f87ca75d65c9fc1f6273f5a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=997b48ed96c476650f87ca75d65c9fc1f6273f5a</a>
+</p>
+
+<p>
+- Fix typo.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=32866837f005fcfdd1e1289f08a89a7c519da000">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=32866837f005fcfdd1e1289f08a89a7c519da000</a>
+</p>
+
+<p>
+- Remove spurious word, spotted by Thom Brown.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=44df84df72b5eb43384bc7288713c2f80db7273d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=44df84df72b5eb43384bc7288713c2f80db7273d</a>
+</p>
+
+<p>
+Bruce Momjian pushed:
+</p>
+
+<p>
+- Move upgrade instructions into its own section under "Server Setup
+  and Operation", merged from upgrade sections in "Installation from
+  Source Code" and "Backup and Restore".  This now gives a single
+  place for all upgrade information.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c5ba11f8fb1701441b96a755ea410b96bfe36170">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c5ba11f8fb1701441b96a755ea410b96bfe36170</a>
+</p>
+
+<p>
+- Fix SGML markup for upgrade doc addition.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ff20fbd6c21929cd5c78f154c8364ce746de9c03">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ff20fbd6c21929cd5c78f154c8364ce746de9c03</a>
+</p>
+
+<p>
+- Update pg_upgrade docs to mention its use in a less risk-warning
+  way, and update the pg_upgrade docs to mention its reliance on no
+  changes to the storage format (the later based on Robert Haas's
+  patch).
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=49450f01eca39308989cf668f60b7c345e72fc7b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=49450f01eca39308989cf668f60b7c345e72fc7b</a>
+</p>
+
+<p>
+- Fix pg_upgrade to create pg_authid restore functions in the
+  'postgres' database, not in the os-user database, per report from
+  Magnus.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6238473adb119a5a11061e40e159e8c5187fe492">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6238473adb119a5a11061e40e159e8c5187fe492</a>
+</p>
+
+<p>
+- In pg_authid.rolpassword docs, make "md5" appear as a literal.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2dbed56c5a86d45a66f41e6a8a16295bbfe46646">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2dbed56c5a86d45a66f41e6a8a16295bbfe46646</a>
+</p>
+
+<p>
+- Improve docs for pg_authid encryption description with better markup
+  and a mention of unencrypted passwords.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=00dd340210ed67900e03703eb088fdd5ab12c099">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=00dd340210ed67900e03703eb088fdd5ab12c099</a>
+</p>
+
+<p>
+- Add pg_upgrade comment for why we can't use template1 inheritance
+  for the support functions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2bb87a61a84ab74b7ba820aac787443a78897bf4">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2bb87a61a84ab74b7ba820aac787443a78897bf4</a>
+</p>
+
+<p>
+- Add missing period "." in pg_upgrade documentation.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d2888d1ca36c266900eeea95401269c782074251">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d2888d1ca36c266900eeea95401269c782074251</a>
+</p>
+
+<p>
+- Clarify pg_upgrade install instructions, per suggestion from Robert Haas.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=902aae5ec58f71b8d9f7efb5ed474d0f5439439d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=902aae5ec58f71b8d9f7efb5ed474d0f5439439d</a>
+</p>
+
+<p>
+- Document that Slony can do upgrades easier _because_ it supports
+  replication between different Postgres major versions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e8cdc238cfa3fda4185fe6a9826dbdf0a107f789">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e8cdc238cfa3fda4185fe6a9826dbdf0a107f789</a>
+</p>
+
+<p>
+- Document that effective cache size does not assume data remains in
+  the cache between queries.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c6e6f7fd3ffa984a202b910ef3237e26f9d3c2e">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c6e6f7fd3ffa984a202b910ef3237e26f9d3c2e</a>
+</p>
+
+<p>
+- Clarify documentation to state that "zero_damaged_pages" does not
+  force data to disk, so the table or index should be recreated before
+  the parameter is turned off again.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7106f74e2a6feb31c022dd98e7d93ab656dc079d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7106f74e2a6feb31c022dd98e7d93ab656dc079d</a>
+</p>
+
+<p>
+- Properly capitalize hyphenated words in documentation titles.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d56d246e70184692408cd6a444e6824ae8491587">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d56d246e70184692408cd6a444e6824ae8491587</a>
+</p>
+
+<p>
+- Document that CREATE VIEW that uses "*" for the column list will not
+  auto-add columns later added to the base table.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5a6ba62be5364dbf973fd9b8631fd60acda03440">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5a6ba62be5364dbf973fd9b8631fd60acda03440</a>
+</p>
+
+<p>
+- Simplify pg_upgrade checking of executable permissions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9d220fc17eafcbc99fcea7bdbbb246fee473eac7">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9d220fc17eafcbc99fcea7bdbbb246fee473eac7</a>
+</p>
+
+<p>
+- Fix wrong verb in pg_upgrade text message, per Robert Haas.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2b6e2dee7805ec5b477af00c01c54c208bf106eb">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2b6e2dee7805ec5b477af00c01c54c208bf106eb</a>
+</p>
+
+<p>
+- Mark all GUC variables with <varname> markup, rather than <literal>.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03c25dd900d97c0868ad20b925a78d41ec603578">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03c25dd900d97c0868ad20b925a78d41ec603578</a>
+</p>
+
+<p>
+- Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is a
+  path variable, not a directory path.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=bffb638d16999ee7d3c8796e77dd87ac82719c7d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=bffb638d16999ee7d3c8796e77dd87ac82719c7d</a>
+</p>
+
+<p>
+- Rename function to first_path_var_separator() to clarify it works
+  with path variables, not directory paths.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=426227850be145b52cb610455000fc005df5ce4e">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=426227850be145b52cb610455000fc005df5ce4e</a>
+</p>
+
+<p>
+- Simplify code used in is_absolute_path() macro;  also add comment
+  about 'E:abc' Win32 path handling.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=35b0a6b205c25d592b966aa17d3c6f9e5a88eb62">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=35b0a6b205c25d592b966aa17d3c6f9e5a88eb62</a>
+</p>
+
+<p>
+- In docs, PL is Procedural Language, not Programming Language.
+  Satoshi Nagayasu.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=df63aac678343cec522bc58588b70ab1374a6c93">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=df63aac678343cec522bc58588b70ab1374a6c93</a>
+</p>
+
+<p>
+- ALTER TABLE sometimes takes only ShareUpdateExclusiveLock.  Along
+  the way, be more consistent about the wording we use here.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7212c77d0cabcc468fec0b9cd7f2413b64b77050">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7212c77d0cabcc468fec0b9cd7f2413b64b77050</a>
+</p>
+
+<p>
+- In docs, move PQrequestCancel() deprecation mention up to match
+  other libpq doc mentions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b157a1d5554d6dfbd13fb605f08d51ce17532375">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b157a1d5554d6dfbd13fb605f08d51ce17532375</a>
+</p>
+
+<p>
+- Add doc comment that installation.sgml can't use xrefs.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8e6ae3d79c16ad8876c34f2cff8d667ca1cffb09">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8e6ae3d79c16ad8876c34f2cff8d667ca1cffb09</a>
+</p>
+
+<p>
+- Add C comment about why older compilers complain about
+  basebackup.c's longjump.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51dbc87dff5c32bfe627ec7b22c575c263de8251">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51dbc87dff5c32bfe627ec7b22c575c263de8251</a>
+</p>
+
+<p>
+- Rename macro DECIMAL to DECIMAL_T to help pgindent;  this is already
+  done for a few other macros in that file, for other reasons.  I also
+  remove pgindent/README mention of the file.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=97116ca4170b974d734cea364789c389b30e6ce1">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=97116ca4170b974d734cea364789c389b30e6ce1</a>
+</p>
+
+<p>
+- Adjust libpq docs to be clearer about 'hostaddr' usage by rewording
+  and using an itemized list.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5ed45ac09c604555740e7365a722b641f3bce498">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5ed45ac09c604555740e7365a722b641f3bce498</a>
+</p>
+
+<p>
+Andrew Dunstan pushed:
+</p>
+
+<p>
+- Update docs on building for Windows to accomodate current reality.
+  Document how to build 64 bit Windows binaries using the MinGW64 tool
+  set.  Remove recommendation against using Mingw as a build platform.
+  Be more specific about when Cygwin is useful and when it's not,  in
+  particular note its usefulness for running psql, and add a note
+  about building on Cygwin in non-C locales.  Per recent discussions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51be78b09a83b8d533e4a9f81cf9a7f2edde6654">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=51be78b09a83b8d533e4a9f81cf9a7f2edde6654</a>
+</p>
+
+<p>
+- Set up PLPerl trigger data using C code instead of Perl code.  This
+  is an efficiency change, and means we now no longer have to run "out
+  $_TD; local $_TD = shift;", which was especially pointless in the
+  case of non-trigger functions where the passed value was always
+  undef anyway.  A tiny open issue is whether we should get rid of the
+  $prolog argument of mkfunc, and the corresponding pushed value,
+  which is now just a constant "false".  Tim Bunce, reviewed by Alex
+  Hunsaker.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ef19dc6d39dd2490ff61489da55d95d6941140bf">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ef19dc6d39dd2490ff61489da55d95d6941140bf</a>
+</p>
+
+<p>
+- Add  comment on why we're passing a useless 'false' to the plperl
+  function compiler.  It's for compatibility with modules like
+  PostgreSQL::PLPerl::NYTProf.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c73fe72e2735d20aa132640d8fab4e0eca1ced95">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c73fe72e2735d20aa132640d8fab4e0eca1ced95</a>
+</p>
+
+<p>
+- Attempt to unbreak MSVC builds after pipe.c move.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=895ad83d702ed821f72ec7bdf1fba3db7da9d9d7">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=895ad83d702ed821f72ec7bdf1fba3db7da9d9d7</a>
+</p>
+
+<p>
+- Force strings passed to and from plperl to be in UTF8 encoding.
+  String are converted to UTF8 on the way into perl and to the
+  database encoding on the way back. This avoids a number of observed
+  anomalies, and ensures Perl a consistent view of the world.  Some
+  minor code cleanups are also accomplished.  Alex Hunsaker, reviewed
+  by Andy Colson.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=50d89d422f9c68a52a6964e5468e8eb4f90b1d95">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=50d89d422f9c68a52a6964e5468e8eb4f90b1d95</a>
+</p>
+
+<p>
+Simon Riggs pushed:
+</p>
+
+<p>
+- Fix error code for canceling statement due to conflict with
+  recovery.  All retryable conflict errors now have an error code that
+  indicates that a retry is possible, correcting my incomplete fix of
+  2010/05/12 Tatsuo Ishii and Simon Riggs, input from Robert Haas and
+  Florian Pflug
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8585ad36254199ca63700707ee78890da1755e4d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8585ad36254199ca63700707ee78890da1755e4d</a>
+</p>
+
+<p>
+- Create new errcode for recovery conflict caused by db drop on
+  master.  Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is
+  now reported as ERRCODE_T_R_DATABASE_DROPPED. No message text
+  change.  Unlikely to happen on most servers, so low impact change to
+  allow session poolers to correctly handle this situation.  Tatsuo
+  Ishii, edits by me, review by Robert Haas.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9e95c9ad558bafa26efbab50f77929de4ade5f90">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9e95c9ad558bafa26efbab50f77929de4ade5f90</a>
+</p>
+
+<p>
+- Re-classify ERRCODE_DATABASE_DROPPED to 57P04
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56b21b7ae38bc1efb701e7ebfd208e2e194e7998">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56b21b7ae38bc1efb701e7ebfd208e2e194e7998</a>
+</p>
+
+<p>
+Tom Lane pushed:
+</p>
+
+<p>
+- Prevent buffer overrun while parsing an integer in a "query_int"
+  value.  contrib/intarray's gettoken() uses a fixed-size buffer to
+  collect an integer's digits, and did not guard against overrunning
+  the buffer.  This is at least a backend crash risk, and in principle
+  might allow arbitrary code execution.  The code didn't check for
+  overflow of the integer value either, which while not presenting a
+  crash risk was still bad.  Thanks to Apple Inc's security team for
+  reporting this issue and supplying the fix.  Security: CVE-2010-4015
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7ccb6dc2d3e266a551827bb99179708580f72431">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7ccb6dc2d3e266a551827bb99179708580f72431</a>
+</p>
+
+<p>
+- Update release notes.  Security: CVE-2010-4015
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=43054624979de3205fbc432f15defd4b9d5922e9">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=43054624979de3205fbc432f15defd4b9d5922e9</a>
+</p>
+
+<p>
+- Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.
+  Unlike Btree-based LIKE optimization, this works for
+  non-left-anchored search patterns.  The effectiveness of the search
+  depends on how many trigrams can be extracted from the pattern.
+  (The worst case, with no trigrams, degrades to a full-table scan, so
+  this isn't a panacea.  But it can be very useful.) Alexander
+  Korotkov, reviewed by Jan Urbanski.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6e2f3ae8842392c46ccc91a9ce4bba92296890cb">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6e2f3ae8842392c46ccc91a9ce4bba92296890cb</a>
+</p>
+
+<p>
+- Clean up missed change to plpython expected files.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=907855ac759a221f95b502cd7cbf2ec851fe9523">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=907855ac759a221f95b502cd7cbf2ec851fe9523</a>
+</p>
+
+<p>
+- Repair multiple breakage in Windows-specific code for appending '.exe'.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=cd7d748d51df3c5dedcc49a3603e6fa9c050f237">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=cd7d748d51df3c5dedcc49a3603e6fa9c050f237</a>
+</p>
+
+<p>
+ITAGAKI Takahiro pushed:
+</p>
+
+<p>
+- Add a link from client_encoding parameter to the list of character
+  sets in documentation.  Thom Brown
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03282bfa8973f3a77ca3e7c14847a5a11d07d6a2">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=03282bfa8973f3a77ca3e7c14847a5a11d07d6a2</a>
+</p>
+
+<p>
+- Fix wrong error reports in 'number of array dimensions exceeds the
+  maximum allowed' messages, that have reported one-less dimensions.
+  Alexey Klyukin
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0c707aa4583a5584f4c3f4ad1697bb206ed0d65a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0c707aa4583a5584f4c3f4ad1697bb206ed0d65a</a>
+</p>
+
+<p>
+Magnus Hagander pushed:
+</p>
+
+<p>
+- Undefine setlocale() macro on Win32.  New versions of libintl
+  redefine setlocale() to a macro which causes problems when the
+  backend and libintl are linked against different versions of the
+  runtime, which is often the case in msvc builds.  Hiroshi Inoue,
+  slightly updated comment by me
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5273f2143416f6340f6ee876facfa6f7a87453a0">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5273f2143416f6340f6ee876facfa6f7a87453a0</a>
+</p>
+
+<p>
+- Fix typo.  Thom Brown
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f001cb38b67b0f2f5f4cfd1e32f86866da8c8693">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f001cb38b67b0f2f5f4cfd1e32f86866da8c8693</a>
+</p>
+
+<p>
+- Include more status information in walsender results.  Add the
+  current xlog insert location to the response of IDENTIFY_SYSTEM, and
+  adds result sets containing start and stop location of backups to
+  BASE_BACKUP responses.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=76129e7f14b4605db0a046e13abef0e255ffe007">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=76129e7f14b4605db0a046e13abef0e255ffe007</a>
+</p>
+
+<p>
+- Use single quotes when there are backslashes in the filename.  In
+  the hope of unbreaking the buildfarm
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=39fbec73b0dd15df8955baad57685082ec0cef8f">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=39fbec73b0dd15df8955baad57685082ec0cef8f</a>
+</p>
+
+<p>
+- Attempt to un-break the documentation build again Another case of
+  <xref linkend> in the documentation that builds INSTALL, which is
+  not allowed.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=afb6dee1e3b93af05e35873c19c068e8ac7eb74b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=afb6dee1e3b93af05e35873c19c068e8ac7eb74b</a>
+</p>
+
+<p>
+- IDENTIFY_SYSTEM now returns 3 fields, not 2
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=cedd6515ba68f46dd7e75a65d4c98330ced0ba7a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=cedd6515ba68f46dd7e75a65d4c98330ced0ba7a</a>
+</p>
+
+<p>
+Peter Eisentraut pushed:
+</p>
+
+<p>
+- Add validator to PL/Python.  Jan Urbański, reviewed by Hitoshi
+  Harada
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=15f55cc38a82dfa3d7898a7c30a303b1b3e87dc3">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=15f55cc38a82dfa3d7898a7c30a303b1b3e87dc3</a>
+</p>
+
+<p>
+- Wrap PL/Python SPI calls into subtransactions.  This allows the
+  language-specific try/catch construct to catch and handle exceptions
+  arising from SPI calls, matching the behavior of other PLs.  As an
+  additional bonus you no longer get all the ugly "unrecognized error
+  in PLy_spi_execute_query" errors.  Jan Urbański, reviewed by Steve
+  Singer
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0c5933d0104c1788479592a84cca53da357381f9">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0c5933d0104c1788479592a84cca53da357381f9</a>
+</p>
+
+<p>
+Robert Haas pushed:
+</p>
+
+<p>
+- Log restartpoints in the same fashion as checkpoints.  Prior to 9.0,
+  restartpoints never created, deleted, or recycled WAL files, but now
+  they can.  This code makes log_checkpoints treat checkpoints and
+  restartpoints symmetrically.  It also adjusts up the documentation
+  of the parameter to mention restartpoints.  Fujii Masao.  Docs by
+  me, as suggested by Itagaki Takahiro.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0af695fd43b6889613a4035e3cdfcc0fc1b7936a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0af695fd43b6889613a4035e3cdfcc0fc1b7936a</a>
+</p>
+
+<p>
+- Various sepgsql corrections.  KaiGai Kohei
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c7689ee73346d198177dee538501bb1148c8cebb">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c7689ee73346d198177dee538501bb1148c8cebb</a>
+</p>
+
+<p>
+- Minor sepgsql regression test fixes.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=87d967f70f4866c17404f6a9b8062f892ed31e08">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=87d967f70f4866c17404f6a9b8062f892ed31e08</a>
+</p>
+
+<p>
+- sepgsql doc fix.  KaiGai Kohei
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4ff9dec1386b714f6c26a52ca6880b14e94dd1db">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4ff9dec1386b714f6c26a52ca6880b14e94dd1db</a>
+</p>
+
+<p>
+- Further sepgsql documentation cleanup.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4c4daf671074cc64290e9255c14365b55bf7a47b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4c4daf671074cc64290e9255c14365b55bf7a47b</a>
+</p>
+
+<p>
+- Avoid maintaining three separate copies of the error codes list.
+  src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a
+  big chunk of errcodes.sgml are now automatically generated from a
+  single file, src/backend/utils/errcodes.txt.  Jan Urbański, reviewed
+  by Tom Lane.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ddfe26f6441c24660595c5efe5fd0bd3974cdc5c">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ddfe26f6441c24660595c5efe5fd0bd3974cdc5c</a>
+</p>
+
+<p>
+- Preserve copyright notice from old errcodes.h file.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b8a0467e10a41d32ecf889d40de81223e0439c5b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b8a0467e10a41d32ecf889d40de81223e0439c5b</a>
+</p>
+
+<p>
+- Unbreak the VPATH build.  My commit
+  ddfe26f6441c24660595c5efe5fd0bd3974cdc5c of 2010-02-03 broke it.
+  Per buildfarm.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=dde9684d65ed66656f765d3fd97f2e522a189132">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=dde9684d65ed66656f765d3fd97f2e522a189132</a>
+</p>
+
+<p>
+- Unbreak 'configure' followed immediately by 'make install'.  More
+  fallout from ddfe26f6441c24660595c5efe5fd0bd3974cdc5c.  Report by
+  Fujii Masao.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b87811ee273360c45d92b0e7bb7e67670312c221">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b87811ee273360c45d92b0e7bb7e67670312c221</a>
+</p>
+
+<p>
+- Make handling of errcodes.h more consistent with other generated
+  headers.  This fixes make distprep, and seems more robust in other
+  ways as well.  Some special handling is required because
+  errcodes.txt is needed by some stuff in src/port, but just by
+  src/backend as is the case for the other generated headers.  While
+  I'm at it, fix a few other things that were overlooked in the
+  original patch.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=356f2cbbb42811596820c94aaec2e32ad1ec58d8">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=356f2cbbb42811596820c94aaec2e32ad1ec58d8</a>
+</p>
+
+<p>
+- Use $(MAKE) rather than make.  Per buildfarm.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6f59a5e5dd73ec2c448dd7038accf5aaba6dc04b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6f59a5e5dd73ec2c448dd7038accf5aaba6dc04b</a>
+</p>
+
+<p>
+- Update ALTER TABLE docs to mention using VACUUM FULL for rewrites.
+  Remove the claim that ALTER TABLE .. SET DATA TYPE is the fastest
+  way of rewriting a table, since it no longer is.  Noah Misch and
+  Robert Haas, based on a suggestion from Tom Lane.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=edad08ba545b43261b4d54d65122b45c9b5ee801">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=edad08ba545b43261b4d54d65122b45c9b5ee801</a>
+</p>
+
+<p>
+- Avoid including postgres.h in frontend compiles of src/port.  This
+  isn't kosher, and doesn't play nicely with my recent changes to the
+  Makefile in this directory.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8201aea90c2b171808c65836fcce4f29b22a9dbb">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=8201aea90c2b171808c65836fcce4f29b22a9dbb</a>
+</p>
+
+<p>
+- Move pipe.c into the backend.  It's full of backend-specific error
+  reporting, so it's neither possible nor necessary for this to be
+  used from frontend code.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b1e65c32168a2b64276a57be8c4dc5a63d33e12d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b1e65c32168a2b64276a57be8c4dc5a63d33e12d</a>
+</p>
+
+<p>
+- Clarify comment in ATRewriteTable().  Make sure it's clear that the
+  prohibition on adding a column with a default when the rowtype is
+  used elsewhere is intentional, and be a bit more explicit about the
+  other cases where we perform this check.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9e7e1172a53054dc14574e42865ea8213bc06371">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9e7e1172a53054dc14574e42865ea8213bc06371</a>
+</p>
+
+<p>
+- Tighten ALTER FOREIGN TABLE .. SET DATA TYPE checks.  If the foreign
+  table's rowtype is being used as the type of a column in another
+  table, we can't just up and change its data type.  This was already
+  checked for composite types and ordinary tables, but we previously
+  failed to enforce it for foreign tables.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=65377e0b9c0e0397b1598b38b6a7fb8b6f740d39">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=65377e0b9c0e0397b1598b38b6a7fb8b6f740d39</a>
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Greg Smith sent in another revision of the patch to do spread
+checkpoint syncs.
+</p>
+
+<p>
+Marko (johto) Tiikkaja sent in another revision of the patch to add
+transaction-scoped advisory locks.
+</p>
+
+<p>
+Joachim Wieland sent in another revision of that patch to do parallel
+pg_dump using a new directory-based format.
+</p>
+
+<p>
+Simon Riggs sent in a patch to add a FORCE option to DROP DATABASE.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in another revision of the patch to add
+MULTISETs.
+</p>
+
+<p>
+Fujii Masao sent in a patch to change pg_stop_backup so that it only
+creates the backup history file if archiving is enabled.
+</p>
+
+<p>
+Alexey Klyukin sent in another revision of the patch to transform
+between PostgreSQL arrays and Perl arrays in PL/Perl.
+</p>
+
+<p>
+Hitoshi Harada sent in three more revisions of the patch to add
+ENCODING to COPY.
+</p>
+
+<p>
+Euler Taveira de Oliveira sent in another revision of the patch to add
+named restore points.
+</p>
+
+<p>
+Peter Eisentraut sent in another revision of the patch to add
+per-column collations.
+</p>
+
+<p>
+ITAGAKI Takahiro and Dimitri Fontaine traded patches to add support
+for EXTENSIONs to pg_dump.
+</p>
+
+<p>
+Kevin Grittner sent in another revision of the patch to add
+SSI (serializable snapshot isolation).
+</p>
+
+<p>
+Heikki Linnakangas sent in a patch to add regression tests for SSI.
+</p>
+
+<p>
+YAMAMOTO Takahashi sent in another revision of the patch to avoid
+de-TOAST'ing large objects.
+</p>
+
+<p>
+Andrew Dunstan sent in a patch to the docs to describe how to build
+PostgreSQL for Win64 using certain toolkits.
+</p>
+
+<p>
+Dimitri Fontaine sent in another revision of the ALTER EXTENSION
+patch.
+</p>
+
+<p>
+Tomas Vondra and Greg Smith traded patches to keep the timestamp of
+the latest stats reset.
+</p>
+
+<p>
+Magnus Hagander sent in three revisions of a patch to move the WAL
+warning.
+</p>
+
+<p>
+Bruce Momjian sent in a patch to simplifiy the pg_upgrade executable
+checks per suggestion from Robert Haas.
+</p>
+
+<p>
+Robert Haas sent in another revision of the patch to limit hint bit
+I/O.
+</p>
+
+<p>
+Bruce Momjian sent in two more revisions of the patch to fix
+is_absolute_path on Windows.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in a patch to implement a jagged row CSV API, to
+be applied atop Andrew Dunstan's patch to expose the COPY API.
+</p>
+
+<p>
+Thom Brown sent in a patch to fix an issue where generate_series()
+misbehaved by returning if the series hits either the upper or lower
+boundary during increment, or goes beyond it, none of which should
+happen.
+</p>
+
+<p>
+Jan Urbanski sent in another flock of patches to improve PL/Python.
+</p>
+
+<p>
+Robert Haas sent in another revision of the patch to skip table
+rewrites in cases where it can be proven that this will not actually
+change anything when someone issues an ALTER TABLE.
+</p>
+
+<p>
+Alex Hunsaker sent in another revision of the patch to convert
+between PostgreSQL arrays an Perl arrays in PL/Perl.
+</p>
+
+<p>
+Stephen Frost sent in another revision of the patch to allow logging
+the current role.
+</p>
+
+<p>
+Jeff Davis sent in another revision of the patch to add range types.
+</p>
+
+<p>
+Simon Riggs sent in a patch to fix commit performance in SAVEPOINTs,
+which had O(n^2) behavior.
+</p>
+
+<p>
+Bruce Momjian sent in a doc patch for Streaming Replication.
+
+</p>
+
-- 
2.39.5