how do I drop a rdb$primary67 index ?

I get

Unsuccessful metadata update
ERASE RDB$INDICES failed
action cancelled by trigger (1) to preserve data integrity
Cannot delete index used by an Integrity Constraint
Statement: drop index rdb$primary67

I have dropped all secondary indexes, triggers
and shutdown the database

what else must I do ?

--- In ib-support@y..., Claus Heeg <heeg.c@t...> wrote:
> Hi Rod,
>
> if I were in your shoes, I d take orig. database find the primary
> indexNr 67 and drop this index and restore it again.
>
> after having a restore database i wd try to first find duplicates
and if
> none then create the index again.
> I keep fingers crossed for you for ten years we had not such an
gbak error.
> yours
> Claus
>
>
>
> rodbracher wrote:
>
> >OK I'm not crazy !
> >
> >gbak: creating indexes
> >gbak: ERROR: attempt to store duplicate value (visible to active
> >transactions) in unique index "RDB$PRIMARY67"
> >gbak: Index "RDB$PRIMARY67" failed to activate because:
> >gbak: The unique index has duplicate values or NULLs.
> >gbak: Delete or Update duplicate values or NULLs, and activate
> >index with
> >gbak: ALTER INDEX "RDB$PRIMARY67" ACTIVE;
> >
> >As a result all my relations are empty - I'm doing a gbak restore
> >with -inactive as I type. But at least I know now this really can
> >happen !
> >
> >--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> >
> >>you start all this with the finding of checksum errors
> >>is there some process where the gdb files are being copied
> >>
> >(backedup) or
> >
> >>restored after copying? these site to which you refer - are they
> >>
> >all windows
> >
> >>or unix?
> >> -----Original Message-----
> >> From: rodbracher [mailto:rod@m...]
> >> Sent: Friday, 27 September 2002 17:15
> >> To: ib-support@y...
> >> Subject: [ib-support] Re: Restore crisis
> >>
> >>
> >> No - but it still pops up with checksome errors at random times.
> >>
> >> --- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> >> > Rod,
> >> >
> >> > I hope you didn't do a restore that replaced the current
> >>
> >database?
> >
> >> >
> >> >
> >>
> >>
> >>
> >> Yahoo! Groups Sponsor
> >> ADVERTISEMENT
> >>
> >>
> >>
> >>
> >> To unsubscribe from this group, send an email to:
> >> ib-support-unsubscribe@e...
> >>
> >>
> >>
> >> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> >>
> >Service.
> >
> >>
> >>
> >>[Non-text portions of this message have been removed]
> >>
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@e...
> >
> >
> >
> >Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >.
> >
>
>
>
> [Non-text portions of this message have been removed]