--- In ib-support@yahoogroups.com, "tom" <i17u004@d...> wrote:

> I am using firebird running on red hat linux.
> When i restore the gbk, an error occur:
> attempt to store duplicate value(visible to active transaction) in

unique index "RDB$INDEX_18" But I can find this index using show

> index. How can I do? Would u please advice.

RDB$INDEX_18 UNIQUE INDEX ON
RDB$PROCEDURE_PARAMETERS(RDB$PROCEDURE_NAME, RDB$PARAMETER_NAME)

Can't explain how could you got duplicates in this table. Perhaps any
known reason for database corruption. Have'nt encounter such kind of
corruption myself and afraid you have not a simple task to restore
this database. Find this duplicates and try to drop this procedure. If
it is called by another procedures, you should alter them commenting
calls before dropping. If there will be further problems, ask more,
I or others here will try to help you.

Good luck, Alexander.