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

2014-01-31 Thread 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

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

2014-01-31 Thread Michael Paquier
On Sat, Feb 1, 2014 at 6:37 AM, Bruce Momjian br...@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

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

2013-08-05 Thread 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