Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors
Date
Msg-id 23590.1443725377@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors  (swingi@gmail.com)
Responses Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
swingi@gmail.com writes:
> I just noticed that when you add a not valid constraint to a table that is
> inherited, this will result in pg_dump emitting an add constraint operation
> for every table in the inheritance hierarchy. Therefore restoring a dump
> will cause errors. Below is an example, first with a valid constraint (goes
> well), and then the not valid constraint.

Seems to be a simple oversight in the code for handling not-valid
constraints.  Thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: GRANT USAGE ON SEQUENCE missing from psql command completion
Next
From: Thomas Munro
Date:
Subject: Re: GRANT USAGE ON SEQUENCE missing from psql command completion