On Wed, 11 Sep 2002, snpe wrote: > yes, we're going around in circles. > > Ok.I agreed (I think because Oracle do different) > Transaction start > I type invalid command > I correct command > I get error > > Why.If is it transactin, why I get error > I want continue. > I am see this error with JDeveloper (work with Oracle, DB2 an SQL Server)
Right, that's a separate issue (I alluded to it earlier, but wasn't sure that's what you were interested in). PostgreSQL treats all errors as unrecoverable. It may be a little loose about immediately rolling back due to the fact that historically autocommit was on and it seemed better to not go into autocommit mode after the error. I doubt that 7.3 is going to change that behavior, but a case might be made that when autocommit is off the error immediately causes a rollback and new transaction will start upon the next statement (that would normally start a transaction). At some point in the future, you'll probably be able to do nested transactions or savepoints or error recovery and this will all be moot. > It is not matter for me transaction or not.I get error for correct command > after invalid ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
