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,
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
