Received: from aua2.aua.auc.dk (aua2.aua.auc.dk [130.225.54.5]) by hub.org (8.10.1/8.10.1) with ESMTP id e8UAA8p24323 for ; Sat, 30 Sep 2000 06:10:08 -0400 (EDT) Received: from obel.auc.dk (cw.obel.auc.dk [192.168.64.3]) by aua.auc.dk (PMDF V5.2-32 #30369) with SMTP id <01JUS7XKQ0I48Y5DVE@aua.auc.dk> for pgsql-sql@postgresql.org; Sat, 30 Sep 2000 12:10:07 MET-DST Received: (qmail 19163 invoked from network); Sat, 30 Sep 2000 10:06:29 +0000 Received: from plc.obel.auc.dk (HELO cs.auc.dk) (192.168.64.31) by cw.obel.auc.dk with SMTP; Sat, 30 Sep 2000 10:06:29 +0000 Date: Sat, 30 Sep 2000 12:08:56 +0100 From: "Poul L. Christiansen" Subject: Re: Transaction isolation level for plpgsql To: pgsql-sql@postgresql.org Cc: Keith Wong Message-id: <39D5C9C8.9121894E@cs.auc.dk> MIME-version: 1.0 X-Mailer: Mozilla 4.71 [en] (WinNT; U) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en,pdf References: <4.3.2.7.0.20000930114452.00b97698@mail.e-magine.com.au> X-Archive-Number: 200009/240 Use the command "\h set" and you'll see the parameters. test=# \h set Command: SET Description: Set run-time parameters for session Syntax: SET variable { TO | = } { value | 'value' | DEFAULT } SET CONSTRAINTS {ALL | constraintlist} mode SET TIME ZONE { 'timezone' | LOCAL | DEFAULT } SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } test=# show transaction isolation level; NOTICE: TRANSACTION ISOLATION LEVEL is READ COMMITTED SHOW VARIABLE test=# HTH, Poul L. Christiansen Keith Wong wrote: > > Hi all, > > 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? > > Cheers, > Keith.