Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 3E55B95C.F069D9C9@tpf.co.jp
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  ("Hiroshi Inoue" <inoue@tpf.co.jp>)
Responses autocommit off mode, how does it work?
List pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Tom Lane wrote:
> >> IIRC, the SET does *not* start a transaction,
> 
> > Yes but doesn't autocommit-off mode mean that
> > it implicitly begins a transaction in suitable
> > places ? For example, 'set autocommit to off;
> > declare .. cursor ..' works though it never
> > work without BEGIN under autocommit-on mode.
> 
> But the DECLARE would start a transaction --- AFAIR,

Yes it's only because the behavior is useful for us.

So isn't the problem if the warning message for   'set autocommit to off;commit'
is useful or not ?
IMHO it's rather a harmful message.

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: contrib Makefile's and OS X
Next
From: Greg Stark
Date:
Subject: Re: request for sql3 compliance for the update command