19993: Fix postgresql<12 incompatibility.

Arvados-DCO-1.1-Signed-off-by: Tom Clegg <tom@curii.com>

diff --git a/services/api/db/migrate/20221219165512_dedup_permission_links.rb b/services/api/db/migrate/20221219165512_dedup_permission_links.rb
index 6b2d923d868572d6e1554b3d94a575731bd19df5..ec9ea591d45c22d23e730fabe40db79519d757cf 100644 (file)
--- a/services/api/db/migrate/20221219165512_dedup_permission_links.rb
+++ b/services/api/db/migrate/20221219165512_dedup_permission_links.rb
@@ -12,8 +12,7 @@ class DedupPermissionLinks < ActiveRecord::Migration[5.2]
          AND link_class = 'permission'
          AND name in ('can_read', 'can_write', 'can_manage')
         GROUP BY (tail_uuid, head_uuid)
-        HAVING COUNT(uuid) > 1
-        FOR UPDATE")
+        HAVING COUNT(uuid) > 1")
       rows.each do |row|
         Rails.logger.debug "DedupPermissionLinks: consolidating #{row['n']} links into #{row['uuid']}"
         link = Link.find_by_uuid(row['uuid'])
@@ -29,8 +28,7 @@ class DedupPermissionLinks < ActiveRecord::Migration[5.2]
          AND link_class = 'permission'
          AND name = 'can_login'
         GROUP BY (tail_uuid, head_uuid, properties)
-        HAVING COUNT(uuid) > 1
-        FOR UPDATE")
+        HAVING COUNT(uuid) > 1")
       rows.each do |row|
         Rails.logger.debug "DedupPermissionLinks: consolidating #{row['n']} links into #{row['uuid']}"
         link = Link.find_by_uuid(row['uuid'])