Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Detect referential integrity structure
- From: Rob Sargent <robjsargent(at)gmail(dot)com>
- To: Akos Gabriel <akos(dot)gabriel(at)i-logic(dot)hu>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Detect referential integrity structure
- Date: Tue, 28 Jul 2009 14:08:51 -0600
- Message-id: <4A6F5AD3.1000700@gmail.com> <text/plain>
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
- References:
- Detect referential integrity structure
- From: Akos Gabriel
- Detect referential integrity structure
- Prev by Date: Detect referential integrity structure
- Next by Date: Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL
- Previous by thread: Detect referential integrity structure
- Next by thread: Tweak sql result set... ?
- Indexes: