Re: Postgresql ACID bug? - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: Postgresql ACID bug?
Date
Msg-id 4E5CF0C1.80604@ringerc.id.au
Whole thread Raw
In response to Postgresql ACID bug?  (Jan Snelders <jan@snelders.net>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgresql ACID bug?
Next
From: "Ding Yuan"
Date:
Subject: BUG #6184: Inconsistencies in log messages