Re: FOR UPDATE versus WITH --- change 8.4 too? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: FOR UPDATE versus WITH --- change 8.4 too?
Date
Msg-id 603c8f070910271045w24457b35w97706f0d039aa3cf@mail.gmail.com
Whole thread Raw
In response to Re: FOR UPDATE versus WITH --- change 8.4 too?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Oct 27, 2009 at 1:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> If it doesn't have any effect anyway, what's the virtue of back-patching it?
>
> Because 8.4 just fails in cases where we can easily allow it to work
> according to the new definition.  Right now, if you want to use FOR
> UPDATE in a query that has WITHs, you have to carefully write
> FOR UPDATE OF x,y,z,... for all the non-WITH relations.

Oh, I see.  Well, that seems like it makes sense to me, then.

...Robert


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Delete cascade with three levels bug ?
Next
From: Robert Haas
Date:
Subject: Re: Endgame for all those SELECT FOR UPDATE changes: fix plan node order