Subject Re: [ib-support] Foreign Key problem - solved
Author Geoff Worboys

> I just found the problem in older mails. I had indexes defined
> on some of the referenced PK fields. According to a mail of
> Ann Harrison there is a bug in Interbase that prevents one
> from creating FKs if there are indexes on the referenced PK
> fields.

Can you point me to where you found this information. I am wondering
if this may be related to a separate backup/restore problem that I am
seeing on one of my databases.

Or to put it another way. I am wondering whether, if the FKs are
created first, and then the offending indexes are created - do I get
into a position where the existing database will operate but the
backup/restored version will be corrupt because of this problem.

Geoff Worboys
Telesis Computing