set autocommit TO FALSE on postgres 7.4

Started by Luiz Rafael Culik Guimaraesalmost 22 years ago3 messagesgeneral
Jump to latest

Dear Friends

As Subject

How to resolve, since i use with out problem on postgresql 7.3

Regards
Luiz

#2Jim Seymour
jseymour@LinxNet.com
In reply to: Luiz Rafael Culik Guimaraes (#1)
Re: set autocommit TO FALSE on postgres 7.4

Dear Friends

As Subject

How to resolve, since i use with out problem on postgresql 7.3

Don't know, being as I know I've turned off autocommit within
Perl, and I'm *fairly* sure I've done so playing around with
psql, and it's worked as expected.

--
Jim Seymour | Spammers sue anti-spammers:
jseymour@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/

#3Robert Treat
xzilla@users.sourceforge.net
In reply to: Jim Seymour (#2)
Re: set autocommit TO FALSE on postgres 7.4

On Mon, 2004-05-03 at 12:28, Jim Seymour wrote:

Dear Friends

As Subject

How to resolve, since i use with out problem on postgresql 7.3

Don't know, being as I know I've turned off autocommit within
Perl, and I'm *fairly* sure I've done so playing around with
psql, and it's worked as expected.

the autocommit setting was removed from the server in 7.4 (meaning the
back end always runs as autocommit). Basically it caused too many
implementation issues in the back end code, and it was decided this
functionality was better handled on the client side. For a more thorough
explanation check the mail archives.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL