On 11-10-2011 18:07, kokok_kokok wrote:

> I have found the problem. I dropped an updatable view, then I recreated the view and the triggers, all in the same transaction.
> It has been working well in FB 2.0 and 2.5.0 for years.
> Now I see that it does not work in FB 2.5.1, maybe it is a bug, I am not sure. In any case I have solved it adding a commit between the drop and the recreate. It is not the optimal solution because the database can stay in an inconsistent status but for now it works fine.

Might be an unintended side-effect of a change for Firebird 2.5.1. Prime
candidates could be the changes for
http://tracker.firebirdsql.org/browse/CORE-3340

In any case, I think it is best to report this on the tracker at
http://tracker.firebirdsql.org/ preferably including a (simple)
reproduction script.

Mark
--
Mark Rotteveel