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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql