Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 23439.1045762269@sss.pgh.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  ("Hiroshi Inoue" <inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
"Hiroshi Inoue" <inoue@tpf.co.jp> writes:
> The simplest way seems to accept COMMIT any time under autocommit
> off mode.

That's just hiding the most visible symptom.  The real problem here is
that the SELECT is already committed, when it shouldn't be.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Mike Aubury
Date:
Subject: Re: request for sql3 compliance for the update command
Next
From: Dave Cramer
Date:
Subject: Re: request for sql3 compliance for the update command