Re: Postgresql ACID bug?

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: pgsql-bugs(at)postgresql(dot)org, jan(at)snelders(dot)net
Subject: Re: Postgresql ACID bug?
Date: 2011-08-30 14:16:33
Message-ID: 4E5CF0C1.80604@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-08-30 14:20:16 Re: Postgresql ACID bug?
Previous Message Jan Snelders 2011-08-30 13:18:56 Postgresql ACID bug?