Re: Tracing a constraint problem

2005-08-24 Thread Marcus Bointon
On 24 Aug 2005, at 05:19, Michael Stassen wrote: SHOW INNODB STATUS It's a bit convoluted - you have to spot the message amongst tons of other info - but it does work. I wouldn't like to try to do programmatic support for it though. Perhaps I should post a feature/ bug report for having

Re: Tracing a constraint problem

2005-08-23 Thread Michael Stassen
Marcus Bointon wrote: I have a single-table update query that's giving me a "Cannot add or update a child row: a foreign key constraint fails" error. Fair enough, I do have several constraints defined - but how can I find out which constraint is failing? Marcus SHOW INNODB STATUS See

Tracing a constraint problem

2005-08-23 Thread Marcus Bointon
I have a single-table update query that's giving me a "Cannot add or update a child row: a foreign key constraint fails" error. Fair enough, I do have several constraints defined - but how can I find out which constraint is failing? Marcus -- Marcus Bointon Synchromedia Limited: Putting you