Re: A bad behavior under autocommit off mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: "'pgsql-hackers'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A bad behavior under autocommit off mode
Date: 2003-02-20 17:31:09
Message-ID: 23439.1045762269@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2003-02-20 17:35:22 Re: request for sql3 compliance for the update command
Previous Message Dave Cramer 2003-02-20 16:49:16 Re: request for sql3 compliance for the update command