Hi All,
I am new to Postgresql and I need to turn off the AUTO COMMIT in
PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off;
does not seem to be supported any more in PostgreSQL 8.3.
Many thanks for help!
a.bhattacha...@sungard.com a.bhattacha...@sungard.com wrote:
Hi All,
I am new to Postgresql and I need to turn off the AUTO COMMIT in PostgreSQL
8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off; does not seem to
be supported any more in PostgreSQL 8.3.
Do you using psql as
a.bhattacha...@sungard.com wrote:
Hi All,
I am new to Postgresql and I need to turn off the AUTO COMMIT in
PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off;
does not seem to be supported any more in PostgreSQL 8.3.
Just explicitly begin a transaction, like you do
Hello!
I want to disable autocommit, my psqlrc:
SET client_min_messages = 'WARNING';
SET add_missing_from = false;
\set AUTOCOMMIT off
it has no effect:
echo show AUTOCOMMIT | psql
SET
SET
autocommit
on
(1 row)
How can I disable autocommit in psqlrc?
Thanks,
Axel.
Axel Straschil writes:
I want to disable autocommit, my psqlrc:
SET client_min_messages = 'WARNING';
SET add_missing_from = false;
\set AUTOCOMMIT off
it has no effect:
echo show AUTOCOMMIT | psql
SET
SET
autocommit
on
(1 row)
How can I disable autocommit in
Hallo!
It is. You're just looking at the no-op GUC variable instead of the
psql one. Try
\echo :AUTOCOMMIT
instead.
Oh, your right, just tested, it is ;-)
Thanks,
AXEL.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Hi,
I have got an error with PostgreSQL-7.4Beta4 :
ERROR SET AUTOCOMMIT TO OFF is no longer supported
I used these option to load huge Database as i can save time with it. Is
there an other option in PG 7.4 to do the same ?
Regards
Thierry Missimilly
begin:vcard
n:Missimilly;Thierry
Thierry Missimilly [EMAIL PROTECTED] writes:
I have got an error with PostgreSQL-7.4Beta4 :
ERROR SET AUTOCOMMIT TO OFF is no longer supported
I used these option to load huge Database as i can save time with it. Is
there an other option in PG 7.4 to do the same ?
psql has a \set command for
Do you mean that, this doesn't work any more ??
from jdbc
connextion.setAutoCommit(false)
Tom Lane wrote:
Thierry Missimilly [EMAIL PROTECTED] writes:
I have got an error with PostgreSQL-7.4Beta4 :
ERROR SET AUTOCOMMIT TO OFF is no longer supported
I used these option to load huge