Gregory Stark <[EMAIL PROTECTED]> writes: > I'm a bit puzzled myself why this affects SELECT FOR UPDATE/SHARE but not > straight UPDATES and DELETES.
In straight UPDATE/DELETE we have enough structure in the query to know how to associate each tuple returned to the executor top level with exactly one tuple in exactly one target table (which is where to apply the tuple lock operation). We don't have that much structure in general SELECT --- for example, what to do with null-filled rows in a LEFT JOIN, or cases where one row gives rise to more than one joined row, or aggregation or UNION? Some of these cases can probably be rejected as unsupportable, but it'll still take a lot of work. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster