psql and autocommit

[Tsirkin Evgeny]

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.

[Radu-Adrian Popescu]

Tsirkin Evgeny wrote:
[snip]

Post by Tsirkin Evgeny
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.
[phone]


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Tsirkin Evgeny]

Post by Radu-Adrian Popescu
[snip]

Post by Tsirkin Evgeny
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.

Post by Radu-Adrian Popescu
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).

Post by Radu-Adrian Popescu
Regards,

[Stephen Kennedy]

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.

Post by Radu-Adrian Popescu
[snip]

Post by Tsirkin Evgeny
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

[Tsirkin Evgeny]

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

Post by Stephen Kennedy
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.

Post by Radu-Adrian Popescu
[snip]

Post by Tsirkin Evgeny
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

[Tom Lane]

Post by Tsirkin Evgeny
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 ...

Post by Tsirkin Evgeny
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org