Carsten Schäfer wrote:

> After deleting the index i have identified the duplicate primary key and
> deleted it.
> But how can this happen ?

You were probably using some administraion tool that modifies the system
tables directly (like IBExpert for example).

--
Milan Babuskov
http://www.flamerobin.org