Re: On delete cascade

Gerard H. Pille wrote:
>
> In article <4ivu1h$toq_at_news-f.iadfw.net>, Mike Openshaw
> (openshaw_at_airmail.net) says...
> !>
> !>tkyte_at_us.oracle.com (Thomas J Kyte) wrote:
> !>
> !>>ghp_at_infosoft.be (Gerard H. Pille) wrote:
> !>
> !>>>In article <4is48h$2rn_at_kuikka.inet.fi>, Sakari Lampola
> !>>>(Sakari.Lampola_at_cybersoft.inet.fi) says...
> !>>>!>
> !>>>!>
> !>>>!>Has anybody ever used "on delete cascade" option with foreign keys
> !>>>!>to guard referential integrity in a real production database ?
> !>>>!>Any problems ?
> !>>>!>
> !>>>!>Just curious,
> !>>>!>
> !>>>!>Sakari Lampola
> !>>>!>Cybersoft
> !>>>!>Finland
> !>>>!>
> !>>>!>
> !>>>I would never use it, it makes you loose half of the referential
> !>>>integrity.
> !>>>--
> !>>>Kind reGards
> !>>> \ / |
> !>>> X |
> !>>> / \ s
> !>>> Gerard
> !>
> !>>Elaborate please. What do you mean by 'you loose half of the
> !referential
> !>>integrity'. I use on delete cascade in many places in production.
> !>
> !>
> !>>Thomas Kyte
> !>>tkyte_at_us.oracle.com
> !>>Oracle Government
> !>
> !>
> !>>--------------------------------------------------------
> !>>opinions and statements are mine and do not necessarily
> !>>reflect the opinions of Oracle Corporation.
> !>
> !>Don't worry, Thomas; some people never will understand basic
> !>relational theory. Ya buy 'em book, ya buy 'em books, and the just
> !>chew the covers off.
> !>
> !>Michael B. Openshaw
> !>Integrated Medical Networks
> !>(Opinions expressed are my own)
> !>
>
> I feel happy for you being able to express your own opinion.
>
> --
> Kind reGards
> \ / |
> X |
> / \ s
> Gerard

Yes, I have used the ON DELETE CASCADE constraint in a production database containing 3 million records in a multi-parent child table relationship. The ON DELETE CASCADE constraint is on all the child tables off of the single parent table (obviously), and deletions on the parent table work fine.

Question: Have you seen problems that would cause you to post this message?

-- 
Eric Dirst
BSG Alliance/IT Inc.
e-mail business:  eric_dirst_at_notes.bsginc.com
e-mail personal:  eric.dirst_at_worldnet.att.net
Phone:  847-384-6640
Fax:  847-698-3762