Changing constraints to deferrable - Mailing list pgsql-general

From Greg Stark
Subject Changing constraints to deferrable
Date
Msg-id 873bunbkzj.fsf@stark.xeocode.com
Whole thread Raw
Responses Re: Changing constraints to deferrable  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Changing constraints to deferrable  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
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';

?

It doesn't seem to be enough. I still get constraint violations as soon as I
try to delete a referenced column even after "set constraints all deferred".


--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using rule with function for view delete gives error on OLD.* type
Next
From: Tom Lane
Date:
Subject: Re: Constraint problem