Re: Incomprehensible behaviour of a foreign key.

On Sun, 20 Jul 2003, Stephan Szabo wrote:

>
> On Sun, 20 Jul 2003, Nigel J. Andrews wrote:
>
> > I'm completely baffled by this thing, the work it is for is extremely urgent
> > and this is currently a show stopper. My minimal test script showing the
> > problem is attached and the output is shown below.
>
> We're going to need a real test script that includes the table schema and
> preferably a set of made up data since the test script doesn't tell us
> enough to trace the actual problem since it's not runable without the
> schema.
>

Yes, I realise that a standalone test script would be preferable unfortunately
I can not invest the time in generating such a beast, especially as it would
probably work, when I need to produce a solution for this. To have the project
pulled because I've thrown an hour at trying to reproduce this in a completely
clean db instead of getting the project closer to working in that time is
really not an option I can consider at the moment. I've just posted a brief
description of the tables involved, isn't that sufficient to be able to say
whether there is something strange happening and perhaps suggest some things to
try?

Nigel Andrews
...in a progressively bigger and bigger panic.