== PostgreSQL Weekly News - April 21 2013 ==

== PostgreSQL Weekly News - April 21 2013 ==

PGConf.DE 2013 is the sequel of the highly successful German-speaking
PostgreSQL Conference 2011. We maintain the proven concept: November
8th, 2013, the Rhineland Industrial Museum in Oberhausen.
http://2013.pgconf.de/

The PG Day France 2013 schedule is now available, and and registration
is open. This will take place in Nantes Thursday June 13, 2013.
Schedule:
http://pgday.fr/programme
Registration:
http://www.pgday.fr/inscriptions

== PostgreSQL Product News ==

phpPgAdmin 5.1, a web-based administrative tool for PostgreSQL, released.
http://phppgadmin.sourceforge.net/doku.php?id=download

== PostgreSQL Jobs for April ==

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

== PostgreSQL Local ==

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

Postgres-XC is going to have its first user/developer meeting after
the cluster summit.
https://wiki.postgresql.org/wiki/PgCon2013CanadaClusterSummit#PostgresXC_Summit

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/

PG Day France is the major French-speaking PostgreSQL community event.
It will be held June 13, 2013 in Nantes, France.
http://pgday.fr/

PostgreSQL Brazil will be held August 15-17, 2013 in Porto Velho, RO,
Brazil.
http://pgbr.postgresql.org.br/2013/chamada.en.php

Save The Date!
Postgres Open 2013 will be in Chicago, IL, USA, September 16-18.
Hotel Sax:
https://reservations.ihotelier.com/crs/g_reservation.cfm?groupID=888761&hotelID=6865
Early Bird registration:
http://postgresopen-eac2.eventbrite.com/

PGConf.EU 2013 will be held on Oct 29-Nov 1, in at the Conrad Hotel in
downtown Dublin, Ireland.
http://2013.pgconf.eu/

== 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(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot) Spanish language
to pwn(at)arpug(dot)com(dot)ar(dot)

== Applied Patches ==

Tom Lane pushed:

- Improve GiST index search performance for trigram regex queries.
The initial coding just descended the index if any of the target
trigrams were possibly present at the next level down. But actually
we can apply trigramsMatchGraph() so as to take advantage of AND
requirements when there are some. The input data might contain
false positive matches, but that can only result in a false positive
result, not false negative, so it's safe to do it this way.
Alexander Korotkov
http://git.postgresql.org/pg/commitdiff/410bed2ab8c3864d7f34f9694d080adcaf446352

- Don't try to pass -I switch to postmaster in
contrib/start-scripts/linux. Undo thinko in commit
87306184580c9c49717b00d48a2f9e717f21e0a8. Per bug #8098 from
Catherine Devlin.
http://git.postgresql.org/pg/commitdiff/3353583d7ecf7c9f8bc5966ed0a2537dec71ffdc

- Improve error message when an FDW doesn't support WHERE CURRENT OF.
If an FDW fails to take special measures with a CurrentOfExpr, we
will end up trying to execute it as an ordinary qual, which was
being treated as a purely internal failure condition. Provide a
more user-oriented error message for such cases.
http://git.postgresql.org/pg/commitdiff/6e481ebff6368cb0ab5351a5ef3463747c35af22

- Fix longstanding race condition in plancache.c. When creating or
manipulating a cached plan for a transaction control command
(particularly ROLLBACK), we must not perform any catalog accesses,
since we might be in an aborted transaction. However, plancache.c
busily saved or examined the search_path for every cached plan. If
we were unlucky enough to do this at a moment where the path's
expansion into schema OIDs wasn't already cached, we'd do some
catalog accesses; and with some more bad luck such as an ill-timed
signal arrival, that could lead to crashes or Assert failures, as
exhibited in bug #8095 from Nachiket Vaidya. Fortunately, there's
no real need to consider the search path for such commands, so we
can just skip the relevant steps when the subject statement is a
TransactionStmt. This is somewhat related to bug #5269, though the
failure happens during initial cached-plan creation rather than
revalidation. This bug has been there since the plan cache was
invented, so back-patch to all supported branches.
http://git.postgresql.org/pg/commitdiff/ac63dca607e8e22247defbc8fe03b6baa3628c42

Andrew Dunstan pushed:

- Correct handling of NULL arguments in json funcs. Per gripe from
Tom Lane.
http://git.postgresql.org/pg/commitdiff/728ec9731fb0b3f2de8ce66a394b71c64930f445

- Mark json IO and extraction functions immutable. Per complaint from
Hubert Depesz Lubaczewski. Catalog version bumped.
http://git.postgresql.org/pg/commitdiff/d788121aba3425b5d52fe20cc9facb6aca1294ce

Peter Eisentraut pushed:

- Fix function return type confusion When parse_hba_line's return type
was changed from bool to a pointer, the MANDATORY_AUTH_ARG macro
wasn't adjusted.
http://git.postgresql.org/pg/commitdiff/c74d586d2fc8aeaa303d8c60a8a9d959fdc5e791

- doc: Update PQgetssl() documentation. The return type of PQgetssl()
was changed from SSL* to void* a long time ago, but the
documentation was not updated.
http://git.postgresql.org/pg/commitdiff/b9bdaf3964a1fbd32e6140eb180dfa82ff1d8f23

- Standardize spelling of "nonblocking". Only adjusted the
user-exposed messages and documentation, not all source code
comments.
http://git.postgresql.org/pg/commitdiff/acd5803053eb5ff6ad055ac1f7670625f1d111e0

- Clean up references to SQL92. In most cases, these were just
references to the SQL standard in general. In a few cases, a
contrast was made between SQL92 and later standards -- those have
been kept unchanged.
http://git.postgresql.org/pg/commitdiff/cc26ea9fe2e41e73c955ea75bea7a77fbd062d64

- doc: Mention SATA alongside IDE for Linux. suggested by Jov
http://git.postgresql.org/pg/commitdiff/540ec93e33c4eea7da502e8a4e76e5de4b994ac1

- doc: Fix syntax in example. LANGUAGE 'plpgsql' no longer works.
The single quotes need to be removed. Erwin Brandstetter
http://git.postgresql.org/pg/commitdiff/53ecfddcebbf607badc678e294bf977334b79327

- doc: Improve example formatting. Erwin Brandstetter
http://git.postgresql.org/pg/commitdiff/e7d5ffe8ea9883f1b472036dfc098d555f5cd3ea

Heikki Linnakangas pushed:

- Remove some unused and seldom used fields from RelationAmInfo. This
saves some memory from each index relcache entry. At least on a
64-bit machine, it saves just enough to shrink a typical relcache
entry's memory usage from 2k to 1k. That's nice if you have a lot of
backends and a lot of indexes.
http://git.postgresql.org/pg/commitdiff/87ae9e72654ddddf25433b8a178e9268cf03f5b5

Bruce Momjian pushed:

- pgindent: add newline to die() so script line number is not
reported on failure.
http://git.postgresql.org/pg/commitdiff/d61dddba37c27b1b5157b493bd04913c23ade7c2

- pg_upgrade: Add checksum C comment. We might eventually allow
checksum to no-checksum upgrades.
http://git.postgresql.org/pg/commitdiff/5286963066ce7420d80882528b5f07c28f39eacf

- Publish draft 9.3 release notes. No links added yet.
http://git.postgresql.org/pg/commitdiff/e9a35c2082e638c34567db1b5738f355475811d6

- Reorder some 9.3 release item entries. More to go.
http://git.postgresql.org/pg/commitdiff/61b962345dd87276452922a5dbc21836266b43e0

- Fix Gilles Darold's name in 9.3 release notes.
http://git.postgresql.org/pg/commitdiff/488eb9055d3135268fdb401953f395885829d2f4

- Push 9.3 release SGML file. Forgotten in previous commit.
http://git.postgresql.org/pg/commitdiff/22f956f50cac33287daf76d79890057ba2fb3789

- More 9.3 release note reorderings
http://git.postgresql.org/pg/commitdiff/f0922cbdcc54a11ea7eef955763aab4d540bf22f

- Adjust 9.3 release notes per request from Simon Riggs.
http://git.postgresql.org/pg/commitdiff/864ec2f0cd5dd2ba5a7b40cc150cecb3010f739c

- 9.3 release note fixes. Move commit_delay, fix Zoltan's name, and
adjust range type histogram text.
http://git.postgresql.org/pg/commitdiff/ac96e6a8c2c5477344e78840e689e39e7b7b3cf1

- Remove 9.3 item about fixing DROP INDEX CONCURRENTLY. Already fixed
in back branch.
http://git.postgresql.org/pg/commitdiff/1f2236edd1876a8718453f7d4e8e7fdef378c91e

- 9.3 release note adjustments per request from Andres Freund
http://git.postgresql.org/pg/commitdiff/4be535e2e44025975814937818c899fed7aafca3

- Reorder 9.3 release note items. Typo fix from David Fetter.
http://git.postgresql.org/pg/commitdiff/ef3defcf0d507abb75d9e9696f11b44f4fc09291

- In 9.3 release notes, split up items. Split log shipping speed
improvement and fail-over speed improvement items. Per request from
Simon Riggs
http://git.postgresql.org/pg/commitdiff/c3ab4ea27d5e2cd341fc189eb413909f177d835e

Robert Haas pushed:

- sepgsql: One more getObjectIdentity in lieu of getObjectDescription.
KaiGai Kohei, based on a suggestion from Álvaro Herrera
http://git.postgresql.org/pg/commitdiff/0bf5c548d64b66b92197c6d8490b9b131ba02269

- sepgsql: Minor improvement to test script, doc fix. KaiGai Kohei
http://git.postgresql.org/pg/commitdiff/f050457978f4f8deb1ac850439bf7c46c818f4ae

- Fix typo in comment. Fabrízio de Royes Mello
http://git.postgresql.org/pg/commitdiff/4580a4bd2c858acf85c578609b8373d730a04534

== Rejected Patches (for now) ==

Colin 't Hart's patch to add \ns as a short cut for SET search_path in
psql.

== Pending Patches ==

Simon Riggs sent in three revisions of a patch to optimize COPY for
some kinds of volatile expressions.

Bruce Momjian sent in a patch to reformat pg_test_fsync's output in a
more compact way.

Robert Haas sent in a patch to prevent pg_restore from restoring into
the pg_catalog schema by accident.

Ants Aasma sent in two more revisions of a patch to implement page
checksums, including variously optimizable algorithms for same.

Fabrízio de Royes Mello sent in two revisions of a patch to include
currval() for discarding in DISCARD ALL.