== PostgreSQL Weekly News - July 13 2014 == - Mailing list pgsql-announce

== PostgreSQL Weekly News - July 13 2014 ==

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.

== PostgreSQL Product News ==

Slony-I 2.2.3, a trigger-based replication system for PostgreSQL, released.
http://www.slony.info/

== PostgreSQL Jobs for July ==

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

== PostgreSQL Local ==

PgDay Portland, Oregon 2014 will be held Saturday September 6, 2014.
https://wiki.postgresql.org/wiki/PDXPUGDay2014

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

Bruce Momjian pushed:

- pg_upgrade: allow upgrades for new-only TOAST tables.  Previously,
  when calculations on the need for toast tables changed, pg_upgrade
  could not handle cases where the new cluster needed a TOAST table
  and the old cluster did not.  (It already handled the opposite
  case.)  This fixes the "OID mismatch" error typically generated in
  this case.  Backpatch through 9.2
  http://git.postgresql.org/pg/commitdiff/3088cc37044a303fc50857d8d9e7e44b5c250642

- Adjust blank lines around PG_MODULE_MAGIC defines, for consistency.
  Report by Robert Haas
  http://git.postgresql.org/pg/commitdiff/6a605cd6bd9f689b35676623add0de9b90978bf1

Tom Lane pushed:

- In pg_dump, show server and pg_dump versions with or without
  --verbose.  We used to print this information only in verbose mode,
  but it's argued that it's useful enough to print always; one reason
  being that this provides some documentation about which Postgres
  versions the dump is meant to reload into.  Jing Wang, reviewed by
  Jeevan Chalke
  http://git.postgresql.org/pg/commitdiff/7700597b34fbb26e377f419271f65be1c13c518f

- Don't assume a subquery's output is unique if there's a SRF in its
  tlist.  While the x output of "select x from t group by x" can be
  presumed unique, this does not hold for "select x,
  generate_series(1,10) from t group by x", because we may expand the
  set-returning function after the grouping step.  (Perhaps that
  should be re-thought; but considering all the other oddities
  involved with SRFs in targetlists, it seems unlikely we'll change
  it.) Put a check in query_is_distinct_for() so it's not fooled by
  such cases.  Back-patch to all supported branches.  David Rowley
  http://git.postgresql.org/pg/commitdiff/9e2f2d7a0539460dc76dbf76dfae17024d5e031e

- Implement IMPORT FOREIGN SCHEMA.  This command provides an automated
  way to create foreign table definitions that match remote tables,
  thereby reducing tedium and chances for error.  In this patch, we
  provide the necessary core-server infrastructure and implement the
  feature fully in the postgres_fdw foreign-data wrapper.  Other
  wrappers will throw a "feature not supported" error until/unless
  they are updated.  Ronan Dunklau and Michael Paquier, additional
  work by me
  http://git.postgresql.org/pg/commitdiff/59efda3e50ca4de6a9d5aa4491464e22b6329b1e

- Fix bug with whole-row references to append subplans.
  ExecEvalWholeRowVar incorrectly supposed that it could "bless" the
  source TupleTableSlot just once per query.  But if the input is
  coming from an Append (or, perhaps, other cases?) more than one slot
  might be returned over the query run.  This led to "record type has
  not been registered" errors when a composite datum was extracted
  from a non-blessed slot.  This bug has been there a long time; I
  guess it escaped notice because when dealing with subqueries the
  planner tends to expand whole-row Vars into RowExprs, which don't
  have the same problem.  It is possible to trigger the problem in all
  active branches, though, as illustrated by the added regression
  test.
  http://git.postgresql.org/pg/commitdiff/d68581483564ec0fbfdc255e493c4f5bd165e55e

Fujii Masao pushed:

- Fix typo in comment.  This typo was accidentally added by recent
  commit 4cbd128.
  http://git.postgresql.org/pg/commitdiff/6048896e4c9679cba89242d77f02ceba01c791d1

- Fix typos in comments.
  http://git.postgresql.org/pg/commitdiff/4cbd12832839830fe58bb5d9d4ba7e2ec84952ce

- Add new ECHO mode 'errors' that displays only failed commands in
  psql.  When the psql variable ECHO is set to 'erros', only failed
  SQL commands are printed to standard error output. Also this patch
  adds -b option into psql.  This is equivalent to setting the
  variable ECHO to 'errors'.  Pavel Stehule, reviewed by Fabrízio de
  Royes Mello, Samrat Revagade, Kumar Rajeev Rastogi, Abhijit
  Menon-Sen, and me.
  http://git.postgresql.org/pg/commitdiff/5b214c5dd1de37764797b3fb9164af3c885a7b86

Peter Eisentraut pushed:

- doc: Fix spacing in verbatim environments
  http://git.postgresql.org/pg/commitdiff/53166fe248c1b4b211094e80e54e5ab330dbf957

- doc: Link text to table by id
  http://git.postgresql.org/pg/commitdiff/889313c76b2d0f3388e3008fb309bb71d4c9978b

- Update key words table for 9.4
  http://git.postgresql.org/pg/commitdiff/56abcf6b829adcbadcc73e4eb06caefb50d110bd

- Fix whitespace
  http://git.postgresql.org/pg/commitdiff/8522f21400570fdf6af38c32a2522a5465dccfd5

- Fix whitespace
  http://git.postgresql.org/pg/commitdiff/80ddd04b4d66ad6564b6d77ffc2bd8fb5e0dcdfa

Robert Haas pushed:

- Improve error messages for bytea decoding failures.  Craig Ringer
  http://git.postgresql.org/pg/commitdiff/f73474382cb304b4f043e5de89c28b0365c04156

- Fix error hint style.  Mistake caught by Tom Lane.
  http://git.postgresql.org/pg/commitdiff/b043985b7aaf62f6978a0c567c8340ad9cf1ad67

Magnus Hagander pushed:

- Add autocompletion of locale keywords for CREATE DATABASE.  Adds
  support for autocomplete of LC_COLLATE and LC_CTYPE to the CREATE
  DATABASE command in psql.
  http://git.postgresql.org/pg/commitdiff/deee42ab015d54baa1b9e0165bf3635dab4f9f7a

- Support --with-extra-version equivalent functionality in MSVC build.
  Adds a configuration parameter, extraver, that is appended to the
  version number when built.  Michael Paquier, reviewed by Muhammad
  Asif Naeem
  http://git.postgresql.org/pg/commitdiff/8d9a0e85bd6ab4fe5268a1d759a787f72ff9333e

Andres Freund pushed:

- Fix decoding of consecutive MULTI_INSERTs emitted by one
  heap_multi_insert().  Commit 1b86c81d2d fixed the decoding of
  toasted columns for the rows contained in one xl_heap_multi_insert
  record. But that's not actually enough, because heap_multi_insert()
  will actually first toast all passed in rows and then emit several
  *_multi_insert records; one for each page it fills with tuples.  Add
  a XLOG_HEAP_LAST_MULTI_INSERT flag which is set in
  xl_heap_multi_insert->flag denoting that this multi_insert record is
  the last emitted by one heap_multi_insert() call. Then use that flag
  in decode.c to only set clear_toast_afterwards in the right
  situation.  Expand the number of rows inserted via COPY in the
  corresponding regression test to make sure that more than one heap
  page is filled with tuples by one heap_multi_insert() call.
  Backpatch to 9.4 like the previous commit.
  http://git.postgresql.org/pg/commitdiff/626bfad6cc5701eb385b8995e1431ad6a5f24928

- Minimal psql tab completion support for SET search_path.  Complete
  SET search_path = ... to non-temporary and non-toast schemas. Since
  there pretty much is no use case to add those to the search path and
  there can be many it's helpful to exclude them.  It'd be nicer to
  complete multiple search path elements, but that's not easy.  Jeff
  Janes
  http://git.postgresql.org/pg/commitdiff/bd409519bd19911d2d2cba64415447d2fa9d766b

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Abhijit Menon-Sen sent in another revision of a patch to introduce
XLogLockBlockRangeForCleanup().

Abhijit Menon-Sen sent in another revision of a patch to add a
--stats option to xlogdump.

Kaigai Kouhei sent in another revision of a patch to implement a
custom plan API.

Etsuro Fujita sent in a WIP patch to optimize updating foreign tables
in the PostgreSQL FDW.

David Rowley sent in two more revisions of a patch to allow removing
LEFT JOINs under certain circumstances.

Haribabu Kommi sent in another revision of a patch to add min() and
max() for the inet data type.

Amit Kapila sent in another revision of a patch to fix an issue with
duplicate parameters in ALTER SYSTEM.

Dilip Kumar sent in another revision of a patch to allow parallel
cores to be used by vacuumdb.

SAWADA Masahiko and Jeevan Chalke traded patches to add line number as
prompt option to psql.

Alvaro Herrera sent in another revision of a patch to add minmax
indexes.

Tomonari Katsumata sent in a patch to ensure that rounding up time
value is not less than its unit.

Furuya Osamu sent in another revision of a patch to add a synchronous
mode to pg_receivexlog.

SAWADA Masahiko sent in a patch to fix an issue in timeout of
pg_receivexlog --status-interval.

Alvaro Herrera sent in a patch to fix the README in anticipation of
another patch for CSN-based snapshots.

Kyotaro HORIGUCHI and Michael Paquier traded patches to fix an issue
in WAL replay.

Jeff Davis sent in another revision of a patch to allow IGNORE NULLS
in the lead() and lag() windowing functions.

Jeff Davis sent in two revisions of a patch to Allow multi-byte
characters as escape in SIMILAR TO and SUBSTRING.

Tom Lane sent in another revision of a patch to allow NOT IN to use
ANTI joins.

Tomas Vondra sent in two more revisions of a patch to tweak
NTUP_PER_BUCKET.

Ali Akbar sent in another revision of a patch to fix xpath() to return
namespace definitions.

Etsuro Fujita sent in a patch to fix an incorrect comment in
postgres_fdw.c.

Christoph Martin sent in a patch to fix the search_path default value
separator.

Etsuro Fujita sent in a patch to add information on exact/lossy blocks
for a bitmap heap scan when both the numbers of exact/lossy pages
retrieved by the node are zero.

Noah Misch sent in a patch to fix an OpenLDAP issue.

Fabrízio de Royes Mello sent in another revision of a patch to add
ALTER TABLE ... SET LOGGED.

Christoph Berg sent in another revision of a patch to secure "make
check."

Magnus Hagander sent in a patch to include SSL compression info in a
psql header.

Emre Hesegeli sent in a patch to add selectivity estimation for inet
operators.

Tomas Vondra sent in another revision of a patch to fix an issue where
bad estimation together with large work_mem generates slow hash joins.