From be0604124ba4ce5da23da94656c39a5572f0076f Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 2 Nov 2020 14:18:46 -0500 Subject: [PATCH] SQL: drop the table after moving the data off --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql index 752c63cafd..ce06be5c35 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql @@ -9,5 +9,6 @@ create table actor.workstation_setting_temp (like actor.workstation_setting); insert into actor.workstation_setting_temp select * from actor.workstation_setting; truncate actor.workstation_setting; insert into actor.workstation_setting (select distinct on (workstation, name) id, workstation, name, value from actor.workstation_setting_temp); +drop table actor.workstation_setting_temp; commit; -- 2.11.0