On Mon, 23 Aug 2004, Radu-Adrian Popescu wrote:
> Tsirkin Evgeny wrote:
> > 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).
In response to
pgsql-admin by date
|Next:||From: Andrew Hammond||Date: 2004-08-23 15:04:18|
|Subject: Re: mySQL to postgreSQL: Request for pointers to perl/php|
|Previous:||From: Radu-Adrian Popescu||Date: 2004-08-23 13:40:16|
|Subject: Re: psql and autocommit|