By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

autocommit in 7.4

P: n/a
Hi,

thanks for the new great version!

Only one small problem, how can I disable autocommit in Postgres 7.4 in
libpgtcl and psql?
I found something about .psqlrc but how is the syntax and how can I set it
for libpgtcl?

BTW, SET AUTOCOMMIT TO ON still gives no error, only SET AUTOCOMMIT TO OFF
says ERROR: SET AUTOCOMMIT TO OFF is no longer supported.
Thanks and best regards,
Christian
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Christian Traber <ch*******@traber-net.de> writes:
Only one small problem, how can I disable autocommit in Postgres 7.4 in
libpgtcl and psql?
I found something about .psqlrc but how is the syntax and how can I set it
for libpgtcl?


In psql, "\set AUTOCOMMIT off". In libpgtcl, I think you're out of luck
:-( ... AFAIR no one got around to writing any autocommit control logic
for libpgtcl. You are of course welcome to write some and send it in if
you need it ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

P: n/a
Tom Lane wrote:

In psql, "\set AUTOCOMMIT off". In libpgtcl, I think you're out of luck
... AFAIR no one got around to writing any autocommit control logic
for libpgtcl. You are of course welcome to write some and send it in if
you need it ...


Ok, I'll try to make it. Do you know any reason why libpgtcl is not
tclstub enabled?
Maybe I 'll try to build it with stubs...

Regards,
Christian
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #3

P: n/a
Christian Traber <ch*******@traber-net.de> writes:
Ok, I'll try to make it. Do you know any reason why libpgtcl is not
tclstub enabled?


Nobody's done the work (I don't think tclstub even existed the last time
anyone was doing serious work on libpgtcl). If you think it's worth
having, and it can be done without breaking backwards compatibility with
older Tcl releases, go for it ...

regards, tom lane

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

Nov 12 '05 #4

P: n/a
tc
Tom Lane wrote:

In psql, "\set AUTOCOMMIT off". In libpgtcl, I think you're out of luck
:-( ... AFAIR no one got around to writing any autocommit control logic
for libpgtcl. You are of course welcome to write some and send it in if
you need it ...


Ok, I'll try to make it. Do you know any reason why libpgtcl is not
tclstub enabled?
Maybe I 'll try to build it with stubs...

Regards,
Christian
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.