Setting the transaction isolation level for a stored procedure

Поиск
Список
Период
Сортировка
От Keith Wong
Тема Setting the transaction isolation level for a stored procedure
Дата
Msg-id 4.3.2.7.0.20000928000433.00b775d8@mail.e-magine.com.au
обсуждение исходный текст
Ответы Transaction isolation level for plpgsql
Список pgsql-sql
Sorry, I forgot to put a subject title in my last email. So here it is again.

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 по дате отправления:

Предыдущее
От: Keith Wong
Дата:
Сообщение:
Следующее
От: Webb Sprague
Дата:
Сообщение: Getting number of days