Re: [Fwd: Re: [JDBC] Patch for handling "autocommit=false"

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [Fwd: Re: [JDBC] Patch for handling "autocommit=false"
Date: 2002-10-11 05:17:02
Message-ID: 200210110517.g9B5H2w25526@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Barry Lind wrote:
> Did anything come of this discussion on whether SET initiates a
> transaction or not?

SET does not start a multi-statement transaction when autocommit is off.

> In summary what is the right way to deal with setting autocommit in clients?

I guess just 'set autocommit to on' will do it.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mario Weilguni 2002-10-11 07:14:50 number of attributes in page files?
Previous Message Bruce Momjian 2002-10-11 04:10:42 Re: Diff for src/interfaces/libpq/fe-connect.c between version