Horton

Fix VALIDATE CONSTRAINT to consider NO INHERIT attribute.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 6a4dda44e02bfd5148c13b00d8f81045a2e17f2c
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-04-28T18:48:38Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/commands/tablecmds.c modified +3 −2
src/test/regress/expected/alter_table.out modified +20 −0
src/test/regress/sql/alter_table.sql modified +15 −0

Discussion