X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57D4953A99 for ; Wed, 20 Apr 2005 05:38:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88912-05 for ; Wed, 20 Apr 2005 08:37:53 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3E93A5353E for ; Wed, 20 Apr 2005 05:37:53 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j3K8bq1G090893 for ; Wed, 20 Apr 2005 08:37:52 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j3K8MAsF087262 for pgsql-admin@postgresql.org; Wed, 20 Apr 2005 08:22:10 GMT (envelope-from news) From: Manfred Rebentisch X-Newsgroups: pgsql.admin Subject: isolation level and autocommit Date: Wed, 20 Apr 2005 10:12:51 +0200 Organization: COMPARAT GmbH Lines: 25 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: usenet-abuse@t-online.de X-ID: bu3SHYZFwewJdnCZnQp4NnfYUhiuRjQ9pr3Mn+iltz-C0mjKnOoe8O User-Agent: KNode/0.8.2 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/330 X-Sequence-Number: 17343 I have a question to configuration of PostgreSQL 7.3 If in var/lib/pgsql/data/postgresql.conf the variable autocommit is set to true, I cannot work with transactions, because all is commited immediately. I set autocommit to false and set default_transaction_isolation = 'serializable', because this I need for one application. In this application I set the following command after connect: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE Its work perfect. But if I work with phpPgAdmin on the database, I have to use "BEGIN" and "COMMIT" with every action. Is this changeable? It may be ok for me, if it is only for the one database, but it is now for every pgsql-database on this server. I want to have 'autocommit=true' with the one database and the above behaviour with the other database. How do I realize that? Thank you for comments in advance. Manfred Rebentisch