Re: Alter Contraint

On Fri, 7 Feb 2003, Tom Lane wrote:

> Peter Childs <blue.dragon@blueyonder.co.uk> writes:
> >     Now we can actually use Constraints properly in 7.3 (unlike
> > previous versions) Is it possible to change them without dropping and
> > recreating.
> >     I think somone else has already asked this within the last few
> > days. But what I need to do is make my constraints deferrable.
>
> Have you looked at SET CONSTRAINTS ?  I'm not sure how complete our
> implementation is, but it seems more nearly a match for your problem
> than a persistent ALTER command.

AFAIK, SET CONSTRAINTS only lets you change the check time of
deferrable constraints, it doesn't let you make a not deferrable
constraint deferrable.