From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Rasmus Resen Amossen <rresena(at)hotmail(dot)com> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Broken RR? |
Date: | 2003-06-05 05:49:57 |
Message-ID: | 20030604224102.O91428-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Thu, 5 Jun 2003, 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)
I can't reproduce the above. Are you sure T2 isn't committing? If it
were, since the default isolation level is read committed, T1 would be
allowed to see the state after T2 has committed. It isn't allowed to in
serializable isolation (or in repeatable read, but afaik we only support
read committed and serializable currently).
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2003-06-05 05:52:24 | Re: SAP and MySQL ... |
Previous Message | Coby Beck | 2003-06-05 05:35:33 | create or replace for aggregate function |
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Jürgen Schönig | 2003-06-05 05:52:24 | Re: SAP and MySQL ... |
Previous Message | Alvaro Herrera | 2003-06-05 05:26:32 | Re: Anonymous CVS access |