Subject Re: The dreaded foreign key creation error
Author alex_vnru
--- In ib-support@y..., Martijn Tonies <martijn@b...> wrote:
> A common cause for this error is have an index defined on a primary
key
> column. In this case, the index was created by the system - namely
because
> of the FK from LEVERANCIER to RELATIE.
>
> Dropping this FK results in removing the index and the second FK
(from
> ORDERREGEL to LEVERANCIER) could be created without problems. Next
up:
> creating the FK from LEVERANCIER to RELATIE. All went well...
>
> It is a workaround for a strange problem -- comments, anyone?
>
> (IB 6.0, NT4)
^^^^^

Martijn, best workaround for this problem is Firebird :) Ann fixed
it somewhere between RC1 and RC2.

Best regards.