- Mailing list pgsql-sql

From Keith Wong
Subject
Date
Msg-id 4.3.2.7.0.20000927233117.00b60e80@mail.e-magine.com.au
Whole thread Raw
In response to Re: Select between two databases  (Indraneel Majumdar <indraneel@www.cdfd.org.in>)
List pgsql-sql
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. 



pgsql-sql by date:

Previous
From: "Koen Antonissen"
Date:
Subject: New used in Non-Rule Query problem solved
Next
From: Keith Wong
Date:
Subject: Setting the transaction isolation level for a stored procedure