Subject | Re: [firebird-support] "attempt to store duplicate value" fails in 2.5.1, works in 2.5.0 |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-10-11T11:26:45Z |
> I had a SQL script that has been working well for one year in the 2.5.0 version in hundreds of installations.You are trying to create a table or view which already exists.
>
> 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.
--
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/