Horton

Re: Broken RR?

Mike Mascari <mascarm@mascari.com>

View thread
From: Mike Mascari <mascarm@mascari.com>
To: Rasmus Resen Amossen <rresena@hotmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2003-06-05T09:28:49Z
Lists: pgsql-hackers 
I wrote:

> Rasmus Resen Amossen wrote:
> 
> 
>>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)
> 
> 
> http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=transaction-iso.html#XACT-SERIALIZABLE

Whoops. Sorry. I though this was confusion regarding phantom rowsand
READ COMMITTED vs. SERIALIZABLE. Nevertheless, I cannot repeat the
above...

Mike Mascari
mascarm@mascari.com