From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Rod Taylor <rbt(at)rbt(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: problem with new autocommit config parameter and jdbc |
Date: | 2002-09-11 01:07:00 |
Message-ID: | 200209110307.01013.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On Wednesday 11 September 2002 02:09 am, Stephan Szabo wrote:
> 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).
>
Why rollback.This is error (typing error).Nothing happen.
I think that we need clear set : what is start transaction ?
I think that transaction start with change data in database
(what don't change data this start not transaction.
Oracle dot this and I think that is correct))
P.S when I can find SQL 99 specification ?
regards
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-11 01:14:22 | Re: problem with new autocommit config parameter and jdbc |
Previous Message | Stephan Szabo | 2002-09-11 00:09:08 | Re: problem with new autocommit config parameter and jdbc |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-11 01:14:22 | Re: problem with new autocommit config parameter and jdbc |
Previous Message | Clinton Adams | 2002-09-11 00:17:40 | Re: little off-topic: stored procedures |