From 532cff30efaf391ac6877bfb39adef135f18d944 Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Mon, 12 Sep 2011 07:56:10 +0000
Subject: [PATCH] PostgreSQL Weekly News September 11, 2011

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

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index d5696bdd..a496e410 100644
--- a/portal/files/weeklynews.xml
+++ b/portal/files/weeklynews.xml
@@ -10,6 +10,21 @@
 <description></description>
 <language>en</language>
 
+<item>
+<title>PostgreSQL Weekly News September 11th 2011</title>
+<description>
+The Call for Papers for is open for FLOSS UK, which will be held in
+Edinburgh from the 20th to the 22nd March 2012.  The deadline for
+proposals is the 18th November 2011 and selected speakers will be
+notified by the 25th November 2011.  Proposals should be submitted to
+postgresql2012 AT flossuk DOT org.  More information at:
+&#x3C;a href=&#x22;http://www.flossuk.org/Events/Spring2012&#x22;&#x3E;http://www.flossuk.org/Events/Spring2012&#x3C;/a&#x3E;
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20110911</guid>
+<pubDate>Sun, 11 Sep 2011 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News September 4th 2011</title>
 <description>
@@ -116,16 +131,5 @@ after today Last Minute tickets only (&#xC2;&#xA3;425).
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20110703</guid>
 <pubDate>Sun, 03 Jul 2011 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News June 26th 2011</title>
-<description>
-MicroOLAP Database Designer 1.8.0 for PostgreSQL released.
-&#x3C;a href=&#x22;http://microolap.com/products/database/postgresql-designer/&#x22;&#x3E;http://microolap.com/products/database/postgresql-designer/&#x3C;/a&#x3E;
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20110626</guid>
-<pubDate>Sun, 26 Jun 2011 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 9ff9de38..16f5bd2e 100644
--- a/portal/template/en/community/weeklynews.html
+++ b/portal/template/en/community/weeklynews.html
@@ -11,6 +11,7 @@ Weekly News
 <p>Here is the <a href="http://www.postgresql.org/files/weeklynews.xml">RSS feed</a>.</p>
 
 <ul>
+    <li><a href="/community/weeklynews/pwn20110911">September 11th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110904">September 4th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110828">August 28th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110821">August 21st 2011</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20110911.html b/portal/template/en/community/weeklynews/pwn20110911.html
new file mode 100644
index 00000000..949716d0
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20110911.html
@@ -0,0 +1,618 @@
+<!-- BEGIN page_title_block -->
+Weekly News - September 11 2011
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - September 11 2011</h1>
+
+<p>
+The Call for Papers for is open for FLOSS UK, which will be held in
+Edinburgh from the 20th to the 22nd March 2012.  The deadline for
+proposals is the 18th November 2011 and selected speakers will be
+notified by the 25th November 2011.  Proposals should be submitted to
+postgresql2012 AT flossuk DOT org.  More information at:
+<a href="http://www.flossuk.org/Events/Spring2012">http://www.flossuk.org/Events/Spring2012</a>
+</p>
+
+<p>
+New Survey: When do you plan to upgrade to 9.1?
+<a href="http://www.postgresql.org/community">http://www.postgresql.org/community</a>
+</p>
+
+<p>
+NYCPUG presents "PostgreSQL 9.1 Overview" with Bruce Momjian at
+6:30pm September 22, 2011 at Yodle.  RSVP and details below.
+<a href="http://www.nycpug.org/events/32571952/">http://www.nycpug.org/events/32571952/</a>
+</p>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+pgpool-II 3.1.0, a connection pooler and more, released.
+<a href="http://pgfoundry.org/projects/pgpool/">http://pgfoundry.org/projects/pgpool/</a>
+</p>
+
+<p>
+xlogdump 0.4.0, a tool for extracting data from WAL segment files, released.
+<a href="https://github.com/snaga/xlogdump">https://github.com/snaga/xlogdump</a>
+</p>
+
+<h2>PostgreSQL Jobs for September</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2011-09/threads.php">http://archives.postgresql.org/pgsql-jobs/2011-09/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+Postgres Open 2011, a conference focused on disruption of the database
+industry through PostgreSQL, will take place September 14-16, 2011 in
+Chicago, Illinois at the Westin Michigan Avenue hotel.
+<a href="http://postgresopen.org">http://postgresopen.org</a>
+</p>
+
+<p>
+PostgreSQL Conference West (#PgWest) will be held September 27th-30th,
+2011 at the San Jose Convention center in San Jose, California, USA.
+<a href="http://www.postgresqlconference.org">http://www.postgresqlconference.org</a>
+</p>
+
+<p>
+PostgreSQL Conference Europe 2011 will be held on October 18-21 in
+Amsterdam.
+<a href="http://2011.pgconf.eu/">http://2011.pgconf.eu/</a>
+</p>
+
+<p>
+PG-Day Denver 2011 will be held on Friday, October 21st, 2011 at
+the Auraria Campus near downtown Denver, Colorado.
+<a href="http://pgday.consistentstate.com/">http://pgday.consistentstate.com/</a>
+</p>
+
+<p>
+pgbr will be in Sao Paulo, Brazil November 3-4, 2011.
+<a href="http://pgbr.postgresql.org.br/">http://pgbr.postgresql.org.br/</a>
+</p>
+
+<p>
+PGConf.DE 2011 is the German-speaking PostgreSQL Conference and will
+take place on November 11th in the Rheinisches Industriemuseum in
+Oberhausen, Germany.  Call for Papers is open.
+<a href="http://2011.pgconf.de/">http://2011.pgconf.de/</a>
+</p>
+
+<p>
+The fifth edition of the Italian PostgreSQL Day (PGDay.IT 2011) will
+be held on November 25, 2011 in Prato, Italy.
+<a href="http://2011.pgday.it/">http://2011.pgday.it/</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
+</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>
+Bruce Momjian pushed:
+</p>
+
+<p>
+- Document that contrib/pgtrgm only processes ASCII alphanumeric
+  characters.  Backpatch to 9.0 and 9.1.
+  <a href="http://git.postgresql.org/pg/commitdiff/d235f828d74daaabdeb97efa4499cfb30ee65d09">http://git.postgresql.org/pg/commitdiff/d235f828d74daaabdeb97efa4499cfb30ee65d09</a>
+</p>
+
+<p>
+- Add mention that UTC really means UT1.  Backpatch to 9.1.
+  <a href="http://git.postgresql.org/pg/commitdiff/7cb99b269667ef3d8869bc9f7681debc12c45b1d">http://git.postgresql.org/pg/commitdiff/7cb99b269667ef3d8869bc9f7681debc12c45b1d</a>
+</p>
+
+<p>
+- Add C comment about why we send cache invalidation messages for
+  session-local objects.
+  <a href="http://git.postgresql.org/pg/commitdiff/f458c90bff45ecae91fb55ef2b938af37d977af3">http://git.postgresql.org/pg/commitdiff/f458c90bff45ecae91fb55ef2b938af37d977af3</a>
+</p>
+
+<p>
+- Add documentation link to strftime supported options.
+  <a href="http://git.postgresql.org/pg/commitdiff/5c8676ea71754b5ebd4a5e4ad3ffb173ef6db32d">http://git.postgresql.org/pg/commitdiff/5c8676ea71754b5ebd4a5e4ad3ffb173ef6db32d</a>
+</p>
+
+<p>
+- Properly document semphore requirements by accounting for worker
+  processes.  Backpatch to 9.1 and 9.0.  Submitted by Anton
+  Yuzhaninov, confirmed by Robert Haas
+  <a href="http://git.postgresql.org/pg/commitdiff/d764835bbc705f38311b5a6fe14a9aff4feb6fc3">http://git.postgresql.org/pg/commitdiff/d764835bbc705f38311b5a6fe14a9aff4feb6fc3</a>
+</p>
+
+<p>
+- Document PERFORM limitation when using WITH queries.  Backpatch to
+  9.0 and 9.1.  Report from Dmitry Epstein.
+  <a href="http://git.postgresql.org/pg/commitdiff/6f94280dee9f8b6c511f00a50531b981faa73b54">http://git.postgresql.org/pg/commitdiff/6f94280dee9f8b6c511f00a50531b981faa73b54</a>
+</p>
+
+<p>
+- Fix plpgsql "PERFORM" markup.  Backpatch to 9.0 and 9.1.
+  <a href="http://git.postgresql.org/pg/commitdiff/ba3de10c4ea3c70d4e36181e563a4ebffaf4e022">http://git.postgresql.org/pg/commitdiff/ba3de10c4ea3c70d4e36181e563a4ebffaf4e022</a>
+</p>
+
+<p>
+- Add documentation suggestion about adding a comment to the top of
+  pgpass.  Backpatch to 9.1.
+  <a href="http://git.postgresql.org/pg/commitdiff/a25fc9edcb6b1ed589d9767b4b8c1cdae21c3cc3">http://git.postgresql.org/pg/commitdiff/a25fc9edcb6b1ed589d9767b4b8c1cdae21c3cc3</a>
+</p>
+
+<p>
+- Fix spelling mistake in pgpass documentation change.  Per Peter
+  Eisentraut.
+  <a href="http://git.postgresql.org/pg/commitdiff/d858abfdfdcfb11c5eff08c8368c27a3f66964d2">http://git.postgresql.org/pg/commitdiff/d858abfdfdcfb11c5eff08c8368c27a3f66964d2</a>
+</p>
+
+<p>
+- Properly document the existance of OLD/NEW trigger pl/pgsql trigger
+  fields.  Backpatch to 9.0 and 9.1.  Report from Pavel Stehule, patch
+  from Josh Kupershmidt
+  <a href="http://git.postgresql.org/pg/commitdiff/39039e6d7a48d37aedcfca7973cea3288ce356d4">http://git.postgresql.org/pg/commitdiff/39039e6d7a48d37aedcfca7973cea3288ce356d4</a>
+</p>
+
+<p>
+- Revert documentation patch about NEW/OLD and triggers.  Backpatch to
+  9.0 and 9.1.  Patch from Josh Kupershmidt.
+  <a href="http://git.postgresql.org/pg/commitdiff/8eacb25cbe9100b9cf441d4cbca4cec8fa5e3f52">http://git.postgresql.org/pg/commitdiff/8eacb25cbe9100b9cf441d4cbca4cec8fa5e3f52</a>
+</p>
+
+<p>
+- Fix to_date() and to_timestamp() to handle year masks of length < 4
+  so they wrap toward year 2020, rather than the inconsistent behavior
+  we had before.
+  <a href="http://git.postgresql.org/pg/commitdiff/029dfdf1157b6d837a7b7211cd35b00c6bcd767c">http://git.postgresql.org/pg/commitdiff/029dfdf1157b6d837a7b7211cd35b00c6bcd767c</a>
+</p>
+
+<p>
+- Fix bug introduced by pgrminclude where the tablespace version name
+  was not expanded.  Bump catalog version number to force initdb for
+  all tablespaces.
+  <a href="http://git.postgresql.org/pg/commitdiff/f81fb4f690355bc88fee69624103956fb4576fe5">http://git.postgresql.org/pg/commitdiff/f81fb4f690355bc88fee69624103956fb4576fe5</a>
+</p>
+
+<p>
+- Have pgrminclude skip files that use CppAsString2 because
+  CppAsString2 will expaned undefined identifiers.
+  <a href="http://git.postgresql.org/pg/commitdiff/f19593754a1b9293b098975fc43263125a40a4c3">http://git.postgresql.org/pg/commitdiff/f19593754a1b9293b098975fc43263125a40a4c3</a>
+</p>
+
+<p>
+- In pg_upgrade, disallow migration of 8.3 clusters using
+  contrib/ltree because its internal format was changed in 8.4.
+  Backpatch to 9.0 and 9.1.  Report by depesz, diagnosis by Tom.
+  <a href="http://git.postgresql.org/pg/commitdiff/3ced32d24e14af1877171c085a635b4ccdf8930c">http://git.postgresql.org/pg/commitdiff/3ced32d24e14af1877171c085a635b4ccdf8930c</a>
+</p>
+
+<p>
+- Allow bcc32 and win32 batch files to compile libpq.  Backpatch to
+  9.1.  By Hiroshi Saito
+  <a href="http://git.postgresql.org/pg/commitdiff/7b8e10f2bed1d450a9f9b211ae1b883227443912">http://git.postgresql.org/pg/commitdiff/7b8e10f2bed1d450a9f9b211ae1b883227443912</a>
+</p>
+
+<p>
+- Remove unnecessary MATCH FULL specification in example.  Reported by
+  Grzegorz Szpetkowski.
+  <a href="http://git.postgresql.org/pg/commitdiff/c79003ea4f2c40ac957457dbae24928ba255f280">http://git.postgresql.org/pg/commitdiff/c79003ea4f2c40ac957457dbae24928ba255f280</a>
+</p>
+
+<p>
+- Document that only user-defined columns are expanded by SELECT *.
+  <a href="http://git.postgresql.org/pg/commitdiff/90108c9aab51840a0fa7bcb11a2da09204d5b003">http://git.postgresql.org/pg/commitdiff/90108c9aab51840a0fa7bcb11a2da09204d5b003</a>
+</p>
+
+<p>
+- Remove double-quoting of table names in clusterdb.  BACKWARD
+  COMPABILITY BREAKAGE.  Remove double-quoting of index/table names in
+  reindexdb.  BACKWARD COMPABILITY BREAKAGE.  Document thate
+  user/database names are preserved with double-quoting by
+  command-line tools like vacuumdb.
+  <a href="http://git.postgresql.org/pg/commitdiff/d68ccf536e950a07b5a7030bf609936fe65aab51">http://git.postgresql.org/pg/commitdiff/d68ccf536e950a07b5a7030bf609936fe65aab51</a>
+</p>
+
+<p>
+Tom Lane pushed:
+</p>
+
+<p>
+- Update time zone data files to tzdata release 2011i.  DST law
+  changes in Canada, Egypt, Russia, Samoa, South Sudan.
+  <a href="http://git.postgresql.org/pg/commitdiff/0b88af150e3a26f9e41da89da0c507eac550e46b">http://git.postgresql.org/pg/commitdiff/0b88af150e3a26f9e41da89da0c507eac550e46b</a>
+</p>
+
+<p>
+- Update type-conversion documentation for long-ago changes.  This
+  example wasn't updated when we changed the behavior of bpcharlen()
+  in 8.0, nor when we changed the number of parameters taken by the
+  bpchar() cast function in 7.3.  Per report from lsliang.
+  <a href="http://git.postgresql.org/pg/commitdiff/b7f83e70d9758c5dd480c9dbba1668ddeec37916">http://git.postgresql.org/pg/commitdiff/b7f83e70d9758c5dd480c9dbba1668ddeec37916</a>
+</p>
+
+<p>
+- Add an "incompatibility" entry to 9.1 release notes about CREATE
+  EXTENSION.  We've now seen more than one gripe from somebody who
+  didn't get the memo about how to install contrib modules in 9.1.
+  Try to make it a little more prominent that you aren't supposed to
+  call the scripts directly anymore.
+  <a href="http://git.postgresql.org/pg/commitdiff/ae92eff6b93c6ee18ca5c48958c355f5a448f8f5">http://git.postgresql.org/pg/commitdiff/ae92eff6b93c6ee18ca5c48958c355f5a448f8f5</a>
+</p>
+
+<p>
+- Avoid possibly accessing off the end of memory in
+  examine_attribute().  Since the last couple of columns of pg_type
+  are often NULL, sizeof(FormData_pg_type) can be an overestimate of
+  the actual size of the tuple data part.  Therefore memcpy'ing that
+  much out of the catalog cache, as analyze.c was doing, poses a small
+  risk of copying past the end of memory and incurring SIGSEGV.  No
+  such crash has been identified in the field, but we've certainly
+  seen the equivalent happen in other code paths, so patch this one
+  all the way back.  Per valgrind testing by Noah Misch, though this
+  is not his proposed patch.  I chose to use SearchSysCacheCopy1
+  rather than inventing special-purpose infrastructure for copying
+  only the minimal part of a pg_type tuple.
+  <a href="http://git.postgresql.org/pg/commitdiff/780a342c900fa085e8c065b3282b491de69ab10d">http://git.postgresql.org/pg/commitdiff/780a342c900fa085e8c065b3282b491de69ab10d</a>
+</p>
+
+<p>
+- Avoid possibly accessing off the end of memory in SJIS2004
+  conversion.  The code in shift_jis_20042euc_jis_2004() would fetch
+  two bytes even when only one remained in the string.  Since
+  conversion functions aren't supposed to assume null-terminated
+  input, this poses a small risk of fetching past the end of memory
+  and incurring SIGSEGV.  No such crash has been identified in the
+  field, but we've certainly seen the equivalent happen in other code
+  paths, so patch this one all the way back.  Report and patch by Noah
+  Misch.
+  <a href="http://git.postgresql.org/pg/commitdiff/623f77e9d1338720512430a0b8e824d7359739b8">http://git.postgresql.org/pg/commitdiff/623f77e9d1338720512430a0b8e824d7359739b8</a>
+</p>
+
+<p>
+- Improve comment about handling of temp tables in shared-inval code.
+  <a href="http://git.postgresql.org/pg/commitdiff/db10f01baa2148f1773cacfcbadc7158ae94c081">http://git.postgresql.org/pg/commitdiff/db10f01baa2148f1773cacfcbadc7158ae94c081</a>
+</p>
+
+<p>
+- Fix get_name_for_var_field() to deal with RECORD Params.  With 9.1's
+  use of Params to pass down values from NestLoop join nodes to their
+  inner plans, it is possible for a Param to have type RECORD, in
+  which case the set of fields comprising the value isn't determinable
+  by inspection of the Param alone.  However, just as with a Var of
+  type RECORD, we can find out what we need to know if we can locate
+  the expression that the Param represents.  We already knew how to do
+  this in get_parameter(), but I'd overlooked the need to be able to
+  cope in get_name_for_var_field(), which led to EXPLAIN failing with
+  "record type has not been registered".  To fix, refactor the search
+  code in get_parameter() so it can be used by both functions.  Per
+  report from Marti Raudsepp.
+  <a href="http://git.postgresql.org/pg/commitdiff/a7d9203cc4edfbcc283732efea6d54db0399ccee">http://git.postgresql.org/pg/commitdiff/a7d9203cc4edfbcc283732efea6d54db0399ccee</a>
+</p>
+
+<p>
+- Fix typo in error message.  Per Euler Taveira de Oliveira.
+  <a href="http://git.postgresql.org/pg/commitdiff/99155aaa33f417daabd38c8b225c09a3c6da71ba">http://git.postgresql.org/pg/commitdiff/99155aaa33f417daabd38c8b225c09a3c6da71ba</a>
+</p>
+
+<p>
+- Fix corner case bug in numeric to_char().  Trailing-zero stripping
+  applied by the Fujii Masao specifier could strip zeroes to the left
+  of the decimal point, for a format with no digit positions after the
+  decimal point (such as "FM999.").  Reported and diagnosed by Marti
+  Raudsepp, though I didn't use his patch.
+  <a href="http://git.postgresql.org/pg/commitdiff/f0bedf3e456c52274995d32d4c0c8a250de5c1ca">http://git.postgresql.org/pg/commitdiff/f0bedf3e456c52274995d32d4c0c8a250de5c1ca</a>
+</p>
+
+<p>
+- One last round of copy-editing for the 9.1 release notes.  Also set
+  the documented release date to 2011-09-12.
+  <a href="http://git.postgresql.org/pg/commitdiff/09b68c70af855a0a69cede14da70968ddd97ba05">http://git.postgresql.org/pg/commitdiff/09b68c70af855a0a69cede14da70968ddd97ba05</a>
+</p>
+
+<p>
+- round() is not portable.  Use rint().
+  <a href="http://git.postgresql.org/pg/commitdiff/d63de337f3e235f02d79a1df79dddbb002e9fd4e">http://git.postgresql.org/pg/commitdiff/d63de337f3e235f02d79a1df79dddbb002e9fd4e</a>
+</p>
+
+<p>
+- Stamp 9.1.0.
+  <a href="http://git.postgresql.org/pg/commitdiff/1f43001424a9da624a89b213d0be606a8212a50a">http://git.postgresql.org/pg/commitdiff/1f43001424a9da624a89b213d0be606a8212a50a</a>
+</p>
+
+<p>
+- Move Timestamp/Interval typedefs and basic macros into
+  datatype/timestamp.h.  As per my recent proposal, this refactors
+  things so that these typedefs and macros are available in a header
+  that can be included in frontend-ish code.  I also changed various
+  headers that were undesirably including utils/timestamp.h to include
+  datatype/timestamp.h instead.  Unsurprisingly, this showed that half
+  the system was getting utils/timestamp.h by way of xlog.h.  No
+  actual code changes here, just header refactoring.
+  <a href="http://git.postgresql.org/pg/commitdiff/a7801b62f21bd051444bd1119cd3745ecc8e14ec">http://git.postgresql.org/pg/commitdiff/a7801b62f21bd051444bd1119cd3745ecc8e14ec</a>
+</p>
+
+<p>
+- Simplify handling of the timezone GUC by making initdb choose the
+  default.  We were doing some amazingly complicated things in order
+  to avoid running the very expensive identify_system_timezone()
+  procedure during GUC initialization.  But there is an obvious fix
+  for that, which is to do it once during initdb and have initdb
+  install the system-specific default into postgresql.conf, as it
+  already does for most other GUC variables that need
+  system-environment-dependent defaults.  This means that the timezone
+  (and log_timezone) settings no longer have any magic behavior in the
+  server.  Per discussion.
+  <a href="http://git.postgresql.org/pg/commitdiff/ca4af308c32d03db5fbacb54d6e583ceb904f268">http://git.postgresql.org/pg/commitdiff/ca4af308c32d03db5fbacb54d6e583ceb904f268</a>
+</p>
+
+<p>
+- Try to un-break MSVC build.  I thought we had enough infrastructure
+  to absorb CPPFLAGS changes from the makefiles, but buildfarm says
+  otherwise.
+  <a href="http://git.postgresql.org/pg/commitdiff/5a8de2f2e7fd5d2265f30206743ba2dd51bff222">http://git.postgresql.org/pg/commitdiff/5a8de2f2e7fd5d2265f30206743ba2dd51bff222</a>
+</p>
+
+<p>
+- Fix permissions on pg_largeobject_metadata.h in 9.0 branch.  For
+  some reason it was 0755 instead of 0644.
+  <a href="http://git.postgresql.org/pg/commitdiff/4de174d4bfa8e162cf64fb9bf7393fea05b0dee7">http://git.postgresql.org/pg/commitdiff/4de174d4bfa8e162cf64fb9bf7393fea05b0dee7</a>
+</p>
+
+<p>
+- Remove no-longer-used variable.
+  <a href="http://git.postgresql.org/pg/commitdiff/5f42e5945b3dd96c228531c0730f418846ced04e">http://git.postgresql.org/pg/commitdiff/5f42e5945b3dd96c228531c0730f418846ced04e</a>
+</p>
+
+<p>
+- Invent a new memory context primitive, MemoryContextSetParent.  This
+  function will be useful for altering the lifespan of a context after
+  creation (for example, by creating it under a transient context and
+  later reparenting it to belong to a long-lived context).  It costs
+  almost no new code, since we can refactor what was there.  Per my
+  proposal of yesterday.
+  <a href="http://git.postgresql.org/pg/commitdiff/b0025bd95703aaedc4ff23ddcfbde9597fa0919d">http://git.postgresql.org/pg/commitdiff/b0025bd95703aaedc4ff23ddcfbde9597fa0919d</a>
+</p>
+
+<p>
+Peter Eisentraut pushed:
+</p>
+
+<p>
+- Improve "invalid byte sequence for encoding" message.  It used to
+  say:
+  ERROR:  invalid byte sequence for encoding "UTF8": 0xdb24
+  Change this to
+  ERROR:  invalid byte sequence for encoding "UTF8": 0xdb 0x24
+  to make it clear that this is a byte sequence and not a code point.
+  Also fix the adjacent "character has no equivalent" message that has
+  the same issue.
+  <a href="http://git.postgresql.org/pg/commitdiff/a2a5ce68266d879c7acd292952adc376966622e0">http://git.postgresql.org/pg/commitdiff/a2a5ce68266d879c7acd292952adc376966622e0</a>
+</p>
+
+<p>
+- Correct ancient logic mistake in assertion.  Found by gcc
+  -Wlogical-op
+  <a href="http://git.postgresql.org/pg/commitdiff/e6d800981ed0cd8889660d40cb5e813dfad87344">http://git.postgresql.org/pg/commitdiff/e6d800981ed0cd8889660d40cb5e813dfad87344</a>
+</p>
+
+<p>
+- Add missing format argument to ecpg_log() call
+  <a href="http://git.postgresql.org/pg/commitdiff/cf15fb5cabfbc71e07be23cfbc813daee6c5014f">http://git.postgresql.org/pg/commitdiff/cf15fb5cabfbc71e07be23cfbc813daee6c5014f</a>
+</p>
+
+<p>
+- Add missing format attributes.  Add __attribute__ decorations for
+  printf format checking to the places that were missing them.  Fix
+  the resulting warnings.  Add -Wmissing-format-attribute to the
+  standard set of warnings for GCC, so these don't happen again.  The
+  warning fixes here are relatively harmless.  The one serious problem
+  discovered by this was already committed earlier in
+  cf15fb5cabfbc71e07be23cfbc813daee6c5014f.
+  <a href="http://git.postgresql.org/pg/commitdiff/52ce20589a8bac4eccaea043b1fe283daaf4f9e3">http://git.postgresql.org/pg/commitdiff/52ce20589a8bac4eccaea043b1fe283daaf4f9e3</a>
+</p>
+
+<p>
+- Fix additional format warning.  Apparently, this only happens on
+  64-bit platforms.
+  <a href="http://git.postgresql.org/pg/commitdiff/02bca4f35164dd1873eab9b8e6167e42a79157c4">http://git.postgresql.org/pg/commitdiff/02bca4f35164dd1873eab9b8e6167e42a79157c4</a>
+</p>
+
+<p>
+- Remove many -Wcast-qual warnings.  This addresses only those cases
+  that are easy to fix by adding or moving a const qualifier or
+  removing an unnecessary cast.  There are many more complicated cases
+  remaining.
+  <a href="http://git.postgresql.org/pg/commitdiff/1b81c2fe6ee2b26d37610c3d381a87fa17af0a7c">http://git.postgresql.org/pg/commitdiff/1b81c2fe6ee2b26d37610c3d381a87fa17af0a7c</a>
+</p>
+
+<p>
+Alvaro Herrera pushed:
+</p>
+
+<p>
+- Mark some untranslatable messages with errmsg_internal.
+  <a href="http://git.postgresql.org/pg/commitdiff/b64f18c583675684766e364754bd3c9f702c549d">http://git.postgresql.org/pg/commitdiff/b64f18c583675684766e364754bd3c9f702c549d</a>
+</p>
+
+<p>
+- Adjust translator comment format to xgettext expectations
+  <a href="http://git.postgresql.org/pg/commitdiff/56a9ed92b664af191040d848ca923fb3234671ee">http://git.postgresql.org/pg/commitdiff/56a9ed92b664af191040d848ca923fb3234671ee</a>
+</p>
+
+<p>
+- Tweak string for uniformity
+  <a href="http://git.postgresql.org/pg/commitdiff/295e7dc929c346d53e0b55aaed539b0b0d59059f">http://git.postgresql.org/pg/commitdiff/295e7dc929c346d53e0b55aaed539b0b0d59059f</a>
+</p>
+
+<p>
+Simon Riggs pushed:
+</p>
+
+<p>
+- Emit cascaded standby message on shutdown only when appropriate.
+  Adds additional test for active walsenders and closes a race
+  condition for when we failover when a new walsender was connecting.
+  Reported and fixed bu Fujii Masao. Review by Heikki Linnakangas
+  <a href="http://git.postgresql.org/pg/commitdiff/dde70cc313683e47e71997759c6029b4220f71c0">http://git.postgresql.org/pg/commitdiff/dde70cc313683e47e71997759c6029b4220f71c0</a>
+</p>
+
+<p>
+- Partially revoke attempt to improve performance with many
+  savepoints.  Maintain difference between subtransaction release and
+  commit introduced by earlier patch.
+  <a href="http://git.postgresql.org/pg/commitdiff/df383b03e6f761c9b5bb12aa2339795ab44aa054">http://git.postgresql.org/pg/commitdiff/df383b03e6f761c9b5bb12aa2339795ab44aa054</a>
+</p>
+
+<p>
+- PublishStartupProcessInformation() to avoid rare hang in recovery.
+  Bgwriter could cause hang in recovery during page concurrent
+  cleaning.  Bug report and testing by Bernd Helmle, fix by me
+  <a href="http://git.postgresql.org/pg/commitdiff/7c24bac64c3828d651abfd5e34bd0e0031ab9946">http://git.postgresql.org/pg/commitdiff/7c24bac64c3828d651abfd5e34bd0e0031ab9946</a>
+</p>
+
+<p>
+Heikki Linnakangas pushed:
+</p>
+
+<p>
+- Buffering GiST index build algorithm.  When building a GiST index
+  that doesn't fit in cache, buffers are attached to some internal
+  nodes in the index. This speeds up the build by avoiding random I/O
+  that would otherwise be needed to traverse all the way down the tree
+  to the find right leaf page for tuple.  Alexander Korotkov
+  <a href="http://git.postgresql.org/pg/commitdiff/5edb24a8983e4a103e26153853d91141f818227c">http://git.postgresql.org/pg/commitdiff/5edb24a8983e4a103e26153853d91141f818227c</a>
+</p>
+
+<p>
+- Fix typo and reword the sentence.
+  <a href="http://git.postgresql.org/pg/commitdiff/86ab71d58d4ee7e183e501db75714ad59feef8a5">http://git.postgresql.org/pg/commitdiff/86ab71d58d4ee7e183e501db75714ad59feef8a5</a>
+</p>
+
+<p>
+ITAGAKI Takahiro pushed:
+</p>
+
+<p>
+- Add datatype directory to SUBDIRS.  New header datatype/timestamp.h
+  should be installed for server-side dev.
+  <a href="http://git.postgresql.org/pg/commitdiff/96a8aed4cb66b9a23e5b566ad549cd0c5eac5a74">http://git.postgresql.org/pg/commitdiff/96a8aed4cb66b9a23e5b566ad549cd0c5eac5a74</a>
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Heikki Linnakangas and Alexander Korotkov traded new versions of the
+patch to build GiST indexes quickly.
+</p>
+
+<p>
+Oleg Bartunov sent in three more revisions of the patch to implement
+space-partitioned GiST indexes.
+</p>
+
+<p>
+Marti Raudsepp sent in another revision of the patch to generate more
+useful column names for subquery expressions.
+</p>
+
+<p>
+Marti Raudsepp sent in a patch which adds the backend's current
+running query to the "backend crash" message.
+</p>
+
+<p>
+Shigeru HANADA sent in two more revisions of a patch to add a "force
+not null" option to the file FDW.
+</p>
+
+<p>
+Pavan Deolasee sent in another revision of the patch to a single-pass
+VACUUM.
+</p>
+
+<p>
+Fujii Masao sent in two revisions of a patch to add a
+pg_last_xact_insert_timestamp.
+</p>
+
+<p>
+Marko (johto) Tiikkaja sent in a patch to add an nfiltered annotation
+to EXPLAIN.
+</p>
+
+<p>
+George Barnett sent in a patch intended to improve the way PostgreSQL
+runs with NFS data directory on Linux.
+</p>
+
+<p>
+Tom Lane sent in a WIP patch to bring ECPG in line with the rest of
+the code, which as of this week has a separate header for the core
+timestamp definitions and macros.
+</p>
+
+<p>
+Fujii Masao sent in a patch to unite recovery.conf with postgres.conf.
+</p>
+
+<p>
+Fujii Masao sent in two revisions of a patch to add a replication
+option to the createuser utility.
+</p>
+
+<p>
+Alexey Klyukin sent in another revision of the patch to allow the pg
+config parser to continue on error.
+</p>
+
+<p>
+Marti Raudsepp sent in a patch to cache constant stable expressions
+per execution.
+</p>
+
+<p>
+Josh Kupershmidt sent in another revision of the patch to allow \dd to
+show constraint names.
+</p>
+
+<p>
+Jun Ishiduka sent in another revision of the patch to make it possible
+to take an on-line base backup from a hot standby.
+</p>
+
+<p>
+Andrew Dunstan sent in a patch intended to fix the issue where the
+databse super-user is presumed to be a member of every role.
+</p>
+
+<p>
+Alexander Korotkov sent in another revision of the patch implementing
+a double-sorting picksplit implementation for GiST indexes.
+</p>
+
+<p>
+KaiGai Kohei sent in another flock of patches reworking DROP into a
+single unified framework.
+
+</p>
+
-- 
2.39.5