From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Akos Gabriel <akos(dot)gabriel(at)i-logic(dot)hu> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Detect referential integrity structure |
Date: | 2009-07-28 20:08:51 |
Message-ID: | 4A6F5AD3.1000700@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Axe | 2009-07-28 20:49:29 | Tweak sql result set... ? |
Previous Message | Akos Gabriel | 2009-07-28 18:12:40 | Detect referential integrity structure |