AW: AW: AW: BLERe: AW: AW: relation ### modified while in use

Started by Zeugswetter Andreas SBabout 25 years ago1 messages
#1Zeugswetter Andreas SB
ZeugswetterA@wien.spardat.at

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