> > Also the result would be, that the first readonly statements are allowed to > > see schema changes, but selects after the first DML would not :-( > > Does it mean that even read-only statements aren't allowed > to release locks after other DMLs ? That is, what Tom is suggesting, but not after first DML but earlier after transaction start. I would like to avoid this. I want read only statements to release locks upon completion regardless of transaction state (except in serializable isolation). Andreas

Reply via email to