Received: from mail-ob01.one.net.au (mail-ob01.one.net.au [61.12.0.161]) by hub.org (8.10.1/8.10.1) with ESMTP id e8RCfRr25465 for ; Wed, 27 Sep 2000 08:41:27 -0400 (EDT) Received: Received: [from darthvader.e-magine.com.au (async229-syd-isp-250.nas.one.net.au [203.101.68.230]) by mail-ob01.one.net.au with ESMTP id e8RCfI801059 for ; Wed, 27 Sep 2000 22:41:19 +1000 (EST)] Message-Id: <4.3.2.7.0.20000928000433.00b775d8@mail.e-magine.com.au> X-Sender: e-magine@mail.e-magine.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Thu, 28 Sep 2000 00:06:03 +1000 To: pgSQL From: Keith Wong Subject: Setting the transaction isolation level for a stored procedure Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/221 Sorry, I forgot to put a subject title in my last email. So here it is again. 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.