Received: from mailout06.sul.t-online.com (mailout06.sul.t-online.com [194.25.134.19]) by hub.org (8.10.1/8.10.1) with ESMTP id e8UArbp31280 for ; Sat, 30 Sep 2000 06:53:37 -0400 (EDT) Received: from fmrl00.sul.t-online.de by mailout06.sul.t-online.com with smtp id 13fKGg-0004de-00; Sat, 30 Sep 2000 12:53:22 +0200 Received: from [192.168.100.2] (520083510237-0001@[212.185.245.102]) by fmrl00.sul.t-online.com with esmtp id 13fKGW-0wkxvMC; Sat, 30 Sep 2000 12:53:12 +0200 Date: Sat, 30 Sep 2000 12:56:49 +0200 (CEST) From: Peter Eisentraut To: Keith Wong cc: pgSQL Subject: Re: Transaction isolation level for plpgsql In-Reply-To: <4.3.2.7.0.20000930114452.00b97698@mail.e-magine.com.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Sender: 520083510237-0001@t-dialin.net X-Archive-Number: 200009/241 Keith Wong writes: > Does anybody know the transaction isolation level default when a plpgsql > stored procedure is called? > Is it possible to set it? Or is this controlled by SPI? It's whatever the transaction that called the function was set to. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/