From af616d03a9f28c8c583c75b20dfa931b37d85b77 Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Mon, 10 Jan 2011 05:29:23 +0000
Subject: [PATCH] PostgreSQL Weekly News January 09, 2011

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

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index ed929abc..5e2981c6 100644
--- a/portal/files/weeklynews.xml
+++ b/portal/files/weeklynews.xml
@@ -10,6 +10,19 @@
 <description></description>
 <language>en</language>
 
+<item>
+<title>PostgreSQL Weekly News January 9th 2011</title>
+<description>
+AustinPUG will be meeting this Wednesday, Jan. 12.  The topic will be
+setting up streaming replication.  Free pizza!  RSVP to austinpug AT
+postgresql DOT org appreciated but not required.
+&#x3C;a href=&#x22;http://pugs.postgresql.org/austinpug&#x22;&#x3E;http://pugs.postgresql.org/austinpug&#x3C;/a&#x3E;
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20110109</guid>
+<pubDate>Sun, 09 Jan 2011 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News January 2nd 2011</title>
 <description>
@@ -117,16 +130,5 @@ Here&#x27;s how to test it:
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20101107</guid>
 <pubDate>Sun, 07 Nov 2010 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News October 31st 2010</title>
-<description>
-Happy Hallowe&#x27;en/All Hallows Eve/Samhain from the PostgreSQL Weekly
-News!
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20101031</guid>
-<pubDate>Sun, 31 Oct 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 ef8fb1a2..064ce54d 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/pwn20110109">January 9th 2011</a></li>
     <li><a href="/community/weeklynews/pwn20110102">January 2nd 2011</a></li>
     <li><a href="/community/weeklynews/pwn20101226">December 26th 2010</a></li>
     <li><a href="/community/weeklynews/pwn20101219">December 19th 2010</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20110109.html b/portal/template/en/community/weeklynews/pwn20110109.html
new file mode 100644
index 00000000..652ec94c
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20110109.html
@@ -0,0 +1,680 @@
+<!-- BEGIN page_title_block -->
+Weekly News - January 09 2011
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - January 09 2011</h1>
+
+<p>
+AustinPUG will be meeting this Wednesday, Jan. 12.  The topic will be
+setting up streaming replication.  Free pizza!  RSVP to austinpug AT
+postgresql DOT org appreciated but not required.
+<a href="http://pugs.postgresql.org/austinpug">http://pugs.postgresql.org/austinpug</a>
+</p>
+
+<p>
+Selena Deckelmann will be speaking on PostgreSQL Community and
+Development February 7, 2010, 4pm at Oregon State University in
+Corvallis, OR.
+</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>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+PostgreSQL LiveCD based on PostgreSQL 9.0.2 atop CentOS 5.5 is out.
+<a href="http://www.pglivecd.org/">http://www.pglivecd.org/</a>
+</p>
+
+<p>
+phpPgAdmin 5.0.2, a web-based administrative tool for PostgreSQL, released.
+<a href="http://phppgadmin.sourceforge.net/">http://phppgadmin.sourceforge.net/</a>
+</p>
+
+<h2>PostgreSQL Jobs for January</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2011-01/threads.php">http://archives.postgresql.org/pgsql-jobs/2011-01/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+The Call for Papers for the fourth annual Prague PostgreSQL
+Developers' Day is open.  It will be held February 10, 2011 at Charles
+University in Prague.
+<a href="http://archives.postgresql.org/pgsql-announce/2010-12/msg00009.php">http://archives.postgresql.org/pgsql-announce/2010-12/msg00009.php</a>
+</p>
+
+<p>
+The PostgreSQLFr Call for Projects is open.  Projects must target
+PostgreSQL and the French-speaking community.  Mail appel-projets-2010
+AT postgresql DOT fr.
+<a href="http://www.postgresql.fr/appel_a_projets_2010:call_for_projects">http://www.postgresql.fr/appel_a_projets_2010:call_for_projects</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.  Post your talk submission
+to pgday-submissions AT googlegroups DOT com.
+</p>
+
+<p>
+PostgreSQL Conference East 2011: NYC March 22nd - 25th
+<a href="http://www.postgresqlconference.org">http://www.postgresqlconference.org</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>
+<p>
+Pavel Stehule reviewed the MULTISET patch.
+</p>
+
+<h2>Applied Patches</h2>
+<p>
+Magnus Hagander pushed:
+</p>
+
+<p>
+- perltidy run on the MSVC build system.  Forgot this with previuos
+  commit, line it up so it's easier to submit (readable) patches
+  against the MSVC build system.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c0e96b49e588b2a5ab501a2acc03b96ff76cf288">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=c0e96b49e588b2a5ab501a2acc03b96ff76cf288</a>
+</p>
+
+<p>
+- Add missing part of replication role docs.  Noted by Peter Eisentraut.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1996b482859c67726e77b80a263d3cce954e022d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1996b482859c67726e77b80a263d3cce954e022d</a>
+</p>
+
+<p>
+- Add views and functions to monitor hot standby query conflicts.  Add
+  the view pg_stat_database_conflicts and a column to
+  pg_stat_database, and the underlying functions to provide the
+  information.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=40d9e94bd7537144d3d379c1fd1264dff5cf4bb2">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=40d9e94bd7537144d3d379c1fd1264dff5cf4bb2</a>
+</p>
+
+<p>
+- Bump catversion, forgot in previous commit.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=77745cc7f1617852844dd88ec8ddb48f38e19e9a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=77745cc7f1617852844dd88ec8ddb48f38e19e9a</a>
+</p>
+
+<p>
+- Give superusers REPLIACTION permission by default.  This can be
+  overriden by using NOREPLICATION on the CREATE ROLE statement, but
+  by default they will have it, making it backwards compatible and
+  "less surprising" (given that superusers normally override all
+  checks).
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=66a8a0428db046d725b88c8b956384c2a4b4a11c">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=66a8a0428db046d725b88c8b956384c2a4b4a11c</a>
+</p>
+
+<p>
+- Add pgreadlink() on Windows to read junction points.  Add support
+  for reading back information about the symbolic links we've created
+  with pgsymlink(), which are actually Junction Points.  Just as
+  pgsymlink() can only create directory symlinks, pgreadlink() can
+  only read directory symlinks.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=db4d22d0eff091e96d92c82566c9e9d297040b93">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=db4d22d0eff091e96d92c82566c9e9d297040b93</a>
+</p>
+
+<p>
+- Properly install gram.h on MSVC builds.  This file is now needed by
+  pgAdmin builds, which started failing since it was missing in the
+  installer builds.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3457514c2d9bac552d4caeb1d3ac5a8d03d3a439">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3457514c2d9bac552d4caeb1d3ac5a8d03d3a439</a>
+</p>
+
+<p>
+- Ensure the directory for gram.h is created on win32.  Result of bad
+  testing of my last commit.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=361418be7c23e236d07edf4052de85ab8f32d88d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=361418be7c23e236d07edf4052de85ab8f32d88d</a>
+</p>
+
+<p>
+- Split pg_start_backup() and pg_stop_backup() into two pieces Move
+  the actual functionality into a separate function that's easier to
+  call internally, and change the SQL-callable function to be a
+  wrapper calling this.  Also create a pg_abort_backup() function,
+  only callable internally, that does only the most vital parts of
+  pg_stop_backup(), making it safe(r) to call from error handlers.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4448917d51d6f87655ce357cca009634b0a136e4">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4448917d51d6f87655ce357cca009634b0a136e4</a>
+</p>
+
+<p>
+Robert Haas pushed:
+</p>
+
+<p>
+- Update comments in RecordTransactionCommit() to mention unlogged tables.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=dc8a14311a4825b6bf7b787764b9f0c3f8d8df8e">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=dc8a14311a4825b6bf7b787764b9f0c3f8d8df8e</a>
+</p>
+
+<p>
+- Fix crash in ALTER OPERATOR CLASS/FAMILY .. SET SCHEMA.  In the
+  previous coding, the parser emitted a List containing a C string,
+  which is no good, because copyObject() can't handle it.  Dimitri
+  Fontaine.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7f60be72b0865dd442c4f6164a997ff528a44d85">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7f60be72b0865dd442c4f6164a997ff528a44d85</a>
+</p>
+
+<p>
+- Improve recovery.conf.sample comments.  Jehan-Guillaume de Rorthais,
+  with some additional wordsmithing by me.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a9f72b408325c4abb41b5ab65f8fb79af4c29495">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a9f72b408325c4abb41b5ab65f8fb79af4c29495</a>
+</p>
+
+<p>
+- Document pg_stat_replication, bump catversion since that was
+  overlooked.  Itagaki Takahiro, edited by me.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9b4271deb97270d336c9d34ac911748faa5a4892">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9b4271deb97270d336c9d34ac911748faa5a4892</a>
+</p>
+
+<p>
+- Remove bogus claims regarding createuser defaults.  Josh Kupershmidt.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=af84bee43e356866dc46c95ae5bf77996a8237ff">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=af84bee43e356866dc46c95ae5bf77996a8237ff</a>
+</p>
+
+<p>
+ITAGAKI Takahiro pushed:
+</p>
+
+<p>
+- Improve psql tab completion for CREATE/ALTER ROLE [NO]REPLICATION.
+  Missing support for VALID UNTIL in CREATE ROLE is also added.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=14158f25cd164d65cf174dab9e22b3b4a22962a7">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=14158f25cd164d65cf174dab9e22b3b4a22962a7</a>
+</p>
+
+<p>
+- New system view pg_stat_replication displays activity of wal sender
+  processes.  Itagaki Takahiro and Simon Riggs.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a755ea33ae3d772977fa083a8614bb9d4cc36e5a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a755ea33ae3d772977fa083a8614bb9d4cc36e5a</a>
+</p>
+
+<p>
+Andrew Dunstan pushed:
+</p>
+
+<p>
+- Work around header misdefines in modern Windows SDK when
+  _WIN32_WINNT is less than 0x0501. Only required for versions 8.2,
+  8.3 and 8.4., as we defined _WIN32_WINNT as 0x0501 after that.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1d1a43422252576e9a7fa07d8dbfea9c724aa75b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1d1a43422252576e9a7fa07d8dbfea9c724aa75b</a>
+</p>
+
+<p>
+- Allow older branches to be built with Visual Studio 2008.  This is a
+  backport of commit df0cdd53 to the 8.2, 8.3 and 8.4 branches.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5739935188ca27b5b6e63d72748af733b5813aa9">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5739935188ca27b5b6e63d72748af733b5813aa9</a>
+</p>
+
+<p>
+Bruce Momjian pushed:
+</p>
+
+<p>
+- Simplify functions and parameters used by pg_upgrade.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=25cc7424e3b4d3bd76fa54bfc6907f294b4b99d1">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=25cc7424e3b4d3bd76fa54bfc6907f294b4b99d1</a>
+</p>
+
+<p>
+- In pg_upgrade, fix backward logging display of link operations.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0857a8449826867711a9c1f99088bd13731ac192">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0857a8449826867711a9c1f99088bd13731ac192</a>
+</p>
+
+<p>
+- In pg_upgrade, copy pg_largeobject_metadata and its index for 9.0+
+  servers because, like pg_largeobject, it is a system table whose
+  contents are not dumped by pg_dump --schema-only.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3302334b48e2be6eb2c01dcf500363dbd4f22e59">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3302334b48e2be6eb2c01dcf500363dbd4f22e59</a>
+</p>
+
+<p>
+- Clarify pg_upgrade's creation of the map file structure.  Also clean
+  up pg_dump's calling of pg_upgrade_support functions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5cff5b577918cf29e0ba3a35158c27cfe2de280c">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=5cff5b577918cf29e0ba3a35158c27cfe2de280c</a>
+</p>
+
+<p>
+- In pg_upgrade, adjust transfer_relfile()'s parameters to be more logical.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b1f2a94fa2bebbc74d392a18e4ac1d1e558485fc">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b1f2a94fa2bebbc74d392a18e4ac1d1e558485fc</a>
+</p>
+
+<p>
+- Fix for recent pg_upgrade commit to fix large objects relfilenode
+  handling.  (metadata user ids still an open issue).
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a45beaac642147ebf2e561cce62967d244c343c6">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a45beaac642147ebf2e561cce62967d244c343c6</a>
+</p>
+
+<p>
+- Update pg_upgrade C comments.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e66e43988a334ca58c584a0652d29dff61e698b9">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=e66e43988a334ca58c584a0652d29dff61e698b9</a>
+</p>
+
+<p>
+- Rename pg_upgrade variables, for clarity.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56a9adcb96ead8569582aa1f0f77a8fa9e24c189">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56a9adcb96ead8569582aa1f0f77a8fa9e24c189</a>
+</p>
+
+<p>
+- Update documentation to say that \lo_import sets :LASTOID, not lo_insert.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1aad44f988dbebbdde986478f25096037c6dd931">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1aad44f988dbebbdde986478f25096037c6dd931</a>
+</p>
+
+<p>
+- Improve C comments about backend variables set by pg_upgrade_support
+  functions.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=46d28820b6d213bf26b24ecd289a1c466ecf1956">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=46d28820b6d213bf26b24ecd289a1c466ecf1956</a>
+</p>
+
+<p>
+- Force pg_upgrade's to preserve pg_class.oid, not
+  pg_class.relfilenode.  Toast tables have identical pg_class.oid and
+  pg_class.relfilenode, but for clarity it is good to preserve the
+  pg_class.oid.  Update comments regarding what is preserved, and do
+  some variable/function renaming for clarity.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2896c87ce4dc789722296f010eaefd5cbb86ece3">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2896c87ce4dc789722296f010eaefd5cbb86ece3</a>
+</p>
+
+<p>
+- Fix pg_upgrade of large object permissions by preserving
+  pg_auth.oid, which is stored in pg_largeobject_metadata.  No
+  backpatch to 9.0 because you can't migrate from 9.0 to 9.0 with the
+  same catversion (because of tablespace conflict), and a pre-9.0
+  migration to 9.0 has not large object permissions to migrate.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d8d3d2a4f37f6df5d0118b7f5211978cca22091a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d8d3d2a4f37f6df5d0118b7f5211978cca22091a</a>
+</p>
+
+<p>
+- Fix C indenting in pg_upgrade function.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=519c008a966251e45d683738d89f238e5c801781">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=519c008a966251e45d683738d89f238e5c801781</a>
+</p>
+
+<p>
+- In pg_upgrade, track only one copy of namespace/relname in
+  FileNameMap because the old and new values are identical.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f75383e6e8263cd98582edb0b3884132ad9e368a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f75383e6e8263cd98582edb0b3884132ad9e368a</a>
+</p>
+
+<p>
+- Simplify pg_upgrade C comment about what is preserved.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3095643d374ca79e5aa347cefbaebdcf70169386">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=3095643d374ca79e5aa347cefbaebdcf70169386</a>
+</p>
+
+<p>
+- More pg_upgrade relfilenode C comments added.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2f657e4d720d08b26234f3b9e40e347f3cc42220">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2f657e4d720d08b26234f3b9e40e347f3cc42220</a>
+</p>
+
+<p>
+- Document why pg_upgrade preserves pg_auth.oid (because they are
+  stored in pg_largeobject_metadata).
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=133641a48eb9a3406fda7014a60fd42dfecfa089">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=133641a48eb9a3406fda7014a60fd42dfecfa089</a>
+</p>
+
+<p>
+- In pg_upgrade, remove unnecessary separate handling of toast tables
+  now that we restore by oid;  they can be handled like regular tables
+  when creating the file mapping structure.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a60b32b3dcb4d49a60c96558ce405764ac17c799">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a60b32b3dcb4d49a60c96558ce405764ac17c799</a>
+</p>
+
+<p>
+- In pg_upgrade, clarify use of install_db_support_functions().
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ebaf648ad2e471b2e2003ecfe4740ce27226c02a">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ebaf648ad2e471b2e2003ecfe4740ce27226c02a</a>
+</p>
+
+<p>
+- In pg_upgrade, remove functions that did sequential array scans
+  looking up relations, but rather order old/new relations and use the
+  same array index value for both.  This should speed up pg_upgrade
+  for databases with many relations.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=002c105a0706bd1c1e939fe0f47ecdceeae6c52d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=002c105a0706bd1c1e939fe0f47ecdceeae6c52d</a>
+</p>
+
+<p>
+Tom Lane pushed:
+</p>
+
+<p>
+- Update sequence_1.out for recent changes in sequence regression test.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c596c29a3666830d089facf9d6c7f44b4d0e9f2">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6c596c29a3666830d089facf9d6c7f44b4d0e9f2</a>
+</p>
+
+<p>
+- Fix GIN to support null keys, empty and null items, and full index
+  scans.  Per my recent proposal(s).  Null key datums can now be
+  returned by extractValue and extractQuery functions, and will be
+  stored in the index.  Also, placeholder entries are made for
+  indexable items that are NULL or contain no keys according to
+  extractValue.  This means that the index is now always complete,
+  having at least one entry for every indexed heap TID, and so we can
+  get rid of the prohibition on full-index scans.  A full-index scan
+  is implemented much the same way as partial-match scans were
+  already: we build a bitmap representing all the TIDs found in the
+  index, and then drive the results off that.  Also, introduce a
+  concept of a "search mode" that can be requested by extractQuery
+  when the operator requires matching to empty items (this is just as
+  cheap as matching to a single key) or requires a full index scan
+  (which is not so cheap, but it sure beats failing or giving wrong
+  answers).  The behavior remains backward compatible for opclasses
+  that don't return any null keys or request a non-default search
+  mode.  Using these features, we can now make the GIN index opclass
+  for anyarray behave in a way that matches the actual anyarray
+  operators for &&, <@, @>, and = ... which it failed to do before in
+  assorted corner cases.  This commit fixes the core GIN code and
+  ginarrayprocs.c, updates the documentation, and adds some simple
+  regression test cases for the new behaviors using the array
+  operators.  The tsearch and contrib GIN opclass support functions
+  still need to be looked over and probably fixed.  Another thing I
+  intend to fix separately is that this is pretty inefficient for
+  cases where more than one scan condition needs a full-index search:
+  we'll run duplicate GinScanEntrys, each one of which builds a large
+  bitmap.  There is some existing logic to merge duplicate
+  GinScanEntrys but it needs refactoring to make it work for entries
+  belonging to different scan keys.  Note that most of gin.h has been
+  split out into a new file gin_private.h, so that gin.h doesn't
+  export anything that's not supposed to be used by GIN opclasses or
+  the rest of the backend.  I did quite a bit of other code
+  beautification work as well, mostly fixing comments and choosing
+  more appropriate names for things.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=73912e7fbd1b52c51d914214abbec1cda64595f2">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=73912e7fbd1b52c51d914214abbec1cda64595f2</a>
+</p>
+
+<p>
+- Fix the built-in GIN support procedure declarations in pg_proc.h.
+  Add more "internal" arguments so that these pg_proc entries reflect
+  the current preferred API.  This is purely a cosmetic change, since
+  GIN doesn't actually consult the pg_proc entry when calling a
+  support function.  Accordingly, no catversion bump.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a032d50128f30029651806030f71d594ed6b29e1">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a032d50128f30029651806030f71d594ed6b29e1</a>
+</p>
+
+<p>
+- Ooops, forgot to fix contrib/tsearch2's references to GIN support funcs.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=541fc3d4df66a5e51d172a78288069bd92dda0c8">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=541fc3d4df66a5e51d172a78288069bd92dda0c8</a>
+</p>
+
+<p>
+- Update GIN support function definitions for contrib/intarray.  The
+  underlying C code still needs work, but this at least gets its
+  current regression test passing again.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=69c26c57cfb4194b8cdc69b48b8a71dad1f92bac">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=69c26c57cfb4194b8cdc69b48b8a71dad1f92bac</a>
+</p>
+
+<p>
+- Refactor GIN's handling of duplicate search entries.  The original
+  coding could combine duplicate entries only when they originated
+  from the same qual condition.  In particular it could not combine
+  cases where multiple qual conditions all give rise to full-index
+  scan requests, which is an expensive case well worth optimizing.
+  Refactor so that duplicates are recognized across all the quals.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56a57473a999b0497e63bde3e303beda5a3c0ff3">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56a57473a999b0497e63bde3e303beda5a3c0ff3</a>
+</p>
+
+<p>
+- Remove pg_am.amindexnulls.  The only use we have had for
+  amindexnulls is in determining whether an index is safe to cluster
+  on; but since the addition of the amclusterable flag, that usage is
+  pretty redundant.  In passing, clean up assorted sloppiness from the
+  last patch that touched pg_am.h: Natts_pg_am was wrong, and
+  ambuildempty was not documented.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7e2f906201c8bb95f7fb17e56b8740c38bda5441">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7e2f906201c8bb95f7fb17e56b8740c38bda5441</a>
+</p>
+
+<p>
+- Add array_contains_nulls() function in arrayfuncs.c.  This will
+  support fixing contrib/intarray (and probably other places) so that
+  they don't have to fail on arrays that contain a null bitmap but no
+  live null entries.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=adf328c0e1bfde90b944d53f7197fc436bc0c707">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=adf328c0e1bfde90b944d53f7197fc436bc0c707</a>
+</p>
+
+<p>
+- Fix up gincostestimate for new extractQuery API.  The only reason
+  this wasn't crashing while testing the core anyarray operators was
+  that it was disabled for those cases because of passing the wrong
+  type information to get_opfamily_proc :-(.  So fix that too, and
+  make it insist on finding the support proc --- in hindsight,
+  silently doing nothing is not as sane a coping mechanism as all
+  that.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4d1b76e49eb848b046ddb1beb0f4589816ec8261">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=4d1b76e49eb848b046ddb1beb0f4589816ec8261</a>
+</p>
+
+<p>
+- Fix assorted corner-case bugs in contrib/intarray.  The array
+  containment operators now behave per mathematical expectation for
+  empty arrays (ie, an empty array is contained in anything).  Both
+  these operators and the query_int operators now work as expected in
+  GiST and GIN index searches, rather than having corner cases where
+  the index searches gave different answers.  Also, fix unexpected
+  failures where the operators would claim that an array contained
+  nulls, when in fact there was no longer any null present (similar to
+  bug #5784).  The restriction to not have nulls is still there, as
+  removing it would take a lot of added code complexity and probably
+  slow things down significantly.  Also, remove the arbitrary
+  restriction to 1-D arrays; unlike the other restriction, this was
+  buying us nothing performance-wise.  Assorted cosmetic improvements
+  and marginal performance improvements, too.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=fdf2dbda3f49310b20780ad7b290da935cd2335d">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=fdf2dbda3f49310b20780ad7b290da935cd2335d</a>
+</p>
+
+<p>
+- Use array_contains_nulls instead of ARR_HASNULL on user-supplied
+  arrays.  This applies the fix for bug #5784 to remaining places
+  where we wish to reject nulls in user-supplied arrays.  In all these
+  places, there's no reason not to allow a null bitmap to be present,
+  so long as none of the current elements are actually null.  I did
+  not change some other places where we are looking at system catalog
+  entries or aggregate transition values, as the presence of a null
+  bitmap in such an array would be suspicious.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=304845075ce0eb9045af50ed32c688a0cb8dd490">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=304845075ce0eb9045af50ed32c688a0cb8dd490</a>
+</p>
+
+<p>
+- Fix up core tsquery GIN support for new extractQuery API.  No need
+  for the empty-prefix-match kluge to force a full scan anymore.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=52fd2d65a33c9c33b29788e9df89d7716f1ec0bc">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=52fd2d65a33c9c33b29788e9df89d7716f1ec0bc</a>
+</p>
+
+<p>
+- Fix crash in the new GiST insertion code, when an update splits the
+  root page.  This bug was exercised by contrib/intarray/bench, as
+  noted by Tom Lane.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ca63029eac379d82f78a985a5d4068b9954deb02">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ca63029eac379d82f78a985a5d4068b9954deb02</a>
+</p>
+
+<p>
+- Improve comment.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=327b25768217f5d4fd82770d0ab449814548f094">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=327b25768217f5d4fd82770d0ab449814548f094</a>
+</p>
+
+<p>
+- Update contrib/hstore for new GIN extractQuery API.  In particular,
+  make hstore @> '' succeed for all hstores, likewise hstore ?& '{}'.
+  Previously the results were inconsistent and could depend on whether
+  you were using a GiST index, GIN index, or seqscan.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ba398969cd1b32c550345bcf6b713deeb0a7d1de">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=ba398969cd1b32c550345bcf6b713deeb0a7d1de</a>
+</p>
+
+<p>
+- Update contrib/pg_trgm for new GIN extractQuery API.  No actual
+  change in functionality ... just get rid of uselessly complex code
+  to pass the number of keys via extra_data.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=be0c3ea2d30ba225f0249ae88d6b0bdf3b753162">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=be0c3ea2d30ba225f0249ae88d6b0bdf3b753162</a>
+</p>
+
+<p>
+Peter Eisentraut pushed:
+</p>
+
+<p>
+- Improve array_upper example.  The previous example didn't make it
+  clear whether array_upper returned the last element or the index of
+  the last element.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f9e4961b7d599ff42accf324a3c080c5095785c9">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f9e4961b7d599ff42accf324a3c080c5095785c9</a>
+</p>
+
+<p>
+- Improve markup of unnest example.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7f40e30309b5c8f19b1ac86c463ab0ea99907873">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7f40e30309b5c8f19b1ac86c463ab0ea99907873</a>
+</p>
+
+<p>
+Michael Meskes pushed:
+</p>
+
+<p>
+- In ecpg's parser removed a fixed length limit for constants defining
+  an array dimension.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=833a2b57bcbebda29fc1eb0b98c0d94ae2c31b7b">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=833a2b57bcbebda29fc1eb0b98c0d94ae2c31b7b</a>
+</p>
+
+<p>
+- There is no need to have to identical functions in ecpg thus
+  removing one of them.
+  <a href="http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1066dbfb85462116e4ed3d889a686f1e48333467">http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1066dbfb85462116e4ed3d889a686f1e48333467</a>
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Christian Ullrich sent in a patch which allows for SSPI client
+authentication on non-Windows builds.
+</p>
+
+<p>
+Brar Piening sent in another revision of the patch to add Visual
+Studio 2010/Windows SDK 7.1 support.
+</p>
+
+<p>
+Andrew Dunstan sent in a patch to allow MSVC 2008 to be used on back
+branches.
+</p>
+
+<p>
+Jeff Davis sent in a WIP patch to implement RANGE types.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in two patches to implement pg_stat_walsender.
+The first is a generic formatter for host and port.  The second adds
+the actual system view.
+</p>
+
+<p>
+Dimitri Fontaine sent in another revision of the patch which allows
+pg_dump to support EXTENSIONs.
+</p>
+
+<p>
+Dimitri Fontaine sent in a patch to allow upgrading extensions.
+</p>
+
+<p>
+Simon Riggs sent in a patch which implements
+pg_stat_replication_activity in response to ITAGAKI Takahiro's
+pg_stat_walsender patch.
+</p>
+
+<p>
+Shigeru HANADA sent in a patch which removes the requirement that FDWs
+have USAGE privilege in SQL/MED.  This is per the standard.
+</p>
+
+<p>
+Shigeru HANADA sent in a pair of patches which implement fdw_handler
+and foreign_scan, both for SQL/MED.
+</p>
+
+<p>
+KaiGai Kohei sent in another revision of the patch to add sepgsql as a
+contrib module.
+</p>
+
+<p>
+Magnus Hagander sent in a patch to implement streaming base backups.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in another revision of the patch to add
+MULTISET.
+</p>
+
+<p>
+Gurjeet Singh sent in another revision of the patch to add a UNIQUE
+constraint using extant indexes.
+</p>
+
+<p>
+Tom Lane sent in a patch to fix GIN for empty/null/full-scan cases.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in another version of the patch to export some
+of the COPY functions for use in, among other things, foreign
+data wrappers for files.
+</p>
+
+<p>
+Joachim Wieland sent in another revision of the patch to export
+snapshots.
+</p>
+
+<p>
+Joachim Wieland sent in another revision of the patches to do
+directory-format parallel pg_dump.
+</p>
+
+<p>
+Heikki Linnakangas sent in a patch to give streaming base backups a
+bison grammar.
+</p>
+
+<p>
+Magnus Hagander sent in an updated patch to stream base backups.
+</p>
+
+<p>
+Alexander Korotkov sent in another revision of the patch to add
+wildcards to the trigram contrib module.
+</p>
+
+<p>
+Andreas Karlsson sent in a patch to add an obj_unique_identifier()
+function.
+</p>
+
+<p>
+Noah Misch sent in a flock of patches intended to make the process of
+altering a column's type more efficient.
+
+</p>
+
-- 
2.39.5