| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PATCHES] [pgsql-patches] Phantom Command IDs, updated patch |
| Date: | 2007-02-09 14:28:28 |
| Message-ID: | 24155.1171031308@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
"Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at> writes:
> So when a RI check locks a parent, you would not be able to update the
> parent in a later subtrans. I can imagine, that the error would be a
> problem in a select for update loop, because there you usually want to
> update the row.
No, it would not, because select for update would acquire exclusive lock
in the first place.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-02-09 14:30:23 | Re: pgsql: Add lock matrix to documentation. |
| Previous Message | Merlin Moncure | 2007-02-09 14:21:20 | Re: pgsql: Add lock matrix to documentation. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-02-09 14:32:10 | Re: [PATCHES] How can I use 2GB of shared buffers on Windows? |
| Previous Message | Mark Cave-Ayland | 2007-02-09 14:11:23 | Re: Hierarchical Queries--Status |