Subject | Re: [ib-support] Re: The dreaded foreign key creation error |
---|---|
Author | Martijn Tonies |
Post date | 2002-01-03T17:41:55Z |
Hi Alex,
""alex_vnru"" <ded@...> wrote in message
news:a124v9+tm1e@......
--
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."
""alex_vnru"" <ded@...> wrote in message
news:a124v9+tm1e@......
> --- In ib-support@y..., Martijn Tonies <martijn@b...> wrote:Sorry, but I'm not in control on this one... Or at least, not that much :)
> > 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.
>
--
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."