There is already an index on that column, true, but it isn't declared as a
primary key, as far as I can tell. I'll check into this more, though. One
question: Is RDB$INDEX_5 then the name of the index in question? Note that
the ALTER statement doesn't name an index, only a column to name as a key,
so the name is generated for me.



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Vlad Khorsun
Sent: Saturday, November 01, 2008 9:55 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Error while trying to add a primary key

> But back to my real problem. Taking your advice, I copied firebird.msgs to
> my executable's directory, and now the error reads:
>
>
>
> DIAG [HY000] [ODBC Firebird Driver][Firebird]unsuccessful metadata update
>
> STORE RDB$INDICES failed
>
> attempt to store duplicate value (visible to active transactions) in

unique

> index "RDB$INDEX_5" (-607)

You already have index named as one you want to create.

Regards,
Vlad





[Non-text portions of this message have been removed]