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

From Nikhil Sontakke
Subject Re: Check constraints on partition parents only?
Date
Msg-id CABamaqPRV6rNvpo09EP3Rt_hJFc1aAnyh9TS5G9o-M_W7X+W2g@mail.gmail.com
Whole thread Raw
In response to Re: Check constraints on partition parents only?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
 
> 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.


Yeah, I have indeed followed the existing separate printing logic for "ONLY" constraints. Had to make the table dependent on this constraint to print the constraint *after* the table definition. 

Regards,
Nikhils

pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: Check constraints on partition parents only?
Next
From: "Kevin Grittner"
Date:
Subject: Re: cheaper snapshots