Re: Multiple semicolon separated statements and autocommit

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: Doug McNaught <doug(at)wireboard(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multiple semicolon separated statements and autocommit
Date: 2001-08-31 10:02:40
Message-ID: f2ouotkchf6tm7d9ndga5m35eo6nt8s3p0@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 30 Aug 2001 21:35:42 -0400, you wrote:
>"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> Are you sure? I thought all that autocommit meant was that a statement that
>> is not enclosed within a begin/commit is automatically committed after it is
>> run. So, in the this case all three queries will be independent, unless the
>> first statements is a 'begin;' and the last is a 'commit;'...
>
>What does the JDBC spec say about autocommit and ExecuteBatch()?

Not much, but that's a different story. We're still in the
process of figuring out how to implement this feature exactly.
That discussion is on the pgsql-jdbc list.

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2001-08-31 10:15:47 Re: [OT] Re: User locks code
Previous Message Peter Eisentraut 2001-08-31 08:51:09 Re: Multiple semicolon separated statements and autocommit