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
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 client?
\set AUTOC
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!
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 FA
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 a
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.
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 hu
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
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
tel;fax:+33
