Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group