| From: | "Rasmus Resen Amossen" <rresena(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Broken RR? |
| Date: | 2003-06-05 00:48:04 |
| Message-ID: | Law14-F10174QXqoHiY00039d95@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-06-05 01:45:22 | Re: Nulls get converted to 0 problem |
| Previous Message | Bruno Wolff III | 2003-06-04 23:11:18 | Re: Nulls get converted to 0 problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-06-05 01:22:47 | Re: Aggregates containing outer references don't work per |
| Previous Message | Bruce Momjian | 2003-06-04 21:51:34 | Re: default locale considered harmful? (was Re: [GENERAL] |