Thread: psql and autocommit
Hi all! I am using 7.3.4 while executing psql -c the query is not commited that is probably because i have setted the autocommit = false However that is very unheandy - i have to add begin and commit to my shell scripts.I beleave that automatically commiting the psql -c queries is very logical thing. Is there a way to avoid this ? If that is not changed in 7.4 maybe it should be in future versions? Thanks. -- Evgeny.
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, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243
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.
Tsirkin Evgeny <tsurkin@mail.jct.ac.il> writes:
> I am using 7.3.4
> while executing psql -c the query is not commited
> that is probably because i have setted the autocommit = false
> However that is very unheandy - i have to add begin and
> commit to my shell scripts.
You have found one of the reasons we decided server-side autocommit was
evil ...
> Is there a way to avoid this ?
Use 7.4. Note that autocommit is a psql feature not a server setting
in 7.4.
regards, tom lane
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,
On Tue, 24 Aug 2004, Stephen Kennedy wrote: You are all right .However i was talking about the writing shell scripts and running psql -c from it .THIS is a big problem if no autocommit is setted on since at the end of the psql -c command there is a disconnect and you have to add a commit to it BEFOR this disconnect.very unhandy . However i understood from Tom that this is solved in 7.4 , just not yet ready to switch to it from my 7.3 server. Thanks > 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 > -- Evgeny.