1 files changed, 5 insertions, 1 deletions
diff --git a/db/migrate/20220712031923_create_vulnerability_reads_for_an_existing_vulnerability_record.rb b/db/migrate/20220712031923_create_vulnerability_reads_for_an_existing_vulnerability_record.rb
index 68769f9e4e3..f3c57692a0d 100644
--- a/db/migrate/20220712031923_create_vulnerability_reads_for_an_existing_vulnerability_record.rb
+++ b/db/migrate/20220712031923_create_vulnerability_reads_for_an_existing_vulnerability_record.rb
@@ -10,7 +10,7 @@ class CreateVulnerabilityReadsForAnExistingVulnerabilityRecord < Gitlab::Databas
 
   def up
     execute(<<~SQL)
-      CREATE FUNCTION #{FUNCTION_NAME}() RETURNS trigger
+      CREATE OR REPLACE FUNCTION #{FUNCTION_NAME}() RETURNS trigger
           LANGUAGE plpgsql
           AS $$
       DECLARE
@@ -39,6 +39,10 @@ class CreateVulnerabilityReadsForAnExistingVulnerabilityRecord < Gitlab::Databas
     SQL
 
     execute(<<~SQL)
+      DROP TRIGGER IF EXISTS #{TRIGGER_NAME} ON vulnerabilities;
+    SQL
+
+    execute(<<~SQL)
       CREATE TRIGGER #{TRIGGER_NAME}
       AFTER UPDATE ON vulnerabilities
       FOR EACH ROW