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
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 |