LP#1893463: Protect against null emails
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 1241.schema.reporter_schedule_uniqueness.sql
index 934aa76..6716658 100644 (file)
@@ -8,7 +8,7 @@ SET CONSTRAINTS ALL IMMEDIATE; -- to address "pending trigger events" error
 CREATE TABLE reporter.schedule_original (LIKE reporter.schedule);
 INSERT INTO reporter.schedule_original SELECT * FROM reporter.schedule;
 TRUNCATE reporter.schedule;
-INSERT INTO reporter.schedule (SELECT DISTINCT ON (report, folder, runner, run_time, email) id, report, folder, runner, run_time, start_time, complete_time, email, excel_format, html_format, csv_format, chart_pie, chart_bar, chart_line, error_code, error_text FROM reporter.schedule_original);
+INSERT INTO reporter.schedule (SELECT DISTINCT ON (report, folder, runner, run_time) id, report, folder, runner, run_time, start_time, complete_time, email, excel_format, html_format, csv_format, chart_pie, chart_bar, chart_line, error_code, error_text FROM reporter.schedule_original);
 \qecho NOTE: This has created a backup of the original reporter.schedule
 \qecho table, named reporter.schedule_original.  Once you are sure that everything
 \qecho works as expected, you can delete that table by issuing the following:
@@ -17,7 +17,7 @@ INSERT INTO reporter.schedule (SELECT DISTINCT ON (report, folder, runner, run_t
 \qecho
 
 -- Explicitly supply the name because it is referenced in clark-kent.pl
-CREATE UNIQUE INDEX rpt_sched_recurrence_once_idx ON reporter.schedule (report,folder,runner,run_time,email);
+CREATE UNIQUE INDEX rpt_sched_recurrence_once_idx ON reporter.schedule (report,folder,runner,run_time,COALESCE(email,''));
 
 COMMIT;