Gustav Brock
gustav at cactus.dk
Wed Feb 5 05:56:01 CST 2003
Hi Arthur > Speaking only for myself, I use cascade frequently delete, wherever it's > appropriate. When I began this thread, I didn't mention cascade delete at > all. I very specifically said "rows disappearing from reports" -- not from > tables. This was an RI issue, not a cascade issue. However, since I have > been known to rant, carry on :-) Hmmm ... nice try. And it brought some relief. But [picky mode on] you did start the thread - I couldn't read this in more than one way: > I didn't mean that the rows were disappearing, but rather that they > disappeared from reports, since their FK referents were gone. I would never > be so foolish as to turn cascade-delete on anywhere in any serious database > :-) I restored an old copy with the deleted employees, then imported the > rows and restored sanity to the db. /gustav