From 84b19c08a3f917907f32a79ca0544c1a20356397 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 18 Feb 2019 12:57:48 -0500 Subject: [PATCH] LP#1812733: put in correct version of actor.usr_delete() This fixes an issue in the previous patch where second_given_name would never have been NULLed. Signed-off-by: Galen Charlton --- .../Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql index 0350dd483e..aaf5c79c09 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql @@ -87,10 +87,11 @@ BEGIN photo_url = NULL, prefix = NULL, first_given_name = new_name, - guardian = NULL, + second_given_name = NULL, family_name = new_name, suffix = NULL, alias = NULL, + guardian = NULL, day_phone = NULL, evening_phone = NULL, other_phone = NULL, -- 2.43.2