On Wed, Jul 13, 2016 at 5:22 AM, Amit Langote <langote_amit...@lab.ntt.co.jp> wrote: > Consider a scenario where one adds a *valid* constraint on a inheritance > parent which is then merged with a child table's *not valid* constraint > during inheritance recursion. If merged, the constraint is not checked > for the child data even though it may have some. Is that an oversight?
Seems like it. I'd recommend we just error out in that case and tell the user that they should validate the child's constraint first. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers