Vadim Mikheev wrote:
> 
> Andreas Zeugswetter wrote:
> >
> > 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.
> 
> Ok, currently, table can't be dropped if SELECTed by another
> running transaction.
> 
> Would we like to change this ?!

No, I think this is ok. I thought the current behavior was that a selecter won't
do a lock, and therefore drop table would work and wanted to give an argument to leave it as is.
I regard a drop table to be seldom used, e.g. at product installations or upgrades.

Andreas


Mon, 3 Aug 1998 13:57:46 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
AW: [HACKERS] Dropping tables...