From: | Akos Gabriel <akos(dot)gabriel(at)i-logic(dot)hu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Detect referential integrity structure |
Date: | 2009-07-28 18:12:40 |
Message-ID: | 20090728201240.1daff5bb@gabriel-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)gabriel(at)i-logic(dot)hu|Web: http://www.i-logic.hu=-
-=Tel/fax:+3612391618 |Mobil:+36209278894 =-
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2009-07-28 20:08:51 | Re: Detect referential integrity structure |
Previous Message | Daryl Richter | 2009-07-28 12:25:51 | Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL |