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


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