Merge remote-tracking branch 'upstream/pull/4483'

[rails.git] / db / migrate / 20231010194809_correct_relation_members_primary_key.rb

diff --git a/db/migrate/20231010194809_correct_relation_members_primary_key.rb b/db/migrate/20231010194809_correct_relation_members_primary_key.rb
index 09870836ff21112558998ca3fc1ec7ed48f9913f..84388063e330699162e321d98fe8f75d4890d79a 100644 (file)
--- a/db/migrate/20231010194809_correct_relation_members_primary_key.rb
+++ b/db/migrate/20231010194809_correct_relation_members_primary_key.rb
@@ -1,11 +1,13 @@
 class CorrectRelationMembersPrimaryKey < ActiveRecord::Migration[7.0]
+  disable_ddl_transaction!
+
   def up
-    alter_primary_key :current_relation_members, [:relation_id, :sequence_id]
-    alter_primary_key :relation_members, [:relation_id, :version, :sequence_id]
+    alter_primary_key :current_relation_members, [:relation_id, :sequence_id], :algorithm => :concurrently
+    alter_primary_key :relation_members, [:relation_id, :version, :sequence_id], :algorithm => :concurrently
   end
 
   def down
-    alter_primary_key :relation_members, [:relation_id, :version, :member_type, :member_id, :member_role, :sequence_id]
-    alter_primary_key :current_relation_members, [:relation_id, :member_type, :member_id, :member_role, :sequence_id]
+    alter_primary_key :relation_members, [:relation_id, :version, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
+    alter_primary_key :current_relation_members, [:relation_id, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
   end
 end