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

Re: psql and autocommit

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: Radu-Adrian Popescu <radu(dot)popescu(at)aldratech(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql and autocommit
Date: 2004-08-23 13:48:59
Message-ID: Pine.LNX.4.58.0408231646390.4288@p-roman.jct.ac.il (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-admin by date

Next:From: Andrew HammondDate: 2004-08-23 15:04:18
Subject: Re: mySQL to postgreSQL: Request for pointers to perl/php
Previous:From: Radu-Adrian PopescuDate: 2004-08-23 13:40:16
Subject: Re: psql and autocommit

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