From: | Medhavi Mahansaria <medhavi(dot)mahansaria(at)tcs(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | #Personal#: Reg: Multiple queries in a transaction |
Date: | 2015-02-18 15:06:45 |
Message-ID: | OFF3E794A5.7FA2035D-ON65257DF0.0052713C-65257DF0.005303DC@tcs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I need to execute a series of queries in a transaction, say Q1, Q2, Q3.
Q1 -> success
Q2 -> Failed
Q3 -> Success
My issue is that after Q2 fails all the queries that follow give error "E
RROR: current transaction is aborted, commands ignored until end of
transaction block"
I want to move ahead in the transaction and execute Q3 also even though Q2
was a failure.
Can you please suggest a way to do so in PostgreSQL 9.3.
Is there a way to turn autocommit off?
Thanks & Regards
Medhavi Mahansaria
Tata Consultancy Services Limited
Unit-VI, No.78, 79& 83,
L-Centre, EPIP Industrial Estate,
Whitefield
Bangalore - 560066,Karnataka
India
Ph:- +91 80 67253769
Cell:- +91 9620053040
Mailto: medhavi(dot)mahansaria(at)tcs(dot)com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-02-18 15:34:33 | Re: Failure loading materialized view with pg_restore |
Previous Message | Rémi Cura | 2015-02-18 14:55:54 | Re: Missing table from in INSERT RETURNING |