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 <mario.splivalo@mobart.hr>)
Список pgsql-sql
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
Дата:
Сообщение: Re: Changing the transaction isolation level within the
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: Changing the transaction isolation level within the stored