Re: Check constraints on partition parents only? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Check constraints on partition parents only?
Date
Msg-id 23800.1311946621@sss.pgh.pa.us
Whole thread Raw
In response to Re: Check constraints on partition parents only?  (Nikhil Sontakke <nikkhils@gmail.com>)
Responses Re: Check constraints on partition parents only?
List pgsql-hackers
Nikhil Sontakke <nikkhils@gmail.com> writes:
>> (Also, don't forget you need to hack pg_dump, too.)

> Yeah, I have already hacked it a bit. This constraint now needs to be
> spit out later as an ALTER command with ONLY attached to it
> appropriately. Earlier all CHECK constraints were generally emitted as
> part of the table definition itself.

IIRC, there's already support for splitting out a constraint that way,
in order to deal with circular dependencies.  You just need to treat
this as an additional reason for splitting.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Check constraints on partition parents only?
Next
From: Tom Lane
Date:
Subject: Re: Check constraints on partition parents only?