Postgres Pro
Downloads
Home   >   mailing lists

Re: isolation level and autocommit - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: isolation level and autocommit
Date
Msg-id 200504231120.16334.peter_e@gmx.net
Whole thread Raw
In response to isolation level and autocommit  (Manfred Rebentisch <MRebentisch@comparat.de>)
Responses Re: isolation level and autocommit  (Manfred Rebentisch <mrebentisch@comparat.de>)
List pgsql-admin
Tree view 
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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL code versioning (views, functions, etc)
Next
From: Geoffrey
Date:
Subject: Re: Installing PostGres