autocommit in 7.4

Started by Christian Traberover 22 years ago5 messagesgeneral
Jump to latest
#1Christian Traber
christian@traber-net.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christian Traber (#1)
Re: autocommit in 7.4

Christian Traber <christian@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

#3tc
tc@traber.biz
In reply to: Tom Lane (#2)
Re: autocommit in 7.4

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

#4Christian Traber
christian@traber-net.de
In reply to: Tom Lane (#2)
Re: autocommit in 7.4

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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christian Traber (#4)
Re: autocommit in 7.4

Christian Traber <christian@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