| From: | Mike Mascari <mascarm(at)mascari(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 09:28:49 |
| Message-ID: | 3EDF0D51.7050904@mascari.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
mascarm(at)mascari(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-06-05 12:03:30 | Re: regular expression question |
| Previous Message | Mike Mascari | 2003-06-05 09:22:22 | Re: Broken RR? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-06-05 13:38:43 | large objects |
| Previous Message | Mike Mascari | 2003-06-05 09:22:22 | Re: Broken RR? |