pgsql: Revise API for partition_rbound_cmp/partition_rbound_datum_cmp.

2018-02-23 Thread Robert Haas
Revise API for partition_rbound_cmp/partition_rbound_datum_cmp. Instead of passing the PartitionKey, pass just the required bits of it. This allows these functions to be used without needing the PartitionKey to be available, which is important for several pending patches. Ashutosh Bapat, reviewe

pgsql: Revise API for partition bound search functions.

2018-02-23 Thread Robert Haas
Revise API for partition bound search functions. Similar to what commit b0229235564fbe3a9b1cc115ea738a07e274bf30 for a different set of functions, pass the required bits of the PartitionKey instead of the whole thing. This allows these functions to be used without needing the PartitionKey to be a

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Fix planner failures with overlapping mergejoin clauses in an ou

2018-02-23 Thread Tom Lane
Fix planner failures with overlapping mergejoin clauses in an outer join. Given overlapping or partially redundant join clauses, for example t1 JOIN t2 ON t1.a = t2.x AND t1.b = t2.x the planner's EquivalenceClass machinery will ordinarily refactor the clauses as "t1.a = t1.b AND t1.a = t2

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/da2715

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fe35cea7cf896

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/269dce

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- REL9_3_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a7eab4

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/14bd9b

pgsql: Synchronize doc/ copies of src/test/examples/.

2018-02-23 Thread Noah Misch
Synchronize doc/ copies of src/test/examples/. This is mostly cosmetic, but it might fix build failures, on some platform, when copying from the documentation. Back-patch to 9.3 (all supported versions). Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b67383

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

2018-02-23 Thread Tom Lane
Allow auto_explain.log_min_duration to go up to INT_MAX. The previous limit of INT_MAX / 1000 seems to have been cargo-culted in from somewhere else. Or possibly the value was converted to microseconds at some point; but in all supported releases, it's just compared to other values, so there's no

pgsql: Fix brown-paper-bag bug in commit 0a459cec96d3856f476c2db298c6b5

2018-02-23 Thread Tom Lane
Fix brown-paper-bag bug in commit 0a459cec96d3856f476c2db298c6b52f592894e8. RANGE_OFFSET comparisons need to examine the first ORDER BY column, which isn't necessarily the first column in the incoming tuples. No idea how this slipped through initial testing. Per bug #15082 from Zhou Digoal. Disc

pgsql: First-draft release notes for 10.3.

2018-02-23 Thread Tom Lane
First-draft release notes for 10.3. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/eec1a8cb6cbc6ea44cf58cfaeaa01ad8ee2bc8e8 Modified Files -- doc/src/sgml/release-10.sgml | 206 +++ 1 file changed, 206 insertions(+

Re: pgsql: Fix deadlock hazard in CREATE INDEX CONCURRENTLY

2018-02-23 Thread Tom Lane
So we're still not out of the woods with that CREATE INDEX CONCURRENTLY deadlock test. Buildfarm member okapi has failed most (not all) of its runs since that patch went in, but only in the 9.4 branch. The failures look like *** /home/data/buildfarm/root.x86_64/REL9_4_STABLE/pgsql.build/src/tes

pgsql: Fix filtering of unsupported relations in logical replication

2018-02-23 Thread Peter Eisentraut
Fix filtering of unsupported relations in logical replication In the pgoutput plugin, skip changes for relations that are not publishable, per is_publishable_class(). This concerns in particular materialized views and information_schema tables. While those relations cannot be part of a publicati

pgsql: Fix filtering of unsupported relations in logical replication

2018-02-23 Thread Peter Eisentraut
Fix filtering of unsupported relations in logical replication In the pgoutput plugin, skip changes for relations that are not publishable, per is_publishable_class(). This concerns in particular materialized views and information_schema tables. While those relations cannot be part of a publicati