| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: #Personal#: Reg: Multiple queries in a transaction |
| Date: | 2015-02-18 16:15:22 |
| Message-ID: | 1424276122648-5838444.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Drolet | 2015-02-18 18:24:06 | Re: Starting new cluster from base backup |
| Previous Message | Kevin Grittner | 2015-02-18 16:10:41 | Re: #Personal#: Reg: Multiple queries in a transaction |