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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
