From 1c20946cdf9a0089ae8f209af82c76bf36ae1a0d Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Mon, 19 Oct 2009 01:40:38 +0000
Subject: [PATCH] PostgreSQL Weekly News October 18, 2009

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

diff --git a/portal/files/weeklynews.xml b/portal/files/weeklynews.xml
index 51da0167..4cc63819 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 October 18th 2009</title>
+<description>
+Commitfest 2009-09 is now over.  You can all start working on your own
+patches now :)
+
+
+</description>
+<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20091018</guid>
+<pubDate>Sun, 18 Oct 2009 00:00:00 PST</pubDate>
+</item>
 <item>
 <title>PostgreSQL Weekly News October 11th 2009</title>
 <description>
@@ -116,17 +127,5 @@ PostgreSQL 8.5 development is even smoother and more productive than
 <guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20090816</guid>
 <pubDate>Sun, 16 Aug 2009 00:00:00 PST</pubDate>
 </item>
-<item>
-<title>PostgreSQL Weekly News August 9th 2009</title>
-<description>
-Submission deadline for PGDay.EU 2009 CfP is August 15th, 2009.
-August 15, 2009 is your last chance to be part of it.  Submit soon!
-&#x3C;a href=&#x22;http://www.pgday.eu/&#x22;&#x3E;http://www.pgday.eu/&#x3C;/a&#x3E;
-
-
-</description>
-<guid isPermaLink="true">http://www.postgresql.org/community/weeklynews/pwn20090809</guid>
-<pubDate>Sun, 09 Aug 2009 00:00:00 PST</pubDate>
-</item>
 </channel>
 </rss>
\ No newline at end of file
diff --git a/portal/template/en/community/weeklynews.html b/portal/template/en/community/weeklynews.html
index 0c96a7dd..0b2a20d2 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/pwn20091018">October 18th 2009</a></li>
     <li><a href="/community/weeklynews/pwn20091011">October 11th 2009</a></li>
     <li><a href="/community/weeklynews/pwn20091004">October 4th 2009</a></li>
     <li><a href="/community/weeklynews/pwn20090927">September 27th 2009</a></li>
diff --git a/portal/template/en/community/weeklynews/pwn20091018.html b/portal/template/en/community/weeklynews/pwn20091018.html
new file mode 100644
index 00000000..e6391eeb
--- /dev/null
+++ b/portal/template/en/community/weeklynews/pwn20091018.html
@@ -0,0 +1,345 @@
+<!-- BEGIN page_title_block -->
+Weekly News - October 18 2009
+<!-- END page_title_block -->
+
+<h1>PostgreSQL Weekly News - October 18 2009</h1>
+
+<p>
+Commitfest 2009-09 is now over.  You can all start working on your own
+patches now :)
+</p>
+
+<p>
+PostgreSQL Conference (JDCon) West closed out today.  Thanks to all
+the wonderful people in Seattle for making it a success.
+</p>
+
+<h2>PostgreSQL Product News</h2>
+<p>
+PWN Translator 3.0, a translation script for the PostgreSQL Weekly
+News, released.
+<a href="http://pgfoundry.org/projects/pwn-translation/">http://pgfoundry.org/projects/pwn-translation/</a>
+</p>
+
+<p>
+Benetl 3.2, an ETL tool for files using PostgreSQL, released.
+<a href="http://www.benetl.net">http://www.benetl.net</a>
+</p>
+
+<p>
+Bucardo 4.3.0, a replication system with dual-master capability, released.
+<a href="http://bucardo.org/wiki/Bucardo">http://bucardo.org/wiki/Bucardo</a>
+</p>
+
+<h2>PostgreSQL Jobs for October</h2>
+<p>
+<a href="http://archives.postgresql.org/pgsql-jobs/2009-10/threads.php">http://archives.postgresql.org/pgsql-jobs/2009-10/threads.php</a>
+</p>
+
+<h2>PostgreSQL Local</h2>
+<p>
+PGCon Brazil will be take place October 23-24 2009 at Unicamp in
+Campinas, Sao Paulo state.  Registration open!
+<a href="http://pgcon.postgresql.org.br/2009/">http://pgcon.postgresql.org.br/2009/</a>
+</p>
+
+<p>
+Federico Campoli will be presenting a PostgreSQL talk at GULP (Linux
+Day Pisa) on October 24, 2009.  Information in Italian below:
+<a href="http://linuxday2009.gulp.linux.it/">http://linuxday2009.gulp.linux.it/</a> 
+</p>
+
+<p>
+PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
+November 6-7, 2009.  Registration is open.
+<a href="http://www.pgday.eu/">http://www.pgday.eu/</a>
+</p>
+
+<p>
+OpenSQL Camp in Portland is looking for sponsors.  Make your travel plans now! :)
+<a href="http://www.chesnok.com/daily/2009/07/29/opensql-camp-comes-to-portland-november-14-15-2009/">http://www.chesnok.com/daily/2009/07/29/opensql-camp-comes-to-portland-november-14-15-2009/</a>
+</p>
+
+<p>
+JPUG 10th Anniversary Conference is November 20-21, 2009 in Tokyo, Japan.
+<a href="http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php">http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php</a>
+</p>
+
+<p>
+FOSDEM 2010 will be in Brussels, Belgium on February 6-7, 2010.
+<a href="http://www.fosdem.org/">http://www.fosdem.org/</a>
+</p>
+
+<p>
+Chemnitzer Linuxtage will be in Chemnitz, Germany on March 13-14, 2010.
+<a href="http://chemnitzer.linux-tage.de/">http://chemnitzer.linux-tage.de/</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.
+</p>
+
+<h2>Applied Patches</h2>
+<p>
+Tom Lane committed:
+</p>
+
+<p>
+- Move the handling of SELECT FOR UPDATE locking and rechecking out of
+  execMain.c and into a new plan node type LockRows.  Like the recent
+  change to put table updating into a ModifyTable plan node, this
+  increases planning flexibility by allowing the operations to occur
+  below the top level of the plan tree.  It's necessary in any case to
+  restore the previous behavior of having FOR UPDATE locking occur
+  before ModifyTable does.  This partially refactors EvalPlanQual to
+  allow multiple rows-under-test to be inserted into the EPQ machinery
+  before starting an EPQ test query.  That isn't sufficient to fix
+  EPQ's general bogosity in the face of plans that return multiple
+  rows per test row, though.  Since this patch is mostly about getting
+  some plan node infrastructure in place and not about fixing
+  ten-year-old bugs, I will leave EPQ improvements for another day.
+  Another behavioral change that we could now think about is doing FOR
+  UPDATE before LIMIT, but that too seems like it should be treated as
+  a followon patch.
+</p>
+
+<p>
+- Support GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS IN SCHEMA.
+  Petr Jelinek
+</p>
+
+<p>
+- Use plurals (TABLES, FUNCTIONS, etc) in ALTER DEFAULT PRIVILEGES.
+  We have the keywords as a consequence of the GRANT ALL patch, so we
+  might as well use them and make the ALTER commands read more
+  naturally.
+</p>
+
+<p>
+- Code review for LIKE INCLUDING patch --- clean up some cosmetic and
+  not so cosmetic stuff.
+</p>
+
+<p>
+- In pgsql/src/backend/utils/adt/tsvector_op.c, fix ts_stat's failure
+  on empty tsvector.  Also insert a couple of Asserts that check for
+  stack overflow.  Bogus coding appears to be new in 8.4 --- older
+  releases had a much simpler algorithm here.  Per bug #5111.
+</p>
+
+<p>
+- Add "\pset linestyle ascii/unicode" option to psql, allowing our
+  traditional ASCII-art style of table output to be upgraded to use
+  Unicode box drawing characters if desired.  By default, psql will
+  use the Unicode characters whenever client_encoding is UTF8.  The
+  patch forces linestyle=ascii in pg_regress usage, ensuring we don't
+  break the regression tests in Unicode locales.  Roger Leigh.
+</p>
+
+<p>
+- Support SQL-compliant triggers on columns, ie fire only if certain
+  columns are named in the UPDATE's SET list.  Note: the schema of
+  pg_trigger has not actually changed; we've just started to use a
+  column that was there all along.  catversion bumped anyway so that
+  this commit is included in the history of potentially interesting
+  changes to system catalog contents.  Itagaki Takahiro.
+</p>
+
+<p>
+- In pgsql/src/pl/plpython/expected/plpython_unicode_0.out, first
+  committed version of plpython_unicode_0.out did not actually contain
+  the required \200 bytes.  Let's see if this commit works, or if CVS
+  is messing it up.
+</p>
+
+<p>
+- In pgsql/src/backend/libpq/auth.c, rewrite pam_passwd_conv_proc to
+  be more robust: avoid assuming that the pam_message array contains
+  exactly one PAM_PROMPT_ECHO_OFF message.  Instead, deal with however
+  many messages there are, and don't throw error for PAM_ERROR_MSG and
+  PAM_TEXT_INFO messages.  This logic is borrowed from openssh 5.2p1,
+  which hopefully has seen more real-world PAM usage than we have.
+  Per bug #5121 from Ryan Douglas, which turned out to be caused by
+  the conv_proc being called with zero messages.  Apparently that is
+  normal behavior given the combination of Linux pam_krb5 with MS
+  Active Directory as the domain controller.  Patch all the way back,
+  since this code has been essentially untouched since 7.4.
+  (Surprising we've not heard complaints before.)
+</p>
+
+<p>
+Andrew Dunstan committed:
+</p>
+
+<p>
+- CREATE LIKE INCLUDING COMMENTS and STORAGE, and INCLUDING ALL
+  shortcut. Itagaki Takahiro.
+</p>
+
+<p>
+Alvaro Herrera committed:
+</p>
+
+<p>
+- Add new PGC_S_DATABASE_USER enum value to several places missed by
+  my patch last week.  Per note and patch from Jeff Davis.
+</p>
+
+<p>
+- Avoid using trivial usernames in foreign_data regression test.
+  Martin Pihlak.
+</p>
+
+<p>
+Peter Eisentraut committed:
+</p>
+
+<p>
+- In pgsql/doc/src/sgml/func.sgml, replace unmatched " by &quot; to
+  avoid throwing off syntax highlighters.
+</p>
+
+<p>
+- Add alternative expected file for unicode test for client encoding
+  not UTF8.
+</p>
+
+<p>
+- In the configure check for the Python distutils module, use a less
+  obscure shell construct to hide away the stderr output.  Python 3.1
+  actually core dumps on the current invocation
+  (<a href="http://bugs.python.org/issue7111),">http://bugs.python.org/issue7111),</a> but the new version also has the
+  more general advantage of saving the error message in config.log for
+  analysis.
+</p>
+
+<p>
+Heikki Linnakangas committed:
+</p>
+
+<p>
+- In pgsql/src/backend/libpq/auth.c, raise the maximum authentication
+  token (Kerberos ticket) size in GSSAPI and SSPI athentication
+  methods. While the old 2000 byte limit was more than enough for Unix
+  Kerberos implementations, tickets issued by Windows Domain
+  Controllers can be much larger.  Ian Turner.
+</p>
+
+<p>
+- In pgsql/src/backend/libpq/auth.c, rename the new
+  MAX_AUTH_TOKEN_LENGTH #define to PG_MAX_AUTH_MAX_TOKEN_LENGTH, to
+  make it more obvious that it's a PostgreSQL internal limit, not
+  something that comes from system header files.
+</p>
+
+<p>
+- In pgsql/src/bin/scripts/vacuumdb.c, FREEZE and VERBOSE options were
+  in wrong order in the VACUUM command that vacuumdb produces. Per
+  report by Thom Brown.
+</p>
+
+<p>
+Michael Meskes committed:
+</p>
+
+<p>
+- Made ECPG more robust against applications freeing strings, based on
+  patch send in by Zoltan Boszormenyi.
+</p>
+
+<p>
+Magnus Hagander committed:
+</p>
+
+<p>
+- Write to the Windows eventlog in UTF16, converting the message
+  encoding as necessary.  Itagaki Takahiro with some changes from me.
+</p>
+
+<p>
+- In pgsql/src/backend/utils/mb/mbutils.c, fix typo in previous
+  release as reported by Itagaki Takahiro, but missed by me.
+</p>
+
+<h2>Rejected Patches (for now)</h2>
+<p>
+No one was disappointed this week :-)
+</p>
+
+<h2>Pending Patches</h2>
+<p>
+Laurenz Albe sent in another revision of the patch to create a hook to
+test password cryptgraphic strength along with a contrib module to use
+the hook.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in another revision of the patch to fix encoding
+issues and eventlog on Win32.
+</p>
+
+<p>
+KaiGai Kohei sent in another revision of the patch for large object
+ACLs.
+</p>
+
+<p>
+Dave Page sent in a WIP patch to add an application_name GUC which
+optionally shows the name of the connecting application.
+</p>
+
+<p>
+Peter Eisentraut sent in an updated version of the per-column trigger
+patch.
+</p>
+
+<p>
+KaiGai Kohei sent in another revision of the ACL rework patch.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in another revision of the per-column trigger
+patch.
+</p>
+
+<p>
+Zoltan Boszormenyi sent a patch that makes ECPG more robust against
+applications that free() strings by storing its own copy of the
+prepared statement name.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in a patch to prevent table rewrites caused by
+ALTER TABLE from writing WALs.
+</p>
+
+<p>
+Heikki Linnakangas sent in an updated patch for Hot Standby.
+</p>
+
+<p>
+ITAGAKI Takahiro sent in a patch for contrib/auto_explain which adds
+EXPLAIN (ANALYZE|BUFFERS).
+</p>
+
+<p>
+ITAGAKI Takahiro sent in a WIP patch to add WHEN to triggers.
+</p>
+
+<p>
+Dave Page sent in another revision of the patch to add an
+application_name GUC and supporting features for same.
+
+</p>
+
-- 
2.39.5