Add oid column to lfs_objects_projects
What does this MR do and why?
Add oid column to lfs_objects_projects
Database
Up
main: == 20250528182757 AddOidToLfsObjectsProjects: migrating =======================
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- add_column(:lfs_objects_projects, :oid, :text, {:if_not_exists=>true})
main: -> 0.0033s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE lfs_objects_projects\nADD CONSTRAINT check_76ef4585ad\nCHECK ( char_length(oid) <= 255 )\nNOT VALID;\n")
main: -> 0.0009s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- execute("ALTER TABLE lfs_objects_projects VALIDATE CONSTRAINT check_76ef4585ad;")
main: -> 0.0007s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20250528182757 AddOidToLfsObjectsProjects: migrated (0.0179s) ==============
main: == 20250529171043 AddIndexOfOidToLfsObjectsProjects: migrating ================
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0004s
main: -- index_exists?(:lfs_objects_projects, :oid, {:name=>"index_lfs_objects_projects_on_oid", :algorithm=>:concurrently})
main: -> 0.0023s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- add_index(:lfs_objects_projects, :oid, {:name=>"index_lfs_objects_projects_on_oid", :algorithm=>:concurrently})
main: -> 0.0031s
main: -- execute("RESET statement_timeout")
main: -> 0.0003s
main: == 20250529171043 AddIndexOfOidToLfsObjectsProjects: migrated (0.0193s) =======
Down
main: == [advisory_lock_connection] object_id: 136240, pg_backend_pid: 78117
main: == 20250528182757 AddOidToLfsObjectsProjects: reverting =======================
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- remove_column(:lfs_objects_projects, :oid, {:if_exists=>true})
main: -> 0.0260s
main: == 20250528182757 AddOidToLfsObjectsProjects: reverted (0.0617s) ==============
main: == 20250529171043 AddIndexOfOidToLfsObjectsProjects: reverting ================
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main: -> 0.0214s
main: -- index_exists?(:lfs_objects_projects, :oid, {:name=>"index_lfs_objects_projects_on_oid", :algorithm=>:concurrently})
main: -> 0.0039s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0005s
main: -- remove_index(:lfs_objects_projects, {:name=>"index_lfs_objects_projects_on_oid", :algorithm=>:concurrently, :column=>:oid})
main: -> 0.0048s
main: -- execute("RESET statement_timeout")
main: -> 0.0011s
main: == 20250529171043 AddIndexOfOidToLfsObjectsProjects: reverted (0.0530s) =======
Related to #546232 (closed) #546677 (closed)
Edited by Kerri Miller