Обсуждение: SET AUTOCOMMIT OFF

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

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

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

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