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 [EMAIL PROTECTED] ---------------------------(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