elein(at)varlena(dot)com (elein) writes:
> I tried to reproduce the case where 7.4 and 8.0 differ
> on the scope of volitile function with READ COMMITTED
> transactions.
> In an open transaction in read committed mode.
> Then I access the table and sum columns in a function.
> The results are always consistent between 7.4 and 8.0
> and can see committed insert transactions by another session
> while the first transaction is open.
What's your test case? 8.0 very definitely behaves differently from
prior releases --- try for instance Oliver Garcia's example:
http://archives.postgresql.org/pgsql-bugs/2002-02/msg00142.php
regards, tom lane