Re: #Personal#: Reg: Multiple queries in a transaction

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: #Personal#: Reg: Multiple queries in a transaction
Дата
Msg-id 1424276122648-5838444.post@n5.nabble.com
обсуждение исходный текст
Ответ на #Personal#: Reg: Multiple queries in a transaction  (Medhavi Mahansaria <medhavi.mahansaria@tcs.com>)
Список pgsql-general
Medhavi Mahansaria wrote
> I need to execute a series of queries in a transaction, say Q1, Q2, Q3.
> [...]
> Is there a way to turn autocommit off?

I assume you meant turn Autocommit on?

So, do you want to execute the queries in a transaction or do you want to
autocommit each one?

Autocommit is a behavior of your client library, not the server.  Check its
documentation, whatever it is, for details.

As mentioned save points will probably work too.

If you explain why you think you need this then you may also get alternative
suggestions.

David J.




--
View this message in context:
http://postgresql.nabble.com/Personal-Reg-Multiple-queries-in-a-transaction-tp5838427p5838444.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: #Personal#: Reg: Multiple queries in a transaction
Следующее
От: Guillaume Drolet
Дата:
Сообщение: Re: Starting new cluster from base backup