Re: On delete cascade

From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1996/03/23
Message-ID: <4j14sf$kfu_at_news.Belgium.EU.net>#1/1


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
Received on Sat Mar 23 1996 - 00:00:00 CET

Original text of this message