| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Rasmus Resen Amossen" <rresena(at)hotmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Broken RR? |
| Date: | 2003-06-05 05:26:04 |
| Message-ID: | 024601c32b22$f6124220$6500a8c0@fhp.internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-06-05 05:26:32 | Re: Anonymous CVS access |
| Previous Message | Tom Lane | 2003-06-05 04:10:13 | Re: Anonymous CVS access |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-06-05 05:26:32 | Re: Anonymous CVS access |
| Previous Message | Alvaro Herrera | 2003-06-05 05:25:37 | Re: default locale considered harmful? (was Re: [GENERAL] |