Postgres Pro
Downloads
Home   >   mailing lists

Re: SET AUTOCOMMIT OFF - Mailing list pgsql-general

From Tom Lane
Subject Re: SET AUTOCOMMIT OFF
Date
Msg-id 2104.1068045634@sss.pgh.pa.us
Whole thread Raw
In response to SET AUTOCOMMIT OFF  (Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL v7.4 Release Candidate 1
Next
From: Michael Glaesemann
Date:
Subject: Re: Help on update that subselects other records in table, uses joins