Re: Help with SET TRANSACTION in a function

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Help with SET TRANSACTION in a function
Дата
Msg-id 20020304124237.R80169-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Help with SET TRANSACTION in a function  (otis_usenet@yahoo.com (OtisUsenet))
Список pgsql-general
On 28 Feb 2002, OtisUsenet wrote:

> Hello,
>
> I was wondering if anyone here can help.  I could not get any help on
> pgsql-sql  nor pgsql-general mailing lists.
>
> I'm having trouble getting functions with SET TRANSACTION ISOLATION
> ... to parse.

Without nested transactions, you're not going to have any luck I think.
First of all the extra begin/end in the function are not allowed and
IIRC, set transaction isolation level must be the first statement of the
transaction which it won't be since the enclosing transaction will have
started the select simple_fun().


В списке pgsql-general по дате отправления:

Предыдущее
От: Ron Snyder
Дата:
Сообщение: trying to upgrade and keep large object IDs intact...
Следующее
От: James Leigh
Дата:
Сообщение: lo_open problems