| From: | Keith Wong <keith(at)e-magine(dot)com(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | |
| Date: | 2000-09-27 13:32:40 |
| Message-ID: | 4.3.2.7.0.20000927233117.00b60e80@mail.e-magine.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Wong | 2000-09-27 14:06:03 | Setting the transaction isolation level for a stored procedure |
| Previous Message | Philip Warner | 2000-09-27 11:10:12 | Change of behaviour of pg_get_userbyid & pg_get_viewdef - do it? |