Thread: how to turn off autocommit in psql

how to turn off autocommit in psql

From
Kemin Zhou
Date:
I search far and wide and found a lot of disscussions about the 
autocommit, but none about how to do it. 
After reading 50 pages, my brain is numb.  Could any one give me a 
simple help?
Thanks

Kemin



**********************************************************************
Proprietary or confidential information belonging to Ferring Holding SA or to one of its affiliated companies may be
containedin the message. If you are not the addressee indicated in this message (or responsible for the delivery of the
messageto such person), please do not copy or deliver this message to anyone. In such case, please destroy this message
andnotify the sender by reply e-mail. Please advise the sender immediately if you or your employer do not consent to
e-mailfor messages of this kind. Opinions, conclusions and other information in this message represent the opinion of
thesender and do not necessarily represent or reflect the views and opinions of Ferring.
 
**********************************************************************



Re: how to turn off autocommit in psql

From
Paul Thomas
Date:
On 26/03/2004 01:25 Kemin Zhou wrote:
> I search far and wide and found a lot of disscussions about the 
> autocommit, but none about how to do it. After reading 50 pages, my 
> brain is numb.  Could any one give me a simple help?
> Thanks
> 
> Kemin

Use tranactions.

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for 
Business             |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+