On 30/08/2011 9:18 PM, Jan Snelders wrote:
> The program now selects and prints the records from the SELECT
> transaction. (0 records printed, we expected one record since we are
> still within the SELECT transaction which started while this record was
> still available)
This isn't a bug. You're using READ COMMITTED mode, and you appear to
expect SERIALIZABLE mode. See:
http://www.postgresql.org/docs/current/interactive/transaction-iso.html
--
Craig Ringer