[COMMITTERS] pgsql: Fix broken ALTER INDEX documentation

2016-04-05 Thread Alvaro Herrera
Fix broken ALTER INDEX documentation Commit b8a91d9d1c put the description of the new IF EXISTS clause in the wrong place -- move it where it belongs. Backpatch to 9.2. Branch -- REL9_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/fa4eab862b064ded953dfd95218cf99efddf6a90

[COMMITTERS] pgsql: Fix broken ALTER INDEX documentation

2016-04-05 Thread Alvaro Herrera
Fix broken ALTER INDEX documentation Commit b8a91d9d1c put the description of the new IF EXISTS clause in the wrong place -- move it where it belongs. Backpatch to 9.2. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2143f5e127903cb50c10537fc22392083cb033b7 Modifie

[COMMITTERS] pgsql: Fix broken ALTER INDEX documentation

2016-04-05 Thread Alvaro Herrera
Fix broken ALTER INDEX documentation Commit b8a91d9d1c put the description of the new IF EXISTS clause in the wrong place -- move it where it belongs. Backpatch to 9.2. Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff/6929e7f0f481193a101aa721f6afe5e4382b696f

[COMMITTERS] pgsql: Fix broken ALTER INDEX documentation

2016-04-05 Thread Alvaro Herrera
Fix broken ALTER INDEX documentation Commit b8a91d9d1c put the description of the new IF EXISTS clause in the wrong place -- move it where it belongs. Backpatch to 9.2. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/af3d9fdb88cf7346117885bf731a1aa259d83161

[COMMITTERS] pgsql: Fix broken ALTER INDEX documentation

2016-04-05 Thread Alvaro Herrera
Fix broken ALTER INDEX documentation Commit b8a91d9d1c put the description of the new IF EXISTS clause in the wrong place -- move it where it belongs. Backpatch to 9.2. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/209880ba7da708ab8df74dc47b9fad0665807f64

[COMMITTERS] pgsql: Support ALTER THING .. DEPENDS ON EXTENSION

2016-04-05 Thread Alvaro Herrera
Support ALTER THING .. DEPENDS ON EXTENSION This introduces a new dependency type which marks an object as depending on an extension, such that if the extension is dropped, the object automatically goes away; and also, if the database is dumped, the object is included in the dump output. Currentl

[COMMITTERS] pgsql: Fix parallel-safety code for parallel aggregation.

2016-04-05 Thread Robert Haas
Fix parallel-safety code for parallel aggregation. has_parallel_hazard() was ignoring the proparallel markings for aggregates, which is no good. Fix that. There was no way to mark an aggregate as actually being parallel-safe, either, so add a PARALLEL option to CREATE AGGREGATE. Patch by me, re

Re: [COMMITTERS] pgsql: Disallow newlines in parameter values to be set in ALTER SYSTEM.

2016-04-05 Thread Tom Lane
Oleg Bartunov writes: > On Tue, Apr 5, 2016 at 9:05 AM, Oleg Bartunov wrote: >> it's also fixed problem with setting parameter to ''. Before >> alter system SET shared_preload_libraries = ''; > Ooops, it doesn't :( > FATAL: could not access file "": No such file or directory > cat /usr/local/

[COMMITTERS] pgsql: Align all shared memory allocations to cache line boundaries.

2016-04-05 Thread Robert Haas
Align all shared memory allocations to cache line boundaries. Experimentation shows this only costs about 6kB, which seems well worth it given the major performance effects that can be caused by insufficient alignment, especially on larger systems. Discussion: 14166.1458924...@sss.pgh.pa.us Bran

[COMMITTERS] pgsql: Fix PL/Python for recursion and interleaved set-returning functi

2016-04-05 Thread Tom Lane
Fix PL/Python for recursion and interleaved set-returning functions. PL/Python failed if a PL/Python function was invoked recursively via SPI, since arguments are passed to the function in its global dictionary (a horrible decision that's far too ancient to undo) and it would delete those dictiona

Re: [COMMITTERS] pgsql: Implement backup API functions for non-exclusive backups

2016-04-05 Thread Magnus Hagander
On Tue, Apr 5, 2016 at 8:35 PM, Robert Haas wrote: > On Tue, Apr 5, 2016 at 2:11 PM, Magnus Hagander > wrote: > > Implement backup API functions for non-exclusive backups > > > > Previously non-exclusive backups had to be done using the replication > protocol > > and pg_basebackup. With this com

Re: [COMMITTERS] pgsql: Implement backup API functions for non-exclusive backups

2016-04-05 Thread Robert Haas
On Tue, Apr 5, 2016 at 2:11 PM, Magnus Hagander wrote: > Implement backup API functions for non-exclusive backups > > Previously non-exclusive backups had to be done using the replication protocol > and pg_basebackup. With this commit it's now possible to make them using > pg_start_backup/pg_stop_

[COMMITTERS] pgsql: Add parallel query support functions for assorted aggregates.

2016-04-05 Thread Robert Haas
Add parallel query support functions for assorted aggregates. This lets us use parallel aggregate for a variety of useful cases that didn't work before, like sum(int8), sum(numeric), several versions of avg(), and various other functions. Add some regression tests, as well, testing the general sa

[COMMITTERS] pgsql: Implement backup API functions for non-exclusive backups

2016-04-05 Thread Magnus Hagander
Implement backup API functions for non-exclusive backups Previously non-exclusive backups had to be done using the replication protocol and pg_basebackup. With this commit it's now possible to make them using pg_start_backup/pg_stop_backup as well, as long as the backup program can maintain a pers

[COMMITTERS] pgsql: Fix typo

2016-04-05 Thread Magnus Hagander
Fix typo Etsuro Fujita Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9457b591b949d3c256dd91043df71fb11657227a Modified Files -- src/interfaces/libpq/fe-connect.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers maili