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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Wed, 4 Jun 2003 17:49:54 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: SET CONSTRAINTS not schema-aware