]> granicus.if.org Git - postgresql/commit
Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.
authorRobert Haas <rhaas@postgresql.org>
Fri, 28 Apr 2017 18:48:38 +0000 (14:48 -0400)
committerRobert Haas <rhaas@postgresql.org>
Fri, 28 Apr 2017 18:55:42 +0000 (14:55 -0400)
commitf60f0c8fe3d871c8903b487734fd593313b16306
tree2b8a7adfd43d20b6a4a3ddc3dbe377c10d4e9c6a
parent952e33b052758a7febfb2625bf6b0c0f8c660a2b
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.24362.19@wrigleys.postgresql.org
src/backend/commands/tablecmds.c
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql