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
