> Could it be another reason? I have checked the entire script and all views are created using RECREATE VIEW. No tables are created.
>
> Also, as I have said, I can execute this script under FB 2.5.0 without problems. The error appears only in FB 2.5.1

As you are working possibly with two different instances ...

Are you sure that you are pointing to the same database in both tests?
If you are using aliases, perhaps when connecting via 2.5.0 you use a
different physical path than when using 2.5.1?


--
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/

> Thank you
>
>
>
>
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@...> wrote:
>>
>>> 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/
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>