> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]