Subject Re: [firebird-support] troubles after restore
Author Ann Harrison
Walter Neumann wrote:

>PC: P III/600 256 MB RAM, SuSE Linux 8.2, Firebird 1.0 SS
>1. Which memory is used for sorting and building the index. Is it the tmp
>directory, specified in isc config?

>2. The main table in the DB has a PK, which is referenced in many tables.
>After the restore I can't delete any row in this table. Error message:
>"internal gds software consistency check (partner index description not found
>(175))". There don't exist an index with the name 'partner'.
Right. What that means is that there is a foreign key dependent on that
primary key and that the index for that foreign key has disappeared.
The "partners" are the primary key index and the foreign key index. The
first thing I would try is to drop and recreate all foreign keys
dependant on that primary key.

> It exists a
>field with this name, which has a foreigen key to the main table. I deleted
>this foreigen key and rebuilded it. But it's always the same error. It
>depends not to the key, which I couldn't activate! Is there a system table
Quite possibly. The system tables rdb$relation_constraints,
rdb$ref_constraints, and rdb$dependencies describe foreign key
relationships. I would be very hesitant to try to change the
information there and would do so only if I were unable to drop the
constraints normally.