Broken RR? - Mailing list pgsql-hackers

From Rasmus Resen Amossen
Subject Broken RR?
Date
Msg-id Law14-F10174QXqoHiY00039d95@hotmail.com
Whole thread Raw
Responses Re: Broken RR?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Broken RR?  (Mike Mascari <mascarm@mascari.com>)
Re: Broken RR?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-hackers
Does Postgres garantee repeatable-read (RR) during transactions? And does it 
implement ARIES/KVL?

If so, why is the following possible?

T1: begin;
T1: select * from table;  (notice the row with id = X)
T2: begin;
T2: delete from table where id = X;
T1: select * from table;  (notice the row with id = X suddenly is gone)

_________________________________________________________________
Tag MSN Hotmail med dig p� mobilen http://www.msn.dk/mobile



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Aggregates containing outer references don't work per
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: default locale considered harmful? (was Re: [GENERAL]