Subject Re: [ib-support] Re: The dreaded foreign key creation error
Author Martijn Tonies
Hi Alex,

""alex_vnru"" <ded@...> wrote in message
news:a124v9+tm1e@......
> --- 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.
>

Sorry, but I'm not in control on this one... Or at least, not that much :)


--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."