Received: from mail-ob03.one.net.au (mail-ob03.one.net.au [61.12.0.163])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8RC8Ar18728
	for <pgsql-sql@postgresql.org>; Wed, 27 Sep 2000 08:08:10 -0400 (EDT)
Received: Received: [from darthvader.e-magine.com.au
	(async229-syd-isp-250.nas.one.net.au [203.101.68.230])
	by mail-ob03.one.net.au  with ESMTP id e8RC7uq29334
	for <pgsql-sql@postgresql.org>; Wed, 27 Sep 2000 22:08:00 +1000 (EST)]
Message-Id: <4.3.2.7.0.20000927233117.00b60e80@mail.e-magine.com.au>
X-Sender: e-magine@mail.e-magine.com.au
X-Mailer: QUALCOMM Windows Eudora Version 4.3.2
Date: Wed, 27 Sep 2000 23:32:40 +1000
To: pgsql-sql@postgresql.org
From: Keith Wong <keith@e-magine.com.au>
Subject: 
In-Reply-To: <Pine.SGI.3.96.1000924235807.98340A-100000@www.cdfd.org.in>
References: <39CE1B5D.B216E84F@earthlink.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200009/220

Hi ppl,

Just wondering if anyone knows if its possible to set the transaction 
isolation
level from inside a stored procedure in plpgsql. Or do I need to run the 
'set transaction
isolation level' command before I called the stored procedure? I'm not even 
sure that
would work, I assume plpgsql uses the current transaction isolation level?

Any help would be much appreciated :)

Cheers, Keith.