Just a note to clarify sqlplus
It does start in noautocommit as you say.
However, it issues a commit when you exit (with quit, Ctrl-D or whatever)
which is (in my opinion) incorrect, and very much worth taking into account
when writing scripts for Oracle.
I think it should automatically issue a rollback on exit.
regards,
Stephen.
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.
> 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.
>
> Regards,