From 420285efbf8fd3032107218ab222d1bb6ab0db02 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sat, 8 Jan 2022 21:33:32 -0500 Subject: [PATCH] check for column existence while dropping --- Open-ILS/src/sql/Pg/version-upgrade/student_card_updates.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/student_card_updates.sql b/Open-ILS/src/sql/Pg/version-upgrade/student_card_updates.sql index 7315a5a61a..2b168c4e99 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/student_card_updates.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/student_card_updates.sql @@ -1,11 +1,11 @@ begin; -- drop now unused columns -alter table student_card.district drop column ftp_host cascade; -alter table student_card.district drop column ftp_user cascade; -alter table student_card.district drop column ftp_pass cascade; -alter table student_card.district drop column ftp_remote_dir cascade; -alter table student_card.district drop column ftp_port cascade; +alter table student_card.district drop column if exists ftp_host cascade; +alter table student_card.district drop column if exists ftp_user cascade; +alter table student_card.district drop column if exists ftp_pass cascade; +alter table student_card.district drop column if exists ftp_remote_dir cascade; +alter table student_card.district drop column if exists ftp_port cascade; -- add new columns alter table student_card.district add column file_dir text; -- 2.11.0