Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: FOR UPDATE versus WITH --- change 8.4 too?
Date
Msg-id 12369.1256663645@sss.pgh.pa.us
Whole thread Raw
In response to Re: FOR UPDATE versus WITH --- change 8.4 too?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: FOR UPDATE versus WITH --- change 8.4 too?
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Parsing config files in a directory
Next
From: Greg Smith
Date:
Subject: Re: Parsing config files in a directory