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