On Mon, Mar 28, 2005 at 09:41:03AM -0600, Thomas F.O'Connell wrote: > I've only been explaining general database theory and the rules of SQL > in response to your posts because I'm still having a difficult time > understanding what you're trying to accomplish.
I think he's trying to exploit ON UPDATE CASCADE so he can execute a single UPDATE on the referenced table instead of having to write multiple UPDATE statements, one for each referencing table. The problem is that he's trying to change the referenced value from 2 to 1 but 1 already exists, so he gets a duplicate key error. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
