FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions

Поиск

Список

Период

Сортировка

От	Michael Paquier
Тема	FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
Дата	5 августа 2013 г. 10:20:45
Msg-id	CAB7nPqQvYaWiyoZAwFvFON_2o-GN58xO7qMJ4cdibjU_9_OQnA@mail.gmail.com обсуждение исходный текст
Ответы	Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
Список	pgsql-hackers

Дерево обсуждения

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