<douglasht@...> wrote in message news:9mlq38+klpe@......

> Hi there,
>
> I'm having problems creating foreign keys in firebird 1.0.0.338 beta2
> on an
> NT4 SP5 Workstation box. Below is a small script that hopefully
> reproduces
> the behavior.

[snip]

> Unsuccessful metadata update
> STORE RDB$REF_CONSTRAINTS failed
> action cancelled by trigger (1) to preserve data integrity
> Name of Referential Constraint not defined in constraints table

Did you try the same statement with an earlier release? I think it's old
news. This bug comes from a system trigger. I don't know why it has the
logic it has, but it causes these kinds of problems. I would like to change
it in the future. It's part of the whole effort that was done to auto-create
indices for FKs.
I used not only the latest FB I compiled a couple of minutes ago but the old
IB6 before the backdoor fix (v6.0.0.627). The problem is the same. Go to IB5
and you'll see the same. Go to IB4 and you'll see the same. Sorry.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing