| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Hammond | 2004-08-23 15:04:18 | Re: mySQL to postgreSQL: Request for pointers to perl/php |
| Previous Message | Radu-Adrian Popescu | 2004-08-23 13:40:16 | Re: psql and autocommit |