On Dec 10, 2007 2:48 PM, Keary Suska <[EMAIL PROTECTED]> wrote: > on 12/10/07 12:15 PM, [EMAIL PROTECTED] purportedly said: > > > To work around this I add an dbCon.rollBack() after select statement > > above in good and in bad times. After that ALTER works. > > Can someone explain me why I need this rollback ? > > You only need the rollback when the SELECT statement fails. When an error > occurs within a transaction, the transaction is aborted but not rolled back. > There are likely reasons why the rollback isn't automatic, but I don't know > them.
I think you confuse postgresql with some other database. Without setting a savepoint, any error during a transaction and roll it back upon connection close | rollback | commit. I.e. the rollback IS automatic. Just not necessarily immediate. > Your choice is either to run the commands in an "autocommit" mode or, as you > are doing, rollback (or commit, if there was no error) after the SELECT. You can commit with an error. It'll do the same thing as a rollback; ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
