Peter Eisentraut wrote: > Bruce Momjian writes: > > > Peter, I assume SET CONSTRAINTS can't control a domain's constraints --- > > it isn't actually a data object in the transaction. Am I right? > > No. SET CONSTRAINTS on a domain constraint should affect all constraints > on columns that use the domain.
Oh, wow. That is interesting. Does it effect only the current transaction? Current manual page text is: SET CONSTRAINTS sets the behavior of constraint evaluation in the current transaction. In IMMEDIATE mode, constraints ... -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org