Re: Changing the transaction isolation level within the

Поиск
Список
Период
Сортировка
Искать
От
Markus Schaber
Тема
Re: Changing the transaction isolation level within the
Дата
Msg-id
43D88B41.9040904@logix-tt.com
Ответ на
Re: Changing the transaction isolation level within the (Mario Splivalo)
Список
Дерево обсуждения
Changing the transaction isolation level within the stored procedure? Mario Splivalo <mario.splivalo@mobart.hr>
Re: Changing the transaction isolation level within the stored Markus Schaber <schabi@logix-tt.com>
Re: Changing the transaction isolation level within the Mario Splivalo <mario.splivalo@mobart.hr>
Re: Changing the transaction isolation level within the stored Markus Schaber <schabi@logix-tt.com>
Re: Changing the transaction isolation level within Mario Splivalo <mario.splivalo@mobart.hr>
Re: Changing the transaction isolation level within the stored Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Changing the transaction isolation level within the stored Andrew Sullivan <ajs@crankycanuck.ca>
Re: Changing the transaction isolation level within the stored Markus Schaber <schabi@logix-tt.com>
Re: Changing the transaction isolation level within the stored Andrew Sullivan <ajs@crankycanuck.ca>
Re: Changing the transaction isolation level within the stored Markus Schaber <schabi@logix-tt.com>
Re: Changing the transaction isolation level within the stored procedure? Jaime Casanova <systemguards@gmail.com>
Re: Changing the transaction isolation level within the Mario Splivalo <mario.splivalo@mobart.hr>
Re: Changing the transaction isolation level within the Markus Schaber <schabi@logix-tt.com> 
Hi, Mario,

Mario Splivalo wrote:

>>you need to set the transaction level after the begin and before every
>>other statement... after the begin you have a select that invoke your
>>function so that set is not the first statement...
> 
> But I can't do that inside of a function, right?

Right, as you need a SELECT to actually execute your function, so the
transaction commands inside the function are invoced _after_ the first
SELECT began execution.

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
В списке pgsql-sql по дате отправления
Предыдущее
От: Mario Splivalo
Дата:
Следующее
От: Markus Schaber
Дата:
FAQ