From 5ec73fa03414a59bd8516e571da6070b45e3b3ce Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 27 Oct 2022 20:38:28 -0400 Subject: [PATCH] LP1934162: (follow-up) sync whitespace This ensures that the text of the function is identical whether it was installed by database creation or by a DB update Signed-off-by: Galen Charlton --- .../src/sql/Pg/upgrade/xxxx.purge_messages_curbside_notes.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.purge_messages_curbside_notes.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.purge_messages_curbside_notes.sql index a14d1e7a1a..5684c5f832 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.purge_messages_curbside_notes.sql +++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.purge_messages_curbside_notes.sql @@ -27,7 +27,7 @@ BEGIN UPDATE acq.lineitem SET selector = dest_usr WHERE selector = src_usr; UPDATE acq.lineitem_note SET creator = dest_usr WHERE creator = src_usr; UPDATE acq.lineitem_note SET editor = dest_usr WHERE editor = src_usr; - UPDATE acq.invoice SET closed_by = dest_usr WHERE closed_by = src_usr; + UPDATE acq.invoice SET closed_by = dest_usr WHERE closed_by = src_usr; DELETE FROM acq.lineitem_usr_attr_definition WHERE usr = src_usr; -- Update with a rename to avoid collisions -- 2.43.2