Horton

Re: Broken RR?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Rasmus Resen Amossen" <rresena@hotmail.com>, <pgsql-hackers@postgresql.org>
Date: 2003-06-05T05:26:04Z
Lists: pgsql-hackers 
> 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)

You'll need to SELECT ... FOR UPDATE to lock the row, or use the
SERIALIZABLE transaction more I think...

Chris