Date: Tue, 28 Jul 2009 20:12:40 +0200
From: Akos Gabriel <akos.gabriel@i-logic.hu>
To: pgsql-sql@postgresql.org
Subject: Detect referential integrity structure
Message-ID: <20090728201240.1daff5bb@gabriel-desktop>
Organization: I-Logic Ltd
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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

--=20
=C3=9Cdv=C3=B6zlettel,
G=C3=A1briel =C3=81kos
-=3DE-Mail :akos.gabriel@i-logic.hu|Web:  http://www.i-logic.hu=3D-
-=3DTel/fax:+3612391618            |Mobil:+36209278894         =3D-