Re: Changing constraints to deferrable

"Florian G. Pflug" <fgp@phlo.org> 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