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


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to