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 -- Üdvözlettel, Gábriel Ákos -=E-Mail :akos.gabr...@i-logic.hu|Web: http://www.i-logic.hu=- -=Tel/fax:+3612391618 |Mobil:+36209278894 =- -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
