Mmm,

When I restore with -inactive. then I can activate all indexes except
on foreign:

Cannot commit transaction:
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "PK_PERSONS" on table "PERSONS".

How do I've to interprete this?

Where can the problem be? at the persons table or the other one?

Tom.

--- In firebird-support@yahoogroups.com, "zifnabbe" <zifnabbe@u...>
wrote:

> Thanks all,
>
> When I follow the guidelines and try to restore the database, gbak
> ends with the following error:
>
> gbak: cannot commit index RDB$FOREIGN20
> gbak: ERROR: violation of FOREIGN KEY constraint "PK_PERSONS" on
> table "PERSONS"
>
> gbak: ERROR: action cancelled by trigger (3) to preserve data
> integrity
> gbak: ERROR: Cannot deactivate primary index
> gbak: Exiting before completion due to errors
>
> What can this be causing?
>
> Thanks,
> Tom.
> --- In firebird-support@yahoogroups.com, Helen Borrie

<helebor@t...>

> wrote:
> > At 12:56 PM 30/04/2004 +0000, you wrote:
> > > >
> > > > You should be able to fix these with gfix. There may be some
> lost
> > >data, however.
> > >
> > >how can I fix this with gfix? ie which command do I use for this?
> >
> > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr
> >
> > /heLen