Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.
authorRobert Haas
Fri, 28 Apr 2017 18:48:38 +0000 (14:48 -0400)
committerRobert Haas
Fri, 28 Apr 2017 18:52:20 +0000 (14:52 -0400)
commit93a07a68eed76d36519ff17eb9bedc376f38e8c5
tree6f1adb6b86f276714fb08daa3feefd3f6f551fff
parentb6ecf26ccc2b3e3895979c8fa08d21e8175b81cc
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

Currently, trying to validate a NO INHERIT constraint on the parent will
search for the constraint in child tables (where it is not supposed to
exist), wrongly causing a "constraint does not exist" error.

Amit Langote, per a report from Hans Buschmann.

Discussion: http://postgr.es/m/20170421184012[email protected]
src/backend/commands/tablecmds.c
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql