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 sli

[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&quo