Re: BUG #1231: Probelm with transactions in stored code.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1231: Probelm with transactions in stored code.
Дата
Msg-id 11422.1093488391@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1231: Probelm with transactions in stored code.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: BUG #1231: Probelm with transactions in stored code.
Список pgsql-bugs
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> I believe it sees the one that was valid in the snapshot as of the
> beginning of the function.

Actually, the problem is that it can see *both* that row and the updated
row; it's a crapshoot which one will be returned by the SELECT INTO.

The reason this can happen is that we're not doing SetQuerySnapshot
between commands of a plpgsql function.  There is discussion going way
way back about whether we shouldn't do so (see the archives).  I think
the major reason why we have not done it is fear of introducing
non-backwards-compatible behavior.  Seems like 8.0 is exactly the right
version to consider doing that in.

            regards, tom lane

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