Re: [COMMITTERS] pgsql: Fix assorted missing infrastructure for ON CONFLICT.

[Tom Lane]

Alvaro Herrera  writes:
> Peter Geoghegan wrote:
>> What does this mean?
>> 
>> +   /* XXX broken */
>> if (attno < 0)
>> elog(ERROR, "system column in index");

> My guess is that it means we do support indexes in system columns (oid
> in particular) and that instead of an ugly error this should do
> something else.  Maybe silently ignore the index.

I left that for a second patch, which is now pushed.

regards, tom lane


-- 
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 infer_arbiter_indexes() to not barf on system columns.

[Tom Lane]

Fix infer_arbiter_indexes() to not barf on system columns.

While it could be argued that rejecting system column mentions in the
ON CONFLICT list is an unsupported feature, falling over altogether
just because the table has a unique index on OID is indubitably a bug.

As far as I can tell, fixing infer_arbiter_indexes() is sufficient to
make ON CONFLICT (oid) actually work, though making a regression test
for that case is problematic because of the impossibility of setting
the OID counter to a known value.

Minor cosmetic cleanups along with the bug fix.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/8a13d5e6d1bb9ff9460c72992657077e57e30c32

Modified Files
--
src/backend/optimizer/util/plancat.c | 43 ++--
1 file changed, 16 insertions(+), 27 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 infer_arbiter_indexes() to not barf on system columns.

[Tom Lane]

Fix infer_arbiter_indexes() to not barf on system columns.

While it could be argued that rejecting system column mentions in the
ON CONFLICT list is an unsupported feature, falling over altogether
just because the table has a unique index on OID is indubitably a bug.

As far as I can tell, fixing infer_arbiter_indexes() is sufficient to
make ON CONFLICT (oid) actually work, though making a regression test
for that case is problematic because of the impossibility of setting
the OID counter to a known value.

Minor cosmetic cleanups along with the bug fix.

Branch
--
REL9_5_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/428484ce102b3d4e6308c8504744558c2e2d99af

Modified Files
--
src/backend/optimizer/util/plancat.c | 43 ++--
1 file changed, 16 insertions(+), 27 deletions(-)


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

Re: [COMMITTERS] pgsql: Fix assorted missing infrastructure for ON CONFLICT.

[Peter Geoghegan]

On Wed, May 11, 2016 at 1:54 PM, Alvaro Herrera
 wrote:
> My guess is that it means we do support indexes in system columns (oid
> in particular) and that instead of an ugly error this should do
> something else.  Maybe silently ignore the index.

Why ignore the index? Either they're not supported, and we should
throw an error (granted, a less ugly one), or they are supported, and
inference should succeed.

-- 
Peter Geoghegan


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

Re: [COMMITTERS] pgsql: Fix assorted missing infrastructure for ON CONFLICT.

[Alvaro Herrera]

Peter Geoghegan wrote:
> On Wed, May 11, 2016 at 1:20 PM, Tom Lane  wrote:
> > Fix assorted missing infrastructure for ON CONFLICT.
> 
> What does this mean?
> 
> +   /* XXX broken */
> if (attno < 0)
> elog(ERROR, "system column in index");

My guess is that it means we do support indexes in system columns (oid
in particular) and that instead of an ugly error this should do
something else.  Maybe silently ignore the index.

-- 
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Re: [COMMITTERS] pgsql: Fix assorted missing infrastructure for ON CONFLICT.

[Peter Geoghegan]

On Wed, May 11, 2016 at 1:20 PM, Tom Lane  wrote:
> Fix assorted missing infrastructure for ON CONFLICT.

What does this mean?

+   /* XXX broken */
if (attno < 0)
elog(ERROR, "system column in index");

-- 
Peter Geoghegan


-- 
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 assorted missing infrastructure for ON CONFLICT.

[Tom Lane]

Fix assorted missing infrastructure for ON CONFLICT.

subquery_planner() failed to apply expression preprocessing to the
arbiterElems and arbiterWhere fields of an OnConflictExpr.  No doubt the
theory was that this wasn't necessary because we don't actually try to
execute those expressions; but that's wrong, because it results in failure
to match to index expressions or index predicates that are changed at all
by preprocessing.  Per bug #14132 from Reynold Smith.

Also add pullup_replace_vars processing for onConflictWhere.  Perhaps
it's impossible to have a subquery reference there, but I'm not exactly
convinced; and even if true today it's a failure waiting to happen.

Also add some comments to other places where one or another field of
OnConflictExpr is intentionally ignored, with explanation as to why it's
okay to do so.

Also, catalog/dependency.c failed to record any dependency on the named
constraint in ON CONFLICT ON CONSTRAINT, allowing such a constraint to
be dropped while rules exist that depend on it, and allowing pg_dump to
dump such a rule before the constraint it refers to.  The normal execution
path managed to error out reasonably for a dangling constraint reference,
but ruleutils.c dumped core; so in addition to fixing the omission, add
a protective check in ruleutils.c, since we can't retroactively add a
dependency in existing databases.

Back-patch to 9.5 where this code was introduced.

Report: <20160510190350.2608.48...@wrigleys.postgresql.org>

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/26e66184d6136643d16f6fb167db517fb18b8f89

Modified Files
--
src/backend/catalog/dependency.c  |  9 +
src/backend/optimizer/plan/planner.c  | 17 ++---
src/backend/optimizer/plan/subselect.c|  1 +
src/backend/optimizer/prep/prepjointree.c | 26 --
src/backend/optimizer/util/plancat.c  |  9 -
src/backend/utils/adt/ruleutils.c |  7 +--
src/test/regress/expected/insert_conflict.out | 15 +++
src/test/regress/sql/insert_conflict.sql  | 22 ++
8 files changed, 94 insertions(+), 12 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 assorted missing infrastructure for ON CONFLICT.

[Tom Lane]

Fix assorted missing infrastructure for ON CONFLICT.

subquery_planner() failed to apply expression preprocessing to the
arbiterElems and arbiterWhere fields of an OnConflictExpr.  No doubt the
theory was that this wasn't necessary because we don't actually try to
execute those expressions; but that's wrong, because it results in failure
to match to index expressions or index predicates that are changed at all
by preprocessing.  Per bug #14132 from Reynold Smith.

Also add pullup_replace_vars processing for onConflictWhere.  Perhaps
it's impossible to have a subquery reference there, but I'm not exactly
convinced; and even if true today it's a failure waiting to happen.

Also add some comments to other places where one or another field of
OnConflictExpr is intentionally ignored, with explanation as to why it's
okay to do so.

Also, catalog/dependency.c failed to record any dependency on the named
constraint in ON CONFLICT ON CONSTRAINT, allowing such a constraint to
be dropped while rules exist that depend on it, and allowing pg_dump to
dump such a rule before the constraint it refers to.  The normal execution
path managed to error out reasonably for a dangling constraint reference,
but ruleutils.c dumped core; so in addition to fixing the omission, add
a protective check in ruleutils.c, since we can't retroactively add a
dependency in existing databases.

Back-patch to 9.5 where this code was introduced.

Report: <20160510190350.2608.48...@wrigleys.postgresql.org>

Branch
--
REL9_5_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/58d802410ad85c44073d4ef494a9d5ac24ecba66

Modified Files
--
src/backend/catalog/dependency.c  |  9 +
src/backend/optimizer/plan/planner.c  | 17 ++---
src/backend/optimizer/plan/subselect.c|  1 +
src/backend/optimizer/prep/prepjointree.c | 26 --
src/backend/optimizer/util/plancat.c  |  9 -
src/backend/utils/adt/ruleutils.c |  7 +--
src/test/regress/expected/insert_conflict.out | 15 +++
src/test/regress/sql/insert_conflict.sql  | 22 ++
8 files changed, 94 insertions(+), 12 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: Update key words table for 9.6

[Peter Eisentraut]

Update key words table for 9.6

Branch
--
master

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

Modified Files
--
doc/src/sgml/keywords.sgml | 16 +++-
1 file changed, 15 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