Re: [SQL] Transaction isolation level for plpgsql

2000-09-30 Thread Peter Eisentraut
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 [EMAIL PROTECTED]

Re: [SQL] Transaction isolation level for plpgsql

2000-09-30 Thread Poul L. Christiansen
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 TRAN

[SQL] Transaction isolation level for plpgsql

2000-09-29 Thread Keith Wong
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.