Re: psql and autocommit - Mailing list pgsql-admin

From Tsirkin Evgeny
Subject Re: psql and autocommit
Date
Msg-id Pine.LNX.4.58.0408231646390.4288@p-roman.jct.ac.il
Whole thread Raw
In response to Re: psql and autocommit  (Radu-Adrian Popescu <radu.popescu@aldratech.com>)
List pgsql-admin
On Mon, 23 Aug 2004, Radu-Adrian Popescu wrote:

> Tsirkin Evgeny wrote:
> [snip]
> > commit to my shell scripts.I beleave that automatically
> > commiting the psql -c queries is very logical thing.
>
> I'm sure there are people who disagree with that statement. For instance
> Oracle's sqlplus starts in noautocommit by default. And I've found that to be a
> good thing actually.
Probably a metter of taste.
> For what it's worth I also think default client policy may as well be left
> unchanged, or there will be a lot of baffled people.
You are right.But there is no even a simple flag for psql
that will tell it to do autocommit!(maybe i will manage to use -set
but i don't know how for now).
>
> Regards,
>

--
Evgeny.

pgsql-admin by date:

Previous
From: Radu-Adrian Popescu
Date:
Subject: Re: psql and autocommit
Next
From: Andrew Hammond
Date:
Subject: Re: mySQL to postgreSQL: Request for pointers to perl/php