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

From Peter Eisentraut
Subject Re: Multiple semicolon separated statements and autocommit
Date
Msg-id Pine.LNX.4.30.0108311050390.679-100000@peter.localdomain
Whole thread Raw
In response to Re: Multiple semicolon separated statements and autocommit  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne writes:

> Are you sure?

Yes.

> 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;'...

Not if they're sent in the same query string.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Escaping strings for inclusion into SQL queries
Next
From: Rene Pijlman
Date:
Subject: Re: Multiple semicolon separated statements and autocommit