== PostgreSQL Weekly News - May 26 2013 ==

== PostgreSQL Weekly News - May 26 2013 ==

Congratulations to the new committers, Jeff Davis, Stephen Frost,
Fujii Masao, and Noah Misch!

We're going to have a booth at OSCON this year. Please sign up and
hang out at the booth for an hour or two:
https://wiki.postgresql.org/wiki/Oscon_2013_signup

The CfP for PGConf.DE is open through September 15, 2013.
https://www.postgresql.eu/events/speakerprofile/pgconfde2013/

PGDay UK 2013 is now open for registration.
http://postgresqlusergroup.org.uk

The Call for Papers for pgconf.eu 2013 is open.
http://2013.pgconf.eu/

== PostgreSQL Product News ==

openBarter 0.8.0, a postgres extension implementing primitives of a
barter market place model, released.
http://pgxn.org/dist/openbarter/0.8.0/

dbExpress driver for PostgreSQL 3.2 released.
http://www.devart.com/dbx/postgresql/

== PostgreSQL 9.3 Feature of the Week ==

== PostgreSQL Tip of the Week ==

== PostgreSQL Jobs for May ==

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

== PostgreSQL Local ==

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). 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/

PGDay UK 2013 is July 12, 2013.
http://postgresqlusergroup.org.uk

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, 2013 at the Conrad Hotel
in downtown Dublin, Ireland.
http://2013.pgconf.eu/

PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen.
http://2013.pgconf.de/

== 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 ==

Heikki Linnakangas pushed:

- Fix escaping in generated recovery.conf file. In the
primary_conninfo line that "pg_basebackup -R" generates, single
quotes in parameter values need to be escaped into \\'; the libpq
parser requires the quotes to be escaped into \', and recovery.conf
parser requires the \ to be escaped into \\. Also, don't quote
parameter values unnecessarily, to make the connection string
prettier. Most options in a libpq connection string don't need
quoting. Reported by Hari Babu, closer analysis by Zoltan
Boszormenyi, although I didn't use his patch.
http://git.postgresql.org/pg/commitdiff/30b5ede7157e34e77c7914b8ecfd55aa8da6edc3

- Print line number correctly in COPY. When COPY uses the
multi-insert method to insert a batch of tuples into the heap at a
time, incorrect line number was printed if something went wrong in
inserting the index tuples (primary key failure, for exampl), or
processing after row triggers. Fixes bug #8173 reported by Lloyd
Albin. Backpatch to 9.2, where the multi- insert code was added.
http://git.postgresql.org/pg/commitdiff/e2ef289363f52b9dd5950c88a65803b585d86ad8

- Remove pageinspect--1.0.sql We're not installing it anymore.
Michael Paquier
http://git.postgresql.org/pg/commitdiff/230e92c82b9b911ea743dce7ab7a1abcd0250f30

Peter Eisentraut pushed:

- Documentation spell checking and markup improvements
http://git.postgresql.org/pg/commitdiff/256f6ba78a379733ff05d3c3d2239ca7fc56fb9e

Bruce Momjian pushed:

- 9.3 release docs: fix DROP TABLE IF EXISTS. Patch from Joe Abbate.
http://git.postgresql.org/pg/commitdiff/efc7952c89f3079c86156fae313255eadcd4a5e7

- 9.3 release notes: fix SGML markup for DROP TABLE IF EXISTS
http://git.postgresql.org/pg/commitdiff/8955dac2518b47cf902c22e972426309217c7d8a

- 9.3 release notes: improve cached plan mention Per suggestion from
Tom Lane.
http://git.postgresql.org/pg/commitdiff/bc41ef4791eb44709f18c1678957509e23abdf98

Simon Riggs pushed:

- Maintain ThisTimeLineID correctly in checkpointer. checkpointer
needs to reset ThisTimeLineID after a restartpoint to allow
installing/recycling new WAL files. If recovery has already ended
this would leave ThisTimeLineID set incorrectly and so we must reset
it otherwise later checkpoints do not have the correct timeline.
Bug report by Heikki Linnakangas. Further investigation by Heikki
and myself.
http://git.postgresql.org/pg/commitdiff/75a192638f93636a144a02461baae90b9fe98fd7

- After fast promotion use CHECKPOINT_FORCE. Not necessary for
correctness, just to make log_checkpoints output look less singular.
Requested by Fujii Masao
http://git.postgresql.org/pg/commitdiff/22a27ef113d50cad73097c0be247f06d6527363c

Robert Haas pushed:

- Fix typo in comment. Pavan Deolasee
http://git.postgresql.org/pg/commitdiff/6eb971bd64073d5208ad7c51aa36b75089d55bef

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Chris Farmiloe sent in a WIP patch to implement ASYNC privileges.

Dean Rasheed sent in another revision of a patch to make views atop
foreign tables writeable in the cases where they would have been
writeable as local tables.

Heikki Linnakangas sent in another revision of a patch to improve
LWLocks by using the native compare-and-swap instruction on the
architectures where it is available.

Simon Riggs sent in a patch to make it possible to set work_mem in TB.

Robert Haas sent in two revisions of a patch to implement MVCC catalog
access.

Robins Tharakan sent in a patch to add more regression tests for
CREATE OPERATOR.

Robins Tharakan sent in a patch to add more regression tests for ALTER
OPERATOR FAMILY.. ADD / DROP.

Robins Tharakan sent in a patch to add more regression tests for LOCK
TABLE.

Fabrízio de Royes Mello sent in a patch to make .gitignore ignore tags
and .swp files.

Jon Nelson sent in another revision of a patch to use fallocate or
posix_fallocate, depending which one is available, to speed new WAL
file creation.

Gurjeet Singh sent in two revisions of a patch to make large chains of
AND and OR not break the parser.

Robins Tharakan sent in a patch to add more regression tests for SET.

Maciej Gajewski sent in a patch to enable searching through the
history of prior results in psql.