
> What I just committed uses your idea of auto-committing TRUNCATE et al,
> but now that I review the thread I think that everyone else thought that
> that was a dangerous idea.  How do you feel about simply throwing an error
> in autocommit-off mode, instead?  (At least it's a localized 
> change now)

Well, if I can throw in another opinion, I think what you did is perfect. 
It will make Oracle users happy too. Only very shrewd applications would
commit previous changes with a "truncate" statement, and those will learn 
to issue a commit before truncate. I don't like the solutions involving 
"set autocommit ...".

Andreas

Tue, 22 Oct 2002 16:35:46 +0200
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: autocommit vs TRUNCATE et al 