From: Akos Gabriel <akos.gabriel@i-logic.hu>
To: pgsql-sql@postgresql.org
Subject: Detect referential integrity structure
Date: Tue, 28 Jul 2009 20:12:40 +0200
Message-ID: <20090728201240.1daff5bb@gabriel-desktop> (raw)
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.gabriel@i-logic.hu|Web: http://www.i-logic.hu=-
-=Tel/fax:+3612391618 |Mobil:+36209278894 =-
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akos.gabriel@i-logic.hu
Subject: Re: Detect referential integrity structure
In-Reply-To: <20090728201240.1daff5bb@gabriel-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox