Skip site navigation (1) Skip section navigation (2)

Re: Deferred Constraints Issues

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Deferred Constraints Issues
Date: 2008-03-25 20:27:00
Message-ID: 20080325132356.U1947@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 25 Mar 2008, kevin kempter wrote:

> I've placed this sql in a script:
>
> psql my_db <<!
> begin;
> SET CONSTRAINTS ALL DEFERRED ;
> delete from account where 1 = 1;
> delete from cust where 1 = 1;
> delete from cust_type where 1 = 1;
> delete from cust_orders where 1 = 1;
> commit;
> !
>
> The tables have relationships, however I expect the 'SET CONSTRAINTS
> ALL DEFERRED' to defer constraint checks.

IIRC it's defined to only defer constraints created with DEFERRABLE and/or
INITIALLY DEFERRED. The default is NOT DEFERRABLE.

In response to

pgsql-admin by date

Next:From: Michael MonnerieDate: 2008-03-26 00:25:51
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Previous:From: kevin kempterDate: 2008-03-25 20:10:07
Subject: Deferred Constraints Issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group