Vadim, bright as always wrote:
> ....
>9. ObjExclusiveLock - acquired by DROP/ALTER.
>
>: SELECT doesn't aquire any type of lock except of
> AccessSharedLock but this is short-term lock and would we
> like disallow DROP TABLE that was read by some running
> transaction ?
I would say allow the drop table, of course only if no update or intent update (select for update)
lock is on it. This is how Informix behaves. Otherwise it will become very hard to drop tables altogether.
Andreas
