[COMMITTERS] pgsql: Make some adjustments in variable assignments

2016-03-03 Thread Peter Eisentraut
Make some adjustments in variable assignments These variables aren't really used for anything interesting, but it seems the existing grouping was somewhat nonsensical. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b497abc6022f7ac13e8a59d9b3a14f8ba6d39791 Modified

[COMMITTERS] pgsql: Add missing rules related to EUC_JIS_2004 and SHIFT_JIS_2004 enc

2016-03-03 Thread Peter Eisentraut
Add missing rules related to EUC_JIS_2004 and SHIFT_JIS_2004 encodings This was apparently forgotten in commit 75c6519ff68dbb97f73b13e9976fb8075bbde7b8. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/7a4a813c993ed767e2c2952f7a89a75ce6e56b6b Modified Files -

[COMMITTERS] pgsql: Add prerequisite for KOI8-U.TXT

2016-03-03 Thread Peter Eisentraut
Add prerequisite for KOI8-U.TXT This was missed when the encoding was added. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1fa2a6b1d4023e7c5890d095364dea0e0bf24a59 Modified Files -- src/backend/utils/mb/Unicode/Makefile | 2 +- 1 file changed, 1 inserti

[COMMITTERS] pgsql: Force synchronous_commit=on in test_decoding's concurrent_ddl_dm

2016-03-03 Thread Andres Freund
Force synchronous_commit=on in test_decoding's concurrent_ddl_dml.spec. Otherwise running installcheck-force on a server with synchronous_commit=off will result in the tests failing. All the other tests already do so... Backpatch: 9.4, where logical decoding was added Branch -- REL9_5_STABLE

[COMMITTERS] pgsql: Force synchronous_commit=on in test_decoding's concurrent_ddl_dm

2016-03-03 Thread Andres Freund
Force synchronous_commit=on in test_decoding's concurrent_ddl_dml.spec. Otherwise running installcheck-force on a server with synchronous_commit=off will result in the tests failing. All the other tests already do so... Backpatch: 9.4, where logical decoding was added Branch -- REL9_4_STABLE

[COMMITTERS] pgsql: Force synchronous_commit=on in test_decoding's concurrent_ddl_dm

2016-03-03 Thread Andres Freund
Force synchronous_commit=on in test_decoding's concurrent_ddl_dml.spec. Otherwise running installcheck-force on a server with synchronous_commit=off will result in the tests failing. All the other tests already do so... Backpatch: 9.4, where logical decoding was added Branch -- master Detai

[COMMITTERS] pgsql: pgbench: accept unambiguous builtin prefixes for -b

2016-03-03 Thread Alvaro Herrera
pgbench: accept unambiguous builtin prefixes for -b This makes it easier to use "-b se" instead of typing the full "-b select-only". Author: Fabien Coelho Reviewed-by: Michaƫl Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d561f1caecbbeca2f7adab39a29432923d

[COMMITTERS] pgsql: Rework PostgresNode's psql method

2016-03-03 Thread Alvaro Herrera
Rework PostgresNode's psql method This makes the psql() method much more capable: it captures both stdout and stderr; it now returns the psql exit code rather than stdout; a timeout can now be specified, as can ON_ERROR_STOP behavior; it gained a new "on_error_die" (defaulting to off) parameter to

[COMMITTERS] pgsql: perltidy PostgresNode and SimpleTee

2016-03-03 Thread Alvaro Herrera
perltidy PostgresNode and SimpleTee Also, mention in README that Perl files should be perltidy'ed. This isn't really the best place (since we have Perl files elsewhere in the tree) and this is already in pgindent's README, but this subdir is likely to get hacked a whole lot more than the other Pe

[COMMITTERS] pgsql: Fix mistakes in recovery tests

2016-03-03 Thread Alvaro Herrera
Fix mistakes in recovery tests One test was relying on method remove_tree that isn't implemented in the oldest Perl we support; fix it by using the older rmtree instead. Another test had a typo in a SQL command, which isn't noticed because the PostgresNode->psql() method doesn't check that querie

Re: [COMMITTERS] pgsql: Fix json_to_record() bug with nested objects.

2016-03-03 Thread Andrew Dunstan
On 03/02/2016 11:31 PM, Tom Lane wrote: I added a regression test case based on his example, plus parallel tests for json_to_recordset, jsonb_to_record, jsonb_to_recordset. The latter three do not exhibit the same bug (which suggests that we may be missing some opportunities to share code...)

[COMMITTERS] pgsql: Revert buggy optimization of index scans

2016-03-03 Thread Simon Riggs
Revert buggy optimization of index scans 606c0123d627 attempted to reduce cost of index scans using > and < strategies, though got that completely wrong in a few complex cases. Revert whole patch until we find a safe optimization. Branch -- master Details --- http://git.postgresql.org/p

[COMMITTERS] pgsql: Revert buggy optimization of index scans

2016-03-03 Thread Simon Riggs
Revert buggy optimization of index scans 606c0123d627 attempted to reduce cost of index scans using > and < strategies, though got that completely wrong in a few complex cases. Revert whole patch until we find a safe optimization. Branch -- REL9_5_STABLE Details --- http://git.postgresq

[COMMITTERS] pgsql: Add prefix to pl/pgsql global variables and functions

2016-03-03 Thread Magnus Hagander
Add prefix to pl/pgsql global variables and functions Rename pl/pgsql global variables to always have a plpgsql_ prefix, so they don't conflict with other shared libraries loaded. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6c90996a4cbfe02639f2ba31d22f9159832de86