== PostgreSQL Weekly News - March 10 2013 == - Mailing list pgsql-announce

== PostgreSQL Weekly News - March 10 2013 ==

== PostgreSQL Jobs for March ==

http://archives.postgresql.org/pgsql-jobs/2013-03/threads.php

== PostgreSQL Local ==

PyPgDay will be held on March 13th at the Santa Clara Convention
Center, the first day of PyCon.  Info here:
http://wiki.postgresql.org/wiki/PyPgDay2013

PGDay NYC 2013 will be held on March 22, 2013 in New York City.
http://pgday.nycpug.org/

PG Day France is the major French-speaking PostgreSQL community event.
The deadline for sending proposals is Saturday, March 24, 2013 at
23:59 CEST.
http://pgday.fr/call_for_papers

PostgreSQL Session will be held on March 28th, 2013 in Paris,
France.  The Call for Papers is open.
http://www.postgresql-sessions.org/en/5/

PGCon 2013 will be held May 23-24 2013, in Ottawa at the University of
Ottawa.
http://www.pgcon.org/2013/

The 6th annual "Prague PostgreSQL Developers Day" conference,
organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be
held on May 30, 2013 at Faculty of Mathematics and Physics, Charles
University (Malostranske namesti 25, Prague).  The CfP is open until
April 14, 2013 <info AT p2d2 DOT cz>.  More information in Czech is at
http://www.p2d2.cz/

The Call for Papers for PostgreSQL Brazil, to be held August 15-17,
2013 in Porto Velho, RO, Brazil, is open.  Proposals are due by March
15, 2013.
http://pgbr.postgresql.org.br/2013/chamada.en.php



== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter

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.

== Applied Patches ==

Magnus Hagander pushed:

- Remove accidentally-committed .orig file.
  Author: Kevin Grittner <kgrittn@postgresql.org>
  http://git.postgresql.org/pg/commitdiff/54d6706ded5c612a7f9b16eb6ddb08f44e24bb70

- psql: Let \l accept a pattern.  reviewed by Satoshi Nagayasu
  Author: Peter Eisentraut <peter_e@gmx.net>
  http://git.postgresql.org/pg/commitdiff/0ea1f6e98fc84f1c5f66cc6355f6e20582295e81

- Report pg_hba line number and contents when users fail to log in.
  Instead of just reporting which user failed to log in, log both the
  line number in the active pg_hba.conf file (which may not match
  reality in case the file has been edited and not reloaded) and the
  contents of the matching line (which will always be correct), to
  make it easier to debug incorrect pg_hba.conf files.  The message to
  the client remains unchanged and does not include this information,
  to prevent leaking security sensitive information.  Reviewed by Tom
  Lane and Dean Rasheed
  http://git.postgresql.org/pg/commitdiff/7f49a67f954db3e92fd96963169fb8302959576e

Tom Lane pushed:

- Fix overflow check in tm2timestamp (this time for sure).  I fixed
  this code back in commit 841b4a2d5, but didn't think carefully
  enough about the behavior near zero, which meant it improperly
  rejected 1999-12-31 24:00:00.  Per report from Magnus Hagander.
  http://git.postgresql.org/pg/commitdiff/542eeba26992305d872be699158cb3ab1c2be6e6

- Fix to_char() to use ASCII-only case-folding rules where
  appropriate.  formatting.c used locale-dependent case folding rules
  in some code paths where the result isn't supposed to be
  locale-dependent, for example to_char(timestamp, 'DAY').  Since the
  source data is always just ASCII in these cases, that usually didn't
  matter ... but it does matter in Turkish locales, which have unusual
  treatment of "i" and "I".  To confuse matters even more, the
  misbehavior was only visible in UTF8 encoding, because in
  single-byte encodings we used pg_toupper/pg_tolower which don't have
  locale-specific behavior for ASCII characters.  Fix by providing
  intentionally ASCII-only case-folding functions and using these
  where appropriate.  Per bug #7913 from Adnan Dursun.  Back-patch to
  all active branches, since it's been like this for a long time.
  http://git.postgresql.org/pg/commitdiff/80b011ef0a13bb326861f79ba987b4fa04ae4a27

- Fix missing #include in commands/matview.h.  It needs parsenodes.h
  to be compilable regardless of previous headers.
  http://git.postgresql.org/pg/commitdiff/e11cb8ba2c9134c9f16253213f2f0cf089c5838e

- Arrange to cache FdwRoutine structs in foreign tables' relcache
  entries.  This saves several catalog lookups per reference.  It's
  not all that exciting right now, because we'd managed to minimize
  the number of places that need to fetch the data; but the upcoming
  writable-foreign-tables patch needs this info in a lot more places.
  http://git.postgresql.org/pg/commitdiff/1908abc4a37d397356c9cdf0fd31c33a86281d63

- Fix infinite-loop risk in fixempties() stage of regex compilation.
  The previous coding of this function could get into situations where
  it would never terminate, because successive passes would re-add
  EMPTY arcs that had been removed by the previous pass.  Rewrite the
  function completely using a new algorithm that is guaranteed to
  terminate, and also seems to be usually faster than the old one.
  Per Tcl bugs 3604074 and 3606683.  Tom Lane and Don Porter
  http://git.postgresql.org/pg/commitdiff/a7b61d4f5af37344f8973b2dfce47e2ba2680061

- Support writable foreign tables.  This patch adds the core-system
  infrastructure needed to support updates on foreign tables, and
  extends contrib/postgres_fdw to allow updates against remote
  Postgres servers.  There's still a great deal of room for
  improvement in optimization of remote updates, but at least there's
  basic functionality there now.  KaiGai Kohei, reviewed by Alexander
  Korotkov and Laurenz Albe, and rather heavily revised by Tom Lane.
  http://git.postgresql.org/pg/commitdiff/21734d2fb896e0ecdddd3251caa72a3576e2d415

- Band-aid for regression test expected-results problem with
  timestamptz.  We probably need to tell the remote server to use
  specific timezone and datestyle settings, and maybe other things.
  But for now let's just hack the postgres_fdw regression test to not
  provoke failures when run in non-EST5EDT environments.  Per
  buildfarm.
  http://git.postgresql.org/pg/commitdiff/f7951eef89be78c50ea2241f593d76dfefe176c9

Kevin Grittner pushed:

- Bump catversion because of new function in the materialized view
  patch.
  http://git.postgresql.org/pg/commitdiff/c8056592bcbed183fb03266d22fa1073bc8b04b4

- Fix broken pg_dump for 9.0 and 9.1 caused by the MV patch.  Per
  report and suggestion from Bernd Helmle
  http://git.postgresql.org/pg/commitdiff/cfa3df3de14b437d5f1691d1636a57c9ec595f51

- Add docs for pg_matviews, which were missed in the initial MV
  commit.
  http://git.postgresql.org/pg/commitdiff/5141603ebd162a50c36583f1a80eceadc94ef25e

- WAL-log the extension of a new empty MV heap which is being
  populated.  This page with no tuples is used to distinguish an MV
  containing a zero-row resultset of its backing query from an MV
  which has not been populated by its backing query.  Unless
  WAL-logged, recovery and hot standby don't work correctly with what
  should be an empty but scannable materialized view.  Fixes bugs
  reported by Fujii Masao in testing MVs on hot standby.
  http://git.postgresql.org/pg/commitdiff/c5bf7a2052c8e7ebbd1ca3986525c3629d7345d1

- Fix typo in docs for ALTER MATERIALIZED VIEW.  Fujii Masao
  http://git.postgresql.org/pg/commitdiff/71877c18a869b858f69e813659ed4bb22b117c4a

Andrew Dunstan pushed:

- Remove dependency on the DLL of pythonxx.def file.  This confused
  Cygwin's make because of the colon in the path. The DLL isn't likely
  to change under us so preserving the dependency doesn't gain us
  much, and it's useful to be able to do a native Windows build with
  the Cygwin mingw toolset.  Noah Misch.
  http://git.postgresql.org/pg/commitdiff/0d147e43adcf5d2bff9caa073608f381a27439bf

- Fix message typo.
  http://git.postgresql.org/pg/commitdiff/cd340ca89a06d6386f1af3b519db6f77c21ac84e

- JSON generation improvements.  This adds the following:
  json_agg(anyrecord) -> json to_json(any) -> json
  hstore_to_json(hstore) -> json (also used as a cast)
  hstore_to_json_loose(hstore) -> json The last provides heuristic
  treatment of numbers and booleans.  Also, in json generation, if any
  non-builtin type has a cast to json, that function is used instead
  of the type's output function.  Andrew Dunstan, reviewed by Steve
  Singer.  Catalog version bumped.
  http://git.postgresql.org/pg/commitdiff/38fb4d978c5bfc377ef979e2595e3472744a3b05

Peter Eisentraut pushed:

- pg_ctl: Add comma to message
  http://git.postgresql.org/pg/commitdiff/71ea7e9737c1817cfa1747b181b27e73ce620f3b

- Adjust nls.mk for split out of wait_error.c
  http://git.postgresql.org/pg/commitdiff/f11af2bcab36b51a7e41df7986d6f030459d7d09

- pg_basebackup: Add missing newlines to several error messages
  http://git.postgresql.org/pg/commitdiff/74e629cb0987fd3505173c4e117108e079e7e930

- pg_ctl: Adjust nls.mk for split out of wait_error.c
  http://git.postgresql.org/pg/commitdiff/31531325a4d374e6470b51e4b1dbc3cdc78f7d6e

- Add fe_memutils.c to nls.mk where used
  http://git.postgresql.org/pg/commitdiff/97951139164055d6bae5aae7ea058c28e1462253

- doc: Add note about checkpoint_warning vs checkpoint_timeout.
  suggested by Tianyin Xu
  http://git.postgresql.org/pg/commitdiff/dd28c410f77e415ce104cb42bf52c4a5457085da

Robert Haas pushed:

- Code beautification for object-access hook machinery.  KaiGai Kohei
  http://git.postgresql.org/pg/commitdiff/f90cc269823ba5282341a197c7387f5ada6703a6

Heikki Linnakangas pushed:

- Fix tli history file fetching, broken by the archive after crash
  recevery patch.  If we were about to enter archive recovery after
  crash recovery, we scanned the archive for the latest tli history
  file, and set the recovery target timeline to that. However, when we
  actually tried to read the history file, we would not fetch the file
  from the archive, because we were not in archive recovery yet.  To
  fix, make readTimeLineHistory and existsTimeLineHistory to always
  fetch the file from archive if archive recovery is requested, even
  if we're not in archive recovery yet.  Backpatch to 9.2. Mitsumasa
  KONDO
  http://git.postgresql.org/pg/commitdiff/7ccefe8610db8b339bad2c5b51abc07448a32947

- Remove unnecessary #ifdef FRONTEND check to choose between strdup
  and pstrdup.  The libpgcommon patch made that unnecessary, palloc
  and friends are now available in frontend programs too, mapped to
  plain old malloc.  As pointed out by Alvaro Herrera.
  http://git.postgresql.org/pg/commitdiff/2443a26b9b905e66cd9b95a2faf57e1f1ebcafb1

- SP-GiST support of the range adjacent operator -|-.  Alexander
  Korotkov, reviewed by Jeff Davis.
  http://git.postgresql.org/pg/commitdiff/23f10b6473ed58c3699b81ca4677f4ff51878ec0

- Forgot catversion bump in the SP-GiST adjacent support patch.
  http://git.postgresql.org/pg/commitdiff/96443d142002a6c17ee51fa0633ee5de3bffdc83

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Alvaro Herrera sent in three more revisions of a patch to handle
sql_drop in event triggers.

Michael Paquier sent in nine more revisions of a patch to add REINDEX
CONCURRENTLY.

Joachim Wieland sent in another revision of a patch to implement
parallel pg_dump.

Peter Eisentraut sent in another revision of a patch to implement an
idempotent option for pg_dump.

Heikki Linnakangas sent in another revision of a patch to optimize
pglz.

Kyotaro HORIGUCHI sent in another revision of a patch to fix the width
specifier in format().

Heikki Linnakangas and Amit Kapila traded patches to improve WAL
performance by reducing the amount of same written in updates.

Amit Kapila sent in another revision of a patch to enable changing
postgresql.conf parameters via SQL.

Laurenz Albe sent in another revision of a patch to clarify some of
the documentation on floating point.

Ian Barwick sent in a patch to clarify the CREATE TRIGGER
documentation.

Jeff Davis and Greg Smith traded patches to enable page checksums.

Robins sent in a patch to add a simple test of psql to "make check".