Re: Alter Contraint

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.

> I'm not really sure why deferrable is not the default.

Because the SQL spec says so.

            regards, tom lane