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 CABamaqNPg-r2Gi9n-NsptwyDu17TE4iOhcHWHPSE1cCksMN6EQ@mail.gmail.com
Whole thread Raw
In response to Re: Check constraints on partition parents only?  (Robert Haas <robertmhaas@gmail.com>)
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.

Hrm.  That doesn't seem so good.  Maybe we've got the design wrong
here.  It doesn't seem like we want to lose the ability to define
arbitrary constraints at table-creation time.


Well the handling is different now for "ONLY" constraints only. The normal constraints can still be attached at table-creation time.
 
Regards,
Nikhils

pgsql-hackers by date:

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