Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-30 Thread Steve Caligo
> On Thu, Jul 16, 2009 at 12:34 PM, Steve Caligo > wrote: >> 2) FIRST TRY, USING "UPDATE WHERE ID = ( SELECT )" >> The goal is to have two clients set their unique ID to a >> single/different >> row from the table. First, using "limit" in a slightly different way: > This is pretty clearly NOT the

Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-30 Thread Robert Haas
On Thu, Jul 30, 2009 at 1:40 AM, Steve Caligo wrote: > Allowing FOR UPDATE in sub-queries has been rejected in this same thread, > you've also mentioned it your previous reply. > http://archives.postgresql.org/pgsql-bugs/2004-10/msg00150.php Um, I didn't write that email. That was Tom Lane. >> T

Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-29 Thread Robert Haas
On Thu, Jul 16, 2009 at 12:34 PM, Steve Caligo wrote: > > The following bug has been logged online: > > Bug reference:      4925 > Logged by:          Steve Caligo > Email address:      steve.cal...@ctie.etat.lu > PostgreSQL version: 8.3.7 and 8.4.0 > Operating system:   Archlinux and Gentoo 8.3.7,

[BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-16 Thread Steve Caligo
The following bug has been logged online: Bug reference: 4925 Logged by: Steve Caligo Email address: steve.cal...@ctie.etat.lu PostgreSQL version: 8.3.7 and 8.4.0 Operating system: Archlinux and Gentoo 8.3.7, Gentoo 8.4.0 Description:"select ... for update" doesn't af