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