autocommit in 7.4

[Christian Traber]

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

[Tom Lane]

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

[Christian Traber]

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

[Tom Lane]

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

[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