LP#1125270: Add a DROP FUNCTION for actor.usr_purge_data
authorBen Shum <bshum@biblio.org>
Tue, 3 Mar 2015 02:49:55 +0000 (21:49 -0500)
committerGalen Charlton <gmc@esilibrary.com>
Sat, 16 May 2015 00:38:45 +0000 (00:38 +0000)
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 <bshum@biblio.org>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql

index 3638766..219da6b 100644 (file)
@@ -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,