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: Pine.LNX.4.58.0408231615000.2753@p-roman.jct.ac.il (view raw or flat)
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?
Thanks.

-- 
Evgeny.

Responses

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-2014 The PostgreSQL Global Development Group