Is there any way to know which constraint should I drop and
recreate? I tried deleting the contraints of all the dependencies of
the table I was trying to delete the record and the table itself.
But the error still remains. I need this database working as soon as
possible. There are many tables that have this same error when
deleting a record.

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> At 12:11 PM 12/16/2004, giovanibettiol wrote:
>
>
> >Hello!
> >
> >I'm having the following error when trying to delete a few records
> >from a table in my Firebird database:
> >
> >Unsuccessful execution caused by a system error that precludes
> >successful execution of subsequent statements.
> >internal gds software consistency check (partner index description
> >not found (175)).
>
> It means that you've got a foreign key constraint and one of the
> tables (probably the referencing (aka child) table doesn't have an
> index defined on its key fields. I think you can drop and
> recreate the constraint to fix the problem.
>
> Regards,
>
>
> Ann