Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple semicolon separated statements and autocommit - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Multiple semicolon separated statements and autocommit
Date
Msg-id m3itf5vwnl.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: Multiple semicolon separated statements and autocommit  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Multiple semicolon separated statements and autocommit
List pgsql-hackers
Tree view 
"Christopher Kings-Lynne" <chriskl@familyhealth.com.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()?

-Doug
-- 
Free Dmitry Sklyarov! 
http://www.freesklyarov.org/ 

We will return to our regularly scheduled signature shortly.

pgsql-hackers by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Escaping strings for inclusion into SQL queries
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Full Text Indexing