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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
Дата
Msg-id 20140131213741.GS19957@momjian.us
обсуждение исходный текст
Ответ на FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions
Список pgsql-hackers
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. +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: FOR [SHARE|UPDATE] NOWAIT may still block in EvalPlanQualFetch
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: mvcc catalo gsnapshots and TopTransactionContext