Bug #19993
Updated by Peter Amstutz almost 2 years ago
<pre>
2023-01-26_21:08:14.29202 ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: FOR UPDATE is not allowed with GROUP BY clause
2023-01-26_21:08:14.29202 : SELECT MIN(uuid) AS uuid, COUNT(uuid) AS n FROM links
2023-01-26_21:08:14.29202 WHERE tail_uuid IS NOT NULL
2023-01-26_21:08:14.29203 AND head_uuid IS NOT NULL
2023-01-26_21:08:14.29203 AND link_class = 'permission'
2023-01-26_21:08:14.29203 AND name in ('can_read', 'can_write', 'can_manage')
2023-01-26_21:08:14.29204 GROUP BY (tail_uuid, head_uuid)
2023-01-26_21:08:14.29204 HAVING COUNT(uuid) > 1
2023-01-26_21:08:14.29204 FOR UPDATE
</pre>
This is with Debian postgresql 11+200+deb10u5, which is the default version on Debian 10.