By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

SET AUTOCOMMIT OFF

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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 | (610) 359-1001
+ 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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.