| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: FOR UPDATE/SHARE incompatibility with GROUP BY, DISTINCT, HAVING and window functions |
| Date: | 2014-01-31 21:37:41 |
| Message-ID: | 20140131213741.GS19957@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-01-31 21:38:21 | Re: [HACKERS] Insert result does not match record count |
| Previous Message | Bruce Momjian | 2014-01-31 21:28:08 | Re: FOR [SHARE|UPDATE] NOWAIT may still block in EvalPlanQualFetch |