Re: BUG #14450: inconsistent results on async slave

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14450: inconsistent results on async slave
Дата
Msg-id 26771.1481039057@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14450: inconsistent results on async slave  (rikard@ngs.hr)
Список pgsql-bugs
rikard@ngs.hr writes:
> Is this expected behavior?

You haven't provided nearly enough information to let anyone diagnose
this with certainty; but if the data is changing under you, then replacing
a volatile function with a stable one could certainly cause different
results, because the data visibility rules would be different.  See
https://www.postgresql.org/docs/9.3/static/xfunc-volatility.html
particularly the bit about volatile functions using a new snapshot
on each call.

            regards, tom lane

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