From 786ce2cb611a6e8cb6377b29b65cf667d2246b15 Mon Sep 17 00:00:00 2001 From: Yamil Suarez Date: Wed, 2 Sep 2015 11:20:23 -0400 Subject: [PATCH] LP# 1484281 auth control config update release notes Signed-off-by: Yamil Suarez --- ...e_note_prevent_authority_propagation_delete.txt | 33 ++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 docs/RELEASE_NOTES_NEXT/Cataloging/upgrade_note_prevent_authority_propagation_delete.txt diff --git a/docs/RELEASE_NOTES_NEXT/Cataloging/upgrade_note_prevent_authority_propagation_delete.txt b/docs/RELEASE_NOTES_NEXT/Cataloging/upgrade_note_prevent_authority_propagation_delete.txt new file mode 100644 index 0000000000..247e7cf549 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Cataloging/upgrade_note_prevent_authority_propagation_delete.txt @@ -0,0 +1,33 @@ +Preventing improper authority data deletion from subfield $e +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ + +This release contains a fix for LP bug 1484281, "authority data may be deleted during propagation with current +values of authority.control_set_authority_field." + +For more details see: https://bugs.launchpad.net/evergreen/+bug/1484281 + +The related upgrade script from this release only removes subfield $e in authority tags 100 and 110, but only from the Evergreen +default "LoC" authority control set configuration. If your Evergreen system is set up with additional authority +control sets besides the default "LoC" one, you will need to run the following pieces of SQL code. + +First verify that you have an additional control set besides the default "LoC". Run the following SQL code +and write down the ID number for your additional control set. The number will be an integer like: 101 + +[source,sql] +-------------------------------------------------------------------- +select * +from authority.control_set +where name != 'LoC' +order by id +-------------------------------------------------------------------- + +In the following code you will need to change the two sections of "control_set = XYZ". Change the part labeled with the text "XYZ", with the ID number from the above query. +If the above query disolayed more than one additional authority control set, then you will need to run the code below once for each additional control set ID number. + +[source,sql] +-------------------------------------------------------------------- +UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_list, 'e', '', 'i') WHERE tag = '100' AND control_set = XYZ AND sf_list ILIKE '%e%'; + +UPDATE authority.control_set_authority_field SET sf_list = REGEXP_REPLACE( sf_list, 'e', '', 'i') WHERE tag = '110' AND control_set = XYZ AND sf_list ILIKE '%e%'; +-------------------------------------------------------------------- + -- 2.11.0