Re: Alter Contraint - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Alter Contraint
Date
Msg-id 20030207065419.C55352-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Alter Contraint  (Peter Childs <blue.dragon@blueyonder.co.uk>)
List pgsql-general
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).


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database access problem : SOS
Next
From: Tom Lane
Date:
Subject: Re: converting Oracle to postgres