On Mon, 2009-01-12 at 12:47 -0500, Robert Haas wrote: > If the only case where ORDER BY + FOR UPDATE are not strictly > compatible is when the columns being updated are the same as the > columns of the sort, a blanket prohibition against using the two > together seems like it prohibits an awful lot of useful things someone > might want to do.
As long as the people using it are aware that they can't update the ordering columns, it may make sense to leave that functionality in there. Can you expand on "an awful lot of useful things"? It seems like an edge case to me, and the restriction it imposes is quite awkward to meet. "OK, nobody ever update these fields in this table.". Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers