Обсуждение: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
От
Michael Paquier
Дата:
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.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
Regards,
--
Michael
Michael
Вложения
Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
От
Bruce Momjian
Дата:
On Mon, Aug 5, 2013 at 04:20:40PM +0900, Michael Paquier wrote: > 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, Patch applied. Thanks. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
От
Michael Paquier
Дата:
On Sat, Feb 1, 2014 at 6:37 AM, Bruce Momjian <bruce@momjian.us> wrote: > On Mon, Aug 5, 2013 at 04:20:40PM +0900, Michael Paquier wrote: >> 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, > > Patch applied. Thanks. Thanks. -- Michael