== PostgreSQL Weekly News - June 23 2013 == - Mailing list pgsql-announce

== PostgreSQL Weekly News - June 23 2013 ==

PGDay Italy will be in Prato, Tuscany on October 25, 2013.
Watch this space for more details.

== PostgreSQL Product News ==

pgBadger 3.4, a parallel PostgreSQL log analyzer written in Perl,
released:
https://sourceforge.net/projects/pgbadger/

PG Commander, a PostgreSQL client for OS X, released.
http://eggerapps.at/pgcommander/

PostGIS 2.1.0beta3, the industry standard geographic information
system for PostgreSQL, released.
http://postgis.net/2013/06/22/postgis-2-1-0beta3

psycopg2 2.5.1, a Python connector for PostgreSQL, released.
http://initd.org/psycopg/articles/2013/06/23/psycopg-251-released/

== PostgreSQL Jobs for June ==

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

== PostgreSQL Local ==

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

PGDay UK 2013 is July 12, 2013.  Registration is open.
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

Postgres Open 2013 will be in Chicago, IL, USA, September 16-18.
Early Bird registration and call for presentations closes June 30th.
http://postgresopen.org/

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

PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen.  The CfP is open through September
15, 2013.
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@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.  Spanish language
to pwn@arpug.com.ar.

== Applied Patches ==

Jeff Davis pushed:

- Add buffer_std flag to MarkBufferDirtyHint().  MarkBufferDirtyHint()
  writes WAL, and should know if it's got a standard buffer or not.
  Currently, the only callers where buffer_std is false are related to
  the FSM.  In passing, rename XLOG_HINT to XLOG_FPI, which is more
  descriptive.  Back-patch to 9.3.
  http://git.postgresql.org/pg/commitdiff/b8fd1a09f382f04c41128fded4d56da2127ce92d

Peter Eisentraut pushed:

- psql: Re-allow -1 together with -c or -l
  http://git.postgresql.org/pg/commitdiff/c3c86ae2aff67676a49ec84240f1d6a482f359cb

- initdb: Add blank line before output about checksums.  This
  maintains the logical grouping of the output better.
  http://git.postgresql.org/pg/commitdiff/8df54b9fad9b7954b71c63b86a6c587fc6748099

- Further update CREATE FUNCTION documentation about argument names.
  More languages than SQL and PL/pgSQL actually support parameter
  names.
  http://git.postgresql.org/pg/commitdiff/4c54e87a86d6e73aa3a3b7710fa3db33297792d4

- Clarify terminology standalone backend vs. single-user mode.  Most
  of the documentation uses "single-user mode", so use that in the
  code as well.  Adjust the documentation to match the new error
  message wording.  Also add a documentation index entry for
  "single-user mode".  Based-on-patch-by: Jeff Janes.
  http://git.postgresql.org/pg/commitdiff/7dfd5cd21c0091e467b16b31a10e20bbedd0a836

- doc: Fix date in EPUB manifest.  If there is no <date> element, the
  publication date for the EPUB manifest is taken from the copyright
  year.  But something like "1996-2013" is not a legal date
  specification.  So the EPUB output currently fails epubcheck.  Put
  in a separate <date> element with the current year.  Put it in
  legal.sgml, because copyright.pl already instructs to update that
  manually, so it hopefully won't be missed.
  http://git.postgresql.org/pg/commitdiff/dab1603e5238d3abce9f7a3a7b9450888cc07c70

Simon Riggs pushed:

- Fix docs on lock level for ALTER TABLE VALIDATE.  ALTER TABLE ..
  VALIDATE CONSTRAINT previously gave incorrect details about lock
  levels and therefore incomplete reasons to use the option.  Initial
  bug report and fix from Marko Tiikkaja Reworded by me to include
  comments by Kevin Grittner
  http://git.postgresql.org/pg/commitdiff/073d7cb513f5de44530f4bdbaaa4b5d4cce5f984

- Ensure no xid gaps during Hot Standby startup.  In some cases with
  higher numbers of subtransactions it was possible for us to
  incorrectly initialize subtrans leading to complaints of missing
  pages.  Bug report by Sergey Konoplev.  Analysis and fix by Andres
  Freund.
  http://git.postgresql.org/pg/commitdiff/1f09121b4edee8b4d4cdd4ee0a8cffacee7b85f7

Kevin Grittner pushed:

- Fix the create_index regression test for Danish collation.  In
  Danish collations, there are letter combinations which sort higher
  than 'Z'.  A test for values > 'WA' was picking up rows where the
  value started with 'Ants Aasma', causing the test to fail.
  Backpatch to 9.2, where the failing test was added.  Per report from
  Svenne Krap and analysis by Jeff Janes
  http://git.postgresql.org/pg/commitdiff/8791627b8f9a9ce44603beec447bc6f18bfd9a36

Bruce Momjian pushed:

- Modernize entab source code.  Remove halt.c, improve comments,
  rename manual page file.
  http://git.postgresql.org/pg/commitdiff/f979599b2068f036405f1b51a9c4260619b06941

Fujii Masao pushed:

- Support TB (terabyte) memory unit in GUC variables.  Patch by Simon
  Riggs, reviewed by Jeff Janes and me.
  http://git.postgresql.org/pg/commitdiff/bab54e383dd102001753366d3c124f706c7967dd

Tom Lane pushed:

- Add a comment warning against use of pg_usleep() for long sleeps.
  Follow-up to commit 873ab97219caabeb2f7b390268a4fe01e2b7518c, in
  which I noted that WaitLatch was a better solution in the commit log
  message, but neglected to add any documentation in the code.
  http://git.postgresql.org/pg/commitdiff/8c1a71d36f5d667f3c2236e0e015a48f809ca240

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Fetter sent in another revision of a patch to implement
makeFuncArgs.

Andres Freund sent in a patch to clarify an error message on Linux.

Robins Tharakan sent in another revision of a patch to add regression
tests for SET xxx.

Alexander Korotkov sent in two more revisions of a patch to add more
information to GIN indexes.

Alexander Korotkov sent in two more revisions of a patch to add
ordering in GIN indexes.

Alexander Korotkov sent in two more revisions of a patch to add fast
scan to GIN indexes.

Ian Link sent in a patch to improve the fast GIN cache.

Michael Paquier sent in five more revisions of a patch to implement
REINDEX CONCURRENTLY.

Jeff Davis sent in another revision of a patch to have pg_filedump
take checksums, among other things, into account.

Amit Langote sent in a patch to correct a comment in heaptuple.c.

Cedric Villemain sent in a patch to fix a bug and add new features to
pgxs.

Etsuro Fujita sent in four more revisions of a patch to remove unused
targets.

Nicholas White and Troels Nielsen traded patches to allow the SQL
standard IGNORE/RESPECT NULLS in lead and lag window functions.

Heikki Linnakangas sent in two more revisions of a patch to scale
XLogInserts.

Amit Kapila sent in another revision of a patch to allow changing GUCs
persistently from SQL.

Fabien COELHO sent in another revision of a patch to add long options
to pgbench.

Andres Freund sent in a patch to create a new contrib module: xidfuncs.

Jeff Janes sent in another revision of a patch to add a startup option
to pgbench.

Josh Kupershmidt sent in a patch to rename the specs directory to
something that won't interfer with certain OSs.

Andres Freund sent in another revision of a patch to create
infrastructure for and implement examples of pluggable compressors.

Gurjeet Singh sent in a patch to implement a function
pg_test_reload_conf() which allows you to know whether the changes
you've made to configuration parameters have actually taken effect
after a SIGHUP.

KONDO Mitsumasa sent in another revision of a patch to add --progress
to pgbench.

Andres Freund sent in two more revisions of the set of patches to
implement WAL decoding.

David Fetter sent in another revision of a patch to implement FILTER,
this time without the restriction that certain types of subqueries
couldn't be in the FILTER clause.  Dean Rasheed sent in a patch on top
of same to make FILTER an unreserved word.

Alexander Korotkov sent in a patch to fix an irregularity in trigram
indexes.

Andres Freund sent in a WIP patch to fix a corner case in CASE.

Andrew Dunstan sent in a patch to fix pg_dump for foreign tables in
the pg_upgrade scenario.

Fabien COELHO sent in another revision of a patch to implement CREATE
CAST...AS EXPLICIT.

Simon Riggs and Heikki Linnakangas traded patches to fix how hashes
work in some edge cases.

Fabien COELHO sent in another revision of a patch to implement pgbench --throttle.

Noah Misch sent in another revision of a patch to make Windows behave
better with different encodings.