From: Ed Carp
Date: March 13 1999 10:38am
Subject: Re: Some questions/concerns about MySQL
List-Archive: http://lists.mysql.com/mysql/152
Message-Id: <004a01be6d3e$1ce93cc0$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>The only thing triggers can do for you is an 'on delete cascade' that's
all.


You know, thinking about it, in a lot of applications, you *don't want* to
cascade deletes - updates, maybe, but not deletes.  Deletes should always be
a conscious decision, not a side effect of an automatic process.

I know that will get me in trouble with some purists, but I think it's far
safer to have to do something like "update table set linked_id=new_value
where linked_id=old_value" than it would be to accidentally delete customer
records or such.
--
Ed Carp, N7EKG - erc@stripped - 9403672744@stripped for URGENT
messages only!
Web: http://www.pobox.com/~erc