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 [email protected], 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/ >
