Re: [HACKERS] DROP TABLE inside transaction block

>> 
>> Oracle auto-commits current in-progress transaction before
>> execution of any DDL statement and executes such statements in
>> separate transaction. 
>
>That's cheating!
>

Dec (Oracle) Rdb cheats by locking a tables meta-data as soon as any user
accesses it, so that 'alter/drop table' will not run while that user is
attached. But is does support meta-data changes inside transactions
(assuming no-else who is currently connected has ever read that particular
meta-data). It is nice being able to rollback 'alter table' statements,
even under these strong restrictions.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: +61-03-5367 7422            |                 _________  \
Fax: +61-03-5367 7430            |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/