Postgres Pro
Downloads
Home   >   mailing lists

FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions - Mailing list pgsql-hackers

From Michael Paquier
Subject FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
Date
Msg-id CAB7nPqQvYaWiyoZAwFvFON_2o-GN58xO7qMJ4cdibjU_9_OQnA@mail.gmail.com
Whole thread Raw
Responses Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view
Hi all,

By having a look at the documentation of SELECT, it is not specified that FOR SHARE/UPDATE and friends are incompatible with the clauses in $subject
http://www.postgresql.org/docs/9.2/static/sql-select.html
This restriction is explicitly cited for INTERSECT and UNION though, so people can get easily confused IMHO for the other clauses.

Does it make sense to mention in the documentation those limitations like in the patch attached? If yes, perhaps this should be back-patched, after removing the part about FOR NO KEY UPDATE and FOR KEY SHARE of course from the patch attached for 9.2 and prior versions...
Regards,
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: query_planner() API change
Next
From: "Etsuro Fujita"
Date:
Subject: Re: query_planner() API change