Subject | Re: The dreaded foreign key creation error |
---|---|
Author | alex_vnru |
Post date | 2002-01-03T17:38:49Z |
--- In ib-support@y..., Martijn Tonies <martijn@b...> wrote:
Martijn, best workaround for this problem is Firebird :) Ann fixed
it somewhere between RC1 and RC2.
Best regards.
> A common cause for this error is have an index defined on a primarykey
> column. In this case, the index was created by the system - namelybecause
> of the FK from LEVERANCIER to RELATIE.(from
>
> Dropping this FK results in removing the index and the second FK
> ORDERREGEL to LEVERANCIER) could be created without problems. Nextup:
> 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.