Message-ID: <4A6F5AD3.1000700@gmail.com>
Date: Tue, 28 Jul 2009 14:08:51 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090608)
MIME-Version: 1.0
To: Akos Gabriel <akos.gabriel@i-logic.hu>
CC: pgsql-sql@postgresql.org
References: <20090728201240.1daff5bb@gabriel-desktop>
In-Reply-To: <20090728201240.1daff5bb@gabriel-desktop>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: Detect referential integrity structure

Perhaps another option:

Alter the references to ON DELETE CASCADE as seen here 
<http://www.postgresql.org/docs/8.3/static/ddl-constraints.html>


Akos Gabriel wrote:
> Hi,
>
> I've a big/complex database (Adempiere - www.adempiere.org ) where I'd
> like to delete some rows from some tables (delete a client and its
> data from the ERP database).
> All tables are in one schema (adempiere).
> There are some foreign keys/constraints.
> I've following options:
>
> - disable all constraints, doing the delete, enable all constraints.
> - find out the "right sequence" and do the delete -s.
>
> Does anyone have such an algorythm, or a method of disabling all the
> constraints? We have 8.3.7 right now. The solution will be published
> into the Adempiere wiki / contributed to the project as well.
>
> Thanks in advance,
> Akos Gabriel
>
>