Skip site navigation (1) Skip section navigation (2)

Re: isolation level and autocommit

From: Manfred Rebentisch <mrebentisch(at)comparat(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: isolation level and autocommit
Date: 2005-04-23 19:09:04
Message-ID: 200504232109.04983.mrebentisch@comparat.de (view raw or flat)
Thread:
Lists: pgsql-admin
Am Samstag, 23. April 2005 11:20 schrieb Peter Eisentraut:
> Manfred Rebentisch wrote:
> > I want to have 'autocommit=true' with the one database and the above
> > behaviour with the other database. How do I realize that?
>
> I suspect you could set it with ALTER DATABASE ... SET autocommit =
> true.
>
> But the behavior of autocommit is really confusing and for that reason
> the option was removed in 7.4 so you may not want to bother learning
> its semantics.

Aah! Thank you for this information! I will have a look to 7.4 and come back, 
if I have more questions.

Bye
Manfred

In response to

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-04-23 20:43:41
Subject: Re: Killing Processes
Previous:From: Christopher BrowneDate: 2005-04-23 18:00:11
Subject: Re: Killing Processes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group