Re: #Personal#: Reg: Multiple queries in a transaction - Mailing list pgsql-general

From David G Johnston
Subject Re: #Personal#: Reg: Multiple queries in a transaction
Date
Msg-id 1424276122648-5838444.post@n5.nabble.com
Whole thread Raw
In response to #Personal#: Reg: Multiple queries in a transaction  (Medhavi Mahansaria <medhavi.mahansaria@tcs.com>)
List 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 by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: #Personal#: Reg: Multiple queries in a transaction
Next
From: Guillaume Drolet
Date:
Subject: Re: Starting new cluster from base backup