[COMMITTERS] pgsql: Capitalize names of PLs consistently

2017-04-04 Thread Peter Eisentraut 
Capitalize names of PLs consistently

Author: Daniel Gustafsson 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/afd79873a0b151bfbe5312acebfe361da09c11fd

Modified Files
--
contrib/postgres_fdw/expected/postgres_fdw.out | 2 +-
contrib/postgres_fdw/sql/postgres_fdw.sql  | 2 +-
doc/src/sgml/install-windows.sgml  | 2 +-
doc/src/sgml/parallel.sgml | 4 ++--
doc/src/sgml/plpgsql.sgml  | 2 +-
doc/src/sgml/release-7.4.sgml  | 4 ++--
doc/src/sgml/release-8.0.sgml  | 8 
doc/src/sgml/release-8.1.sgml  | 8 
doc/src/sgml/release-8.2.sgml  | 4 ++--
doc/src/sgml/release-8.3.sgml  | 4 ++--
doc/src/sgml/release-8.4.sgml  | 6 +++---
doc/src/sgml/release-9.4.sgml  | 2 +-
doc/src/sgml/release-old.sgml  | 6 +++---
doc/src/sgml/xfunc.sgml| 2 +-
src/backend/access/transam/README.parallel | 2 +-
src/backend/executor/spi.c | 4 ++--
src/backend/parser/gram.y  | 6 +++---
src/bin/initdb/initdb.c| 2 +-
src/include/parser/scanner.h   | 2 +-
src/pl/plpgsql/src/Makefile| 2 +-
src/pl/plpgsql/src/pl_gram.y   | 4 ++--
src/pl/tcl/Makefile| 2 +-
src/pl/tcl/pltcl.c | 2 +-
23 files changed, 41 insertions(+), 41 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: pageinspect: Add bt_page_items function with bytea argument

2017-04-04 Thread Peter Eisentraut 
pageinspect: Add bt_page_items function with bytea argument

Author: Tomas Vondra 
Reviewed-by: Ashutosh Sharma 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/193f5f9e913f3ead6609cc99be82578e0dedd409

Modified Files
--
contrib/pageinspect/btreefuncs.c  | 198 +++---
contrib/pageinspect/expected/btree.out|  13 ++
contrib/pageinspect/pageinspect--1.5--1.6.sql |  14 ++
contrib/pageinspect/sql/btree.sql |   4 +
doc/src/sgml/pageinspect.sgml |  32 +
src/include/access/nbtree.h   |   1 +
6 files changed, 211 insertions(+), 51 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Follow-on cleanup for the transition table patch.

2017-04-04 Thread Kevin Grittner 
Follow-on cleanup for the transition table patch.

Commit 59702716 added transition table support to PL/pgsql so that
SQL queries in trigger functions could access those transient
tables.  In order to provide the same level of support for PL/perl,
PL/python and PL/tcl, refactor the relevant code into a new
function SPI_register_trigger_data.  Call the new function in the
trigger handler of all four PLs, and document it as a public SPI
function so that authors of out-of-tree PLs can do the same.

Also get rid of a second QueryEnvironment object that was
maintained by PL/pgsql.  That was previously used to deal with
cursors, but the same approach wasn't appropriate for PLs that are
less tangled up with core code.  Instead, have SPI_cursor_open
install the connection's current QueryEnvironment, as already
happens for SPI_execute_plan.

While in the docs, remove the note that transition tables were only
supported in C and PL/pgSQL triggers, and correct some ommissions.

Thomas Munro with some work by Kevin Grittner (mostly docs)

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/5ebeb579b9b281dba5f8415b2fbda86fdae7b366

Modified Files
--
doc/src/sgml/ref/create_trigger.sgml  |  10 +--
doc/src/sgml/spi.sgml | 125 ++
doc/src/sgml/trigger.sgml |  54 +--
src/backend/executor/spi.c|  52 +++
src/include/executor/spi.h|   3 +
src/pl/plperl/expected/plperl_trigger.out |  29 ++
src/pl/plperl/plperl.c|   7 ++
src/pl/plperl/sql/plperl_trigger.sql  |  32 +++
src/pl/plpgsql/src/pl_exec.c  |  49 +-
src/pl/plpgsql/src/plpgsql.h  |   4 -
src/pl/plpython/expected/plpython_trigger.out |  21 +
src/pl/plpython/plpy_exec.c   |   5 ++
src/pl/plpython/sql/plpython_trigger.sql  |  24 +
src/pl/tcl/expected/pltcl_queries.out |  21 +
src/pl/tcl/pltcl.c|   5 ++
src/pl/tcl/sql/pltcl_queries.sql  |  20 +
16 files changed, 398 insertions(+), 63 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Make min_wal_size/max_wal_size use MB internally

2017-04-04 Thread Simon Riggs 
Make min_wal_size/max_wal_size use MB internally

Previously they were defined using multiples of XLogSegSize.
Remove GUC_UNIT_XSEGS. Introduce GUC_UNIT_MB

Extracted from patch series on XLogSegSize infrastructure.

Beena Emerson

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/9a3215026bd6955e88bd8c20542cfe6acffdb1c8

Modified Files
--
src/backend/access/transam/xlog.c | 22 +-
src/backend/utils/misc/guc.c  | 30 ++
src/include/access/xlog.h |  4 ++--
src/include/utils/guc.h   |  2 +-
4 files changed, 30 insertions(+), 28 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix uninitialized variables in twophase.c

2017-04-04 Thread Simon Riggs 
Fix uninitialized variables in twophase.c

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/cd740c0dbfb3038eea2e921e82e2f5345d0718c5

Modified Files
--
src/backend/access/transam/twophase.c | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Force synchronous commit in new-ish test_decoding test.

2017-04-04 Thread Andres Freund 
Force synchronous commit in new-ish test_decoding test.

This was missed in a924c327 ff.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/bae9b8016053c0a434690add7049a9216afef7e2

Modified Files
--
contrib/test_decoding/expected/slot.out | 3 +++
contrib/test_decoding/sql/slot.sql  | 5 +
2 files changed, 8 insertions(+)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix two valgrind issues in slab allocator.

2017-04-04 Thread Andres Freund 
Fix two valgrind issues in slab allocator.

During allocation VALGRIND_MAKE_MEM_DEFINED was called with a pointer
as size. That kind of works, but makes valgrind exceedingly slow for
workloads involving the slab allocator.

Secondly there was an access to memory marked as unreachable within
SlabCheck(). Fix that too.

Author: Tomas Vondra
Discussion: 
https://postgr.es/m/a6543b6d-6015-99b1-63ef-3ed55a76a...@2ndquadrant.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/490e9a98ff964df95311e2b5a68a15f63bce0cfd

Modified Files
--
src/backend/utils/mmgr/slab.c | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Clarify documentation of to_tsvector(json(b))

2017-04-04 Thread Andrew Dunstan 
Clarify documentation of to_tsvector(json(b))

Per gripe from Sven R. Kunze

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/e75a78656bcaa3faff6b85891ca69d45dd21023f

Modified Files
--
doc/src/sgml/func.sgml | 5 -
1 file changed, 4 insertions(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Speedup 2PC recovery by skipping two phase state files in normal

2017-04-04 Thread Simon Riggs 
Speedup 2PC recovery by skipping two phase state files in normal path

2PC state info held in shmem at PREPARE, then cleaned at COMMIT PREPARED/ABORT 
PREPARED,
avoiding writing/fsyncing any state information to disk in the normal path, 
greatly enhancing replay speed.
Prepared transactions that live past one checkpoint redo horizon will be 
written to disk as now.
Similar conceptually to 978b2f65aa1262eb4ecbf8b3785cb1b9cf4db78e and building 
upon
the infrastructure created by that commit.

Authors, in equal measure: Stas Kelvich, Nikhil Sontakke and Michael Paquier
Discussion: 
https://postgr.es/m/CAMGcDxf8Bn9ZPBBJZba9wiyQq-Qk5uqq=vjomnrnw5s+fks...@mail.gmail.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/728bd991c3c4389fb39c45dcb0fe57e4a1dccd71

Modified Files
--
src/backend/access/transam/twophase.c | 821 ++
src/backend/access/transam/xact.c |  18 +-
src/backend/access/transam/xlog.c |  10 +
src/include/access/twophase.h |   7 +-
4 files changed, 550 insertions(+), 306 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Adjust min/max values when changing sequence type

2017-04-04 Thread Peter Eisentraut 
Adjust min/max values when changing sequence type

When changing the type of a sequence, adjust the min/max values of the
sequence if it looks like the previous values were the default values.
Previously, it would leave the old values in place, requiring manual
adjustments even in the usual/default cases.

Reviewed-by: Michael Paquier 
Reviewed-by: Vitaly Burovoy 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/60a0b2ec8943451186dfa22907f88334d97cb2e0

Modified Files
--
doc/src/sgml/ref/alter_sequence.sgml   | 13 ++
src/backend/commands/sequence.c| 43 ++
src/test/regress/expected/sequence.out | 40 +++
src/test/regress/sql/sequence.sql  | 22 ++---
4 files changed, 96 insertions(+), 22 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix thinko in BitmapAdjustPrefetchIterator.

2017-04-04 Thread Robert Haas 
Fix thinko in BitmapAdjustPrefetchIterator.

Dilip Kumar

Discussion: 
http://postgr.es/m/cafitn-ukavrhwprb0i-u9zfoekgqrrwqjp1wvobskzb-uek...@mail.gmail.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/a9a7949134189c29a9b38ac7394c53849684fe4d

Modified Files
--
src/backend/executor/nodeBitmapHeapscan.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix typo

2017-04-04 Thread Peter Eisentraut 
Fix typo

Author: Masahiko Sawada 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/d1f103c7396b667e64141412a8a0d12a2eef2930

Modified Files
--
src/backend/replication/logical/worker.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: psql: Add some missing tab completion

2017-04-04 Thread Peter Eisentraut 
psql: Add some missing tab completion

Add tab completion for COMMENT/SECURITY LABEL ON
PUBLICATION/SUBSCRIPTION.

Reported-by: Stephen Frost 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/553c3bef4cb47bdacb65b87c5460a2775f535a2b

Modified Files
--
src/bin/psql/tab-complete.c | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Remove --verbose from PROVE_FLAGS

2017-04-04 Thread Stephen Frost 
Remove --verbose from PROVE_FLAGS

Per discussion, the TAP tests are really more verbose than necessary, so
remove the --verbose flag from PROVE_FLAGS.  Also add comments to let
folks know how they can enable it if they really wish to, as suggested
by Craig Ringer.

Author: Michael Paquier, additional comments by me.
Discussion: 
https://postgr.es/m/CAMsr%2BYGAzcMDOZ_BirnMCL6Sb%3DMUjP0FRE82YBDSbXcf6pm9Yg%40mail.gmail.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/e9c81b6016f431af808e4c08191e7aecf034dc80

Modified Files
--
src/Makefile.global.in | 3 ++-
src/test/perl/README   | 5 +
2 files changed, 7 insertions(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix remote position tracking in logical replication

2017-04-04 Thread Peter Eisentraut 
Fix remote position tracking in logical replication

We need to set the origin remote position to end_lsn, not commit_lsn, as
commit_lsn is the start of commit record, and we use the origin remote
position as start position when restarting replication stream.  If we'd
use commit_lsn, we could request data that we already received from the
remote server after a crash of a downstream server.

Author: Petr Jelinek 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/fe7bbc4ddb82c635ef08b5eadc5ce472ad515996

Modified Files
--
src/backend/replication/logical/worker.c | 13 +++--
1 file changed, 7 insertions(+), 6 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

[COMMITTERS] pgsql: Fix formula in _hash_spareindex.

2017-04-04 Thread Robert Haas 
Fix formula in _hash_spareindex.

This was correct in earlier versions of the patch that lead to
commit ea69a0dead5128c421140dc53fac165ba4af8520, but somehow got
broken in the last version which I actually committed.

Mithun Cy, per an off-list report from Ashutosh Sharma

Discussion: 
http://postgr.es/m/cad__oujbawnu71v1y-roqxz8lz6-v2uftkex3v34mk6uz3x...@mail.gmail.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/b38006ef6d1ba2f56cc4962ed17956b74c9fa0c4

Modified Files
--
src/backend/access/hash/hashutil.c | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers