Subject Re: [firebird-support] "attempt to store duplicate value" fails in 2.5.1, works in 2.5.0
Author Thomas Steinmaurer
> I had a SQL script that has been working well for one year in the 2.5.0 version in hundreds of installations.
>
> Now, when I use the FB 2.5.1, I get:
> INTERPRETE BUFFER = attempt to store duplicate value (visible to active
> transactions) in unique index "RDB$INDEX_0"
>
>
> However, if I execute it under FB 2.5.0 with the same database, everything works fine again.
>
> Somebody can give me a clue about what this message means please?
>
> Sorry for not posting the script, but it is very long. It basically alters some triggers and create some views.

You are trying to create a table or view which already exists.

--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/