Postgres Pro
Downloads
Home   >   mailing lists

Thread: SET AUTOCOMMIT OFF

SET AUTOCOMMIT OFF

From
Thierry Missimilly
Date:
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
Attachment

Re: SET AUTOCOMMIT OFF

From
Tom Lane
Date:
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

Re: SET AUTOCOMMIT OFF

From
Kathy Zhu
Date:
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

Re: SET AUTOCOMMIT OFF

From
Bruce Momjian
Date:
Kathy Zhu wrote:
> Do you mean that, this doesn't work any more ??
>
> from jdbc
> connextion.setAutoCommit(false)

jdbc still works.  We have pushed the autocommit out to the clients like
psql and jdbc, rather than having the backend do it.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073