From fbd224d55ed1c01e32a6cbc584fd62deecb13918 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 2 Nov 2020 14:17:41 -0500 Subject: [PATCH] SQL: typo correction --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.6-upgrade.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 267f97f7a9..752c63cafd 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 @@ -5,7 +5,7 @@ begin; -- GROUP BY 2, 3 HAVING COUNT(*) > 1; -- we need to dedupe our workstation settings to prepare for the new index -create table actor.workstation_setting_temp like actor.workstation_setting; +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); -- 2.11.0