Skip site navigation (1) Skip section navigation (2)

psql and autocommit

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: pgsql-admin(at)postgresql(dot)org
Subject: psql and autocommit
Date: 2004-08-23 13:21:33
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Hi all!
I am using 7.3.4 
while executing psql -c the query is not commited
that is probably because i have setted the autocommit = false
However that is very unheandy - i have to add begin and 
commit to my shell scripts.I beleave that automatically
commiting the psql -c queries is very logical thing.
Is there a way to avoid this ?
If that is not changed in 7.4  maybe it should be in 
future versions?



pgsql-admin by date

Next:From: Radu-Adrian PopescuDate: 2004-08-23 13:40:16
Subject: Re: psql and autocommit
Previous:From: Kevin IzzetDate: 2004-08-23 07:33:36
Subject: Re: Looking for tool for Graphic Database Design

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group