From 8ee82281557089082d76b9508ade0d716804fe39 Mon Sep 17 00:00:00 2001 From: Jeff Godin Date: Tue, 7 Nov 2017 16:29:03 -0500 Subject: [PATCH] LP#1671150 Document unaccented name index fix Release notes for evergreen.unaccent_and_squash function (and dependent indexes) fix. Signed-off-by: Jeff Godin Signed-off-by: Jason Stephenson --- .../patron_name_username_index_fixes.adoc | 27 +++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 docs/RELEASE_NOTES_NEXT/patron_name_username_index_fixes.adoc diff --git a/docs/RELEASE_NOTES_NEXT/patron_name_username_index_fixes.adoc b/docs/RELEASE_NOTES_NEXT/patron_name_username_index_fixes.adoc new file mode 100644 index 0000000000..0657a05df0 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/patron_name_username_index_fixes.adoc @@ -0,0 +1,27 @@ +Fixes to patron name/username search indexes +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ +When using pg_restore to restore an Evergreen database, some of the +indexes used to speed up patron searches on names and usernames +could be lost. + +This release fixes the underlying issue and re-creates the indexes +in question. + +Details ++++++++ +When using pg_restore to restore an affected database, the +"unaccent" indexes on actor.usr would not be created due to an +unqualified function reference in evergreen.unaccent_and_squash. + +The function will be replaced to resolve the search path issue, +and the following indexes on actor.usr will be dropped and then +re-created: + + * actor_usr_first_given_name_unaccent_idx; + * actor_usr_second_given_name_unaccent_idx; + * actor_usr_family_name_unaccent_idx; + * actor_usr_usrname_unaccent_idx; + +This will be done even if the indexes are already present, and may +take a few minutes on a database with many patrons. + -- 2.43.2