Project

General

Profile

Bug #19993

Updated by Peter Amstutz about 1 year 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. 

 Ubuntu 18.04 has postgresql 10.22-0ubuntu0.18.04.1 


Back