Re: FOR UPDATE versus WITH --- change 8.4 too?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FOR UPDATE versus WITH --- change 8.4 too?
Date: 2009-10-27 17:14:05
Message-ID: 12369.1256663645@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2009-10-27 17:14:43 Re: Parsing config files in a directory
Previous Message Greg Smith 2009-10-27 17:06:55 Re: Parsing config files in a directory