On Tue, Oct 27, 2009 at 1:14 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)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