From 53bb5c810d7ed85412646d1d7439c86431f6402e Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 2 Mar 2015 21:49:55 -0500 Subject: [PATCH] LP#1125270: Add a DROP FUNCTION for actor.usr_purge_data Apparently this caused problems on upgrading from 2.0 to 2.1 back in the day, and adding a DROP FUNCTION ahead of the CREATE dealt with the situation. Signed-off-by: Ben Shum Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql index 3638766491..219da6bedf 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql @@ -310,6 +310,8 @@ INSERT INTO config.hold_matrix_weights(name, user_home_ou, request_ou, pickup_ou INSERT INTO config.weight_assoc(active, org_unit, circ_weights, hold_weights) VALUES (true, 1, 1, 1); +-- LP1125270 +DROP FUNCTION IF EXISTS actor.usr_purge_data(INT, INT); -- 0480 CREATE OR REPLACE FUNCTION actor.usr_purge_data( src_usr IN INTEGER, -- 2.43.2