Re: psql and autocommit - Mailing list pgsql-admin

From Tom Lane
Subject Re: psql and autocommit
Date
Msg-id 9814.1093287187@sss.pgh.pa.us
Whole thread Raw
In response to psql and autocommit  (Tsirkin Evgeny <tsurkin@mail.jct.ac.il>)
List pgsql-admin
Tsirkin Evgeny <tsurkin@mail.jct.ac.il> writes:
> 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.

You have found one of the reasons we decided server-side autocommit was
evil ...

> Is there a way to avoid this ?

Use 7.4.  Note that autocommit is a psql feature not a server setting
in 7.4.

            regards, tom lane

pgsql-admin by date:

Previous
From: Roberto Rezende de Assis
Date:
Subject: Re: Looking for tool for Graphic Database Design
Next
From: "Keith Bottner"
Date:
Subject: Re: Looking for tool for Graphic Database Design