Subject Re: [ib-support] Foreign Key problem - solved
Author Ann W. Harrison
At 04:13 PM 2/23/2001 +1100, Geoff Worboys wrote:

>Thanks for posting that Markus. I guess that leaves the question as
>to whether the bug is purely in the trigger - producing an error
>indication where none exists - or whether the bug may be deeper.

I found the error in the trigger - it's really there and not
in the code.

>This issue may have nothing to do with my problem - it caught my eye
>because I suspect my backup/restore problem is somehow related to
>compound keys and/or indexes that use key fields.
>I have been trying to tie down this problem into something small
>enough to send in for investigation - without any luck so far. I may
>play around with this a bit further and see if it leads anywhere.

I suspect that your problem may also be related to system triggers -
if you get a reliable test case, send it my way and I'll see if I
can figure it out.


We have answers.