Re: SET AUTOCOMMIT OFF

From: Kathy Zhu <Kathy(dot)Zhu(at)Sun(dot)COM>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SET AUTOCOMMIT OFF
Date: 2003-11-05 21:26:51
Message-ID: 3FA96B1B.1464B192@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Do you mean that, this doesn't work any more ??

from jdbc
connextion.setAutoCommit(false)

Tom Lane wrote:

> Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-11-05 21:55:12 Re: Multi-master asynchronous replication
Previous Message George Essig 2003-11-05 21:24:43 Re: tsearch2 and gist index bloat