Thread: set autocommit TO FALSE on postgres 7.4

set autocommit TO FALSE on postgres 7.4

From
"Luiz Rafael Culik Guimaraes"
Date:
Dear Friends

As Subject

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

Regards
Luiz


Re: set autocommit TO FALSE on postgres 7.4

From
jseymour@LinxNet.com (Jim Seymour)
Date:
>
> 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/

Re: set autocommit TO FALSE on postgres 7.4

From
Robert Treat
Date:
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