Re: set autocommit TO FALSE on postgres 7.4 - Mailing list pgsql-general

From Robert Treat
Subject Re: set autocommit TO FALSE on postgres 7.4
Date
Msg-id 1083682454.14697.290.camel@camel
Whole thread Raw
In response to Re: set autocommit TO FALSE on postgres 7.4  (jseymour@LinxNet.com (Jim Seymour))
List pgsql-general
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


pgsql-general by date:

Previous
From: Vikram Kulkarni
Date:
Subject: Re: 7.4.2 Regression tests: test stats loops indefinately...
Next
From: Stephan Szabo
Date:
Subject: Re: pgsql documentation error ?