"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Greg Stark wrote:
> > I want all my foreign key constraints to be deferrable. They were all
> > created
> > with the default (not deferrable).
> > Is it enough to just do update pg_constraint set condeferrable = 't' where
> > contype = 'f';
>
> Try an additional "update pg_trigger set isdeferrable=true where
> pgisconstraint
> = true", and it should work..
Thanks. That works.
Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :)
--
greg
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
