Re: Is setQuerySnapshot called for embedded plpgsql function calls?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is setQuerySnapshot called for embedded plpgsql function calls?
Дата
Msg-id 14454.1170387607@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is setQuerySnapshot called for embedded plpgsql function calls?  ("Burak Seydioglu" <buraks78@gmail.com>)
Список pgsql-novice
"Burak Seydioglu" <buraks78@gmail.com> writes:
> For some reason, the consecutive second_func() calls do not see the
> newly inserted data. So the total for the next second_func() call
> always remains zero. Please see the code below.

> Is this because setQuerySnapshot() is not called for embedded plpgsql
> functions but only for the first_function() call?

For operations within a single transaction, what counts is
CommandCounterIncrement not SetQuerySnapshot.

> I am runnging 7.4 btw.

I believe we changed the rules for this in 8.0 ... can you upgrade?

            regards, tom lane

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

Предыдущее
От: "Burak Seydioglu"
Дата:
Сообщение: Is setQuerySnapshot called for embedded plpgsql function calls?
Следующее
От: "Burak Seydioglu"
Дата:
Сообщение: Re: Is setQuerySnapshot called for embedded plpgsql function calls?