Re: Multiple semicolon separated statements and autocommit

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Multiple semicolon separated statements and autocommit
Дата
Msg-id Pine.LNX.4.30.0108311050390.679-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Multiple semicolon separated statements and autocommit  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Escaping strings for inclusion into SQL queries
Следующее
От: Rene Pijlman
Дата:
Сообщение: Re: Multiple semicolon separated statements and autocommit