Re: BUG #14450: inconsistent results on async slave - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14450: inconsistent results on async slave
Date
Msg-id 26771.1481039057@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14450: inconsistent results on async slave  (rikard@ngs.hr)
List 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 by date:

Previous
From: tim.klicks@gmail.com
Date:
Subject: BUG #14451: PostgreSQL server on iscsi disks
Next
From: Tom Lane
Date:
Subject: Re: BUG #14451: PostgreSQL server on iscsi disks