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

Mike Mascari

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to