Re: SET AUTOCOMMIT OFF - Mailing list pgsql-general

From Kathy Zhu
Subject Re: SET AUTOCOMMIT OFF
Date
Msg-id 3FA96B1B.1464B192@Sun.COM
Whole thread Raw
In response to SET AUTOCOMMIT OFF  (Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>)
Responses Re: SET AUTOCOMMIT OFF  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Do you mean that, this doesn't work any more ??

from jdbc
connextion.setAutoCommit(false)


Tom Lane wrote:

> Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET> 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 it.  See the release notes.
>
> BTW, if you are going to load any huge databases I'd suggest updating to
> beta5 or RC1 first.  We forced an initdb between beta4 and beta5 IIRC.
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


pgsql-general by date:

Previous
From: George Essig
Date:
Subject: Re: tsearch2 and gist index bloat
Next
From: Andrew Sullivan
Date:
Subject: Re: Multi-master asynchronous replication