On Fri, 7 Feb 2003, Peter Childs wrote:
> Now we can actually use Constraints properly in 7.3 (unlike
> previous versions) Is it possible to change them without dropping and
> recreating.
Not really, unfortunately.
> I think somone else has already asked this within the last few
> days. But what I need to do is make my constraints deferrable. I'm not
> really sure why deferrable is not the default.
AFAICT, SQL92 requires INITIALLY IMMEDIATE NOT DEFERRABLE as the
default (10.6 SR3 & 4b).