Re: example for read committed/volitile functions - Mailing list pgsql-general

From Tom Lane
Subject Re: example for read committed/volitile functions
Date
Msg-id 2423.1107125163@sss.pgh.pa.us
Whole thread Raw
In response to example for read committed/volitile functions  (elein@varlena.com (elein))
Responses Re: example for read committed/volitile functions  (elein@varlena.com (elein))
List pgsql-general
elein@varlena.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

pgsql-general by date:

Previous
From: elein@varlena.com (elein)
Date:
Subject: example for read committed/volitile functions
Next
From: Greg Stark
Date:
Subject: Re: [pgsql-advocacy] MySQL worm attacks Windows servers