SET AUTOCOMMIT OFF

[Thierry Missimilly]

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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Thierry Missimilly <TH****************@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]

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

from jdbc
connextion.setAutoCommit(false)
Tom Lane wrote:

Thierry Missimilly <TH****************@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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Bruce Momjian]

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
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend