== PostgreSQL Weekly News - September 07 2014 == - Mailing list pgsql-announce

== PostgreSQL Weekly News - September 07 2014 ==

The fifth edition of the Argentinian PostgreSQL Day will be held on
November 28th, 2014 in Santa Fe, Argentina.  The International CfP is
open through September 28th, 2014.
http://www.postgresql.org.ar/pgday2014

PGDay Campinas 2014 will take place in Campinas on September 10th.
Sign-up is still open.
http://pgdaycampinas.com.br/

== PostgreSQL Product News ==

DSL, a Domain Specification Language compiler designed to allow using
PostgreSQL as an OO data store, released.
https://dsl-platform.com/

pgpool-II 3.3.4, 3.2.9, 3.1.12, and 3.0.16 released.
http://pgpool.net/mediawiki/index.php/Downloads

== PostgreSQL Jobs for September ==

http://archives.postgresql.org/pgsql-jobs/2014-09/threads.php

== PostgreSQL Local ==

Postgres Open 2014 will be in Chicago, IL, USA, September 17-19.
Tickets and Tutorials now available for purchase.
https://postgresopen.org/2014/tickets/
http://postgresopen.org/2014/callforpapers/

The 4th PgDay Ecuador will be held on Tuesday 7th in October at the
city of Quito, as part of the 5th International Congress of Free
Software.  Send talk proposals to ecpug AT postgresql DOT org.

The sixth PGDay Cubano be held on 13 and 14 October 2014 in Habana.
https://postgresql.uci.cu/?p=380

PGConf.EU 2014 in Madrid, Spain on October 21-24 is now open for
registration.
http://2014.pgconf.eu/registration/

PGDay.IT 2014 will take place in Prato on November the 7th 2014.  The
International Call For Papers is now open:
http://2014.pgday.it/call-for-papers-en/

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

Andres Freund pushed:

- Fix s/pluggins/plugins/ typo in two comments.  Michael Paquier
  http://git.postgresql.org/pg/commitdiff/5a64cb740dc7de868a1395a53778686c0a72f6a7

- Add valgrind suppression for padding bytes in twophase records.
  http://git.postgresql.org/pg/commitdiff/9a0a12f683235d3e10b873baba974f6414297a7e

- Add skip-empty-xacts option to test_decoding for use in the
  regression tests.  The regression tests for contrib/test_decoding
  regularly failed on postgres instances that were very slow. Either
  because the hardware itself was slow or because very expensive
  debugging options like CLOBBER_CACHE_ALWAYS were used.  The reason
  they failed was just that some additional transactions were decoded.
  Analyze and vacuum, triggered by autovac.  To fix just add a option
  to test_decoding to only display transactions in which a change was
  actually displayed. That's not pretty because it removes information
  from the tests; but better than constantly failing tests in very
  likely harmless ways.  Backpatch to 9.4 where logical decoding was
  introduced.  Discussion: 20140629142511.GA26930@awork2.anarazel.de
  http://git.postgresql.org/pg/commitdiff/d6fa44fce7c27459e2d7a46cca18779b765c8b15

- Add psql PROMPT variable showing which line of a statement is being
  edited.  The new %l substitution shows the line number inside a
  (potentially multi-line) statement starting from one.  Author:
  Sawada Masahiko, heavily editorialized by me.  Reviewed-By: Jeevan
  Chalke, Alvaro Herrera
  http://git.postgresql.org/pg/commitdiff/51bb79569f934ad2135c2ff859c61b9ab8d51750

Tom Lane pushed:

- Fix unportable use of isspace().  Introduced in commit 11a020eb6.
  http://git.postgresql.org/pg/commitdiff/01b6976c13a9cf87f3c6767c9722576166c1b081

- Documentation fix: sum(float4) returns float4, not float8.  The old
  claim is from my commit d06ebdb8d3425185d7e641d15e45908658a0177d of
  2000-07-17, but it seems to have been a plain old thinko;
  sum(float4) has been distinct from sum(float8) since Berkeley days.
  Noted by KaiGai Kohei.  While at it, mention the existence of
  sum(money), which is also of embarrassingly ancient vintage.
  http://git.postgresql.org/pg/commitdiff/0640c1bfc09138f136fc1239d2c27b6d37f7d1af

Fujii Masao pushed:

- Support ALTER SYSTEM RESET command.  This patch allows us to execute
  ALTER SYSTEM RESET command to remove the configuration entry from
  postgresql.auto.conf.  Vik Fearing, reviewed by Amit Kapila and me.
  http://git.postgresql.org/pg/commitdiff/bd3b7a9eef6fd8d71ad9aa5eaf1f90e904e96f0b

- Allow \watch to display query execution time if \timing is enabled.
  Previously \watch could not display the query execution time even
  when \timing was enabled because it used PSQLexec instead of
  SendQuery and that function didn't support \timing. This patch
  introduces PSQLexecWatch and changes \watch so as to use it,
  instead.  PSQLexecWatch is the function to run the query, print its
  results and display how long it took (only when \timing is enabled).
  This patch also changes --echo-hidden so that it doesn't print the
  query that \watch executes. Since \watch cannot execute backslash
  command queries, they should not be printed even when --echo-hidden
  is set.  Patch by me, review by Heikki Linnakangas and Michael
  Paquier
  http://git.postgresql.org/pg/commitdiff/f6f654ff12c527310ddbeaf53d463d22ab46ee2c

- Fix segmentation fault that an empty prepared statement could cause.
  Back-patch to all supported branches.  Per bug #11335 from Haruka
  Takatsuka
  http://git.postgresql.org/pg/commitdiff/a73c9dbab0165b3395dfe8a44a7dfd16166963c4

- Add tab-completion for reloptions like user_catalog_table.
  Back-patch to 9.4 where user_catalog_table was added.  Review by
  Michael Paquier
  http://git.postgresql.org/pg/commitdiff/d85e7fac415722bccc83dc96baccdb398ea5a2f4

Heikki Linnakangas pushed:

- Silence warning on new versions of clang.  Andres Freund
  http://git.postgresql.org/pg/commitdiff/26f8b99b248aae989e63ca0969a746f30b0c8c21

- Refactor per-page logic common to all redo routines to a new
  function.  Every redo routine uses the same idiom to determine what
  to do to a page: check if there's a backup block for it, and if not
  read, the buffer if the block exists, and check its LSN. Refactor
  that into a common function, XLogReadBufferForRedo, making all the
  redo routines shorter and more readable.  This has no user-visible
  effect, and makes no changes to the WAL format.  Reviewed by Andres
  Freund, Alvaro Herrera, Michael Paquier.
  http://git.postgresql.org/pg/commitdiff/f8f4227976a2cdb8ac7c611e49da03aa9e65e0d2

- Check number of parameters in RAISE statement at compile time.  The
  number of % parameter markers in RAISE statement should match the
  number of parameters given. We used to check that at execution time,
  but we have all the information needed at compile time, so let's
  check it at compile time instead. It's generally better to find
  mistakes earlier.  Marko Tiikkaja, reviewed by Fabien Coelho
  http://git.postgresql.org/pg/commitdiff/c1008f0037ec9c738127c2fa6d7f6c88d885f45f

Bruce Momjian pushed:

- Issue clearer notice when inherited merged columns are moved.
  CREATE TABLE INHERIT moves user-specified columns to the location of
  the inherited column.  Report by Fatal Majid
  http://git.postgresql.org/pg/commitdiff/4011f8c98bd8bb67715449d2db5fc97dffa6a41f

- Document use of partial indexes for partial unique constraints.
  Report by Tomáš Greif Backpatch through 9.4
  http://git.postgresql.org/pg/commitdiff/4b224011751d1d4a300a0a179fc006658c6868a3

- Update URL reference material in /contrib/isn docs.  Report by Peter
  Eisentraut
  http://git.postgresql.org/pg/commitdiff/4b91ade41fcda805a50e136edad7f95d8f35a7a9

- Rename C variables in formatting.c, for clarity.  Also add C
  comments.  This should help future debugging of this notorious file.
  http://git.postgresql.org/pg/commitdiff/a9c22d1480aa8e6d97a000292d05ef2b31bbde4e

- Clarify documentation about "peer" rows in window functions.  Peer
  rows are matching rows when ORDER BY is specified.  Report by
  arnaud.mouronval@gmail.com, David G Johnston
  http://git.postgresql.org/pg/commitdiff/1f4d1074c5d83a682e71104114211f6ddee129a5

- pg_upgrade:  preserve the timestamp epoch.  This is useful for
  replication tools like Slony and Skytools.  Report by Sergey
  Konoplev
  http://git.postgresql.org/pg/commitdiff/a74a4aa23bb95b590ff01ee564219d2eacea3706

- Report timezone offset in pg_dump/pg_dumpall.  Use consistent format
  for all such displays.  Report by Gavin Flower
  http://git.postgresql.org/pg/commitdiff/ad5d46a4494b0b480a3af246bb4227d9bdadca37

- Properly document that -r is only honored from the command-line.
  This is for postgres/postmaster options.  Report by Tom Lane
  Backpatch through 9.4
  http://git.postgresql.org/pg/commitdiff/d42f67c52af19c4301561608f8f5dba6ae504c67

- docs:  Improve pg_isready details about username/dbname.  Report by
  Erik Rijkers.  Backpatch through 9.4
  http://git.postgresql.org/pg/commitdiff/465b52e74ca1994d6ee2d5d345a4c09ca3d02f18

Robert Haas pushed:

- Update comment to reflect commit
  1d41739e5a04b0e93304d24d864b6bfa3efc45f2.  Peter Geoghegan
  http://git.postgresql.org/pg/commitdiff/d8d4965dc29263462932be03d4206aa694e2cd7e

Peter Eisentraut pushed:

- doc: Remove dead link.  The link to the NIST web page about DES
  standards leads to nowhere, and according to archive.org has been
  forwarded to an unrelated page for many years.  Therefore, just
  remove that link.  More up to date information can be found via
  Wikipedia, for example.
  http://git.postgresql.org/pg/commitdiff/8b896abe8eb5ff85ba92710e4a1f0f28097d3ac3

- Assorted message fixes and improvements
  http://git.postgresql.org/pg/commitdiff/303f4d1012a20102d9fec6f486da0b381184a718

Stephen Frost pushed:

- Tab completion for ALTER .. ALL IN TABLESPACE.  Update the tab
  completion for the changes made in
  3c4cf080879b386d4ed1814667aca025caafe608, which rework 'MOVE ALL' to
  be 'ALTER .. ALL IN TABLESPACE'.  Fujii Masao Back-patch to 9.4, as
  the original change was.
  http://git.postgresql.org/pg/commitdiff/b2de2a1172d52b9a9596d4366e758749cc586f2b

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Kyotaro HORIGUCHI sent in a patch to make the local_preload_libraries
GUC PGC_USERSET.

Kyotaro HORIGUCHI sent in two revisions of a patch to fix some odd
behavior in the PostgreSQL FDW.

Michael Paquier sent in two related patches: one to refactor
the IDENTIFY_SYSTEM and replslot create/drop APIs, the other to add
support for --create and --drop in pg_receivexlog.

Peter Geoghegan sent in another revision of a patch to add INSERT ...
ON CONFLICT {UPDATE | IGNORE}.

Alexey Klyukin sent in two more revisions of a patch to implement
subject alternative names support for SSL connections.

Stepan Rutz and Tom Lane traded patches to help support psql better on
OSX and other libedit-based platforms.

Petr (PJMODOS) Jelinek sent in two more revisions of a patch to add
built-in binning functions.

Tomonari Katsumata sent in another revision of a patch to allow
rounding up time value less than its unit.

David Johnston sent in a patch to reorganize the documentation for
server configuration settings.

Kyotaro HORIGUCHI and Heikki Linnakangas traded patches to escape from
blocked send().

Amit Kapila sent in two more revisions of a patch to scale shared
buffer eviction.

Peter Geoghegan sent in another flock of patches to add B-Tree support
function number 3 (strxfrm() optimization).

Pavel Stehule and Stephen Frost traded patches to allow row_to_json to
ignore nulls.

Tomas Vondra sent in two more revisions of a patch to create a
memory-bounded HashAgg.

Pavel Stehule sent in two more revisions of a patch to add
--help=variables to psql.

Peter Eisentraut sent in a patch to fix analyze in stages.

Bruce Momjian sent in two revisions of a patch to display timestamp in
pg_dump custom format.

Euler Taveira de Oliveira sent in a patch to treat unset units and
empty space units as equivalent for GUCs.

Kaigai Kouhei sent in another revision of a patch to create a custom
scan API.

Furuya Osamu sent in another revision of a patch to add --reply-fsync
to pg_receivexlog --status-interval.

Marko (johto) Tiikkaja sent in another revision of a patch to add PGP
signatures to the pgcrypto contrib extension.

Joachim Wieland sent in another revision of a patch to eliminate
global variables in pg_dump.

Pavel Stehule sent in a WIP patch to allow EXPLAINing a running query.

Oskari Saarenmaa sent in a patch to optionally emit warnings when
column or table aliases are used without the AS keyword.

Adam Brightwell sent in another revision of a patch to implement
row-level access controls.

Marko (johto) Tiikkaja sent in a patch to allow adding a a nullable
DOMAIN column with a CHECK constraint in it.

Peter Geoghegan sent in another revision of a patch to state the
significance of Lehman & Yao in the nbtree README.

Emre Hasegeli sent in another revision of a patch to add selectivity
estimation for inet operators.

Kostya Kuznetzov sent in a patch to recode vacuum in order to
accommodate GiST indexes.