elein@xxxxxxxxxxx (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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
