Re: set autocommit TO FALSE on postgres 7.4

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Jim Seymour <jseymour(at)LinxNet(dot)com>, Luiz Rafael Culik Guimaraes <culikr(at)brturbo(dot)com>
Subject: Re: set autocommit TO FALSE on postgres 7.4
Date: 2004-05-04 14:54:14
Message-ID: 1083682454.14697.290.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-05-04 15:00:35 Re: pgsql documentation error ?
Previous Message Vikram Kulkarni 2004-05-04 14:51:30 Re: 7.4.2 Regression tests: test stats loops indefinately...