1 Fixes to patron name/username search indexes
2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
3 When using pg_restore to restore an Evergreen database, some of the
4 indexes used to speed up patron searches on names and usernames
7 This release fixes the underlying issue and re-creates the indexes
12 When using pg_restore to restore an affected database, the
13 "unaccent" indexes on actor.usr would not be created due to an
14 unqualified function reference in evergreen.unaccent_and_squash.
16 The function will be replaced to resolve the search path issue,
17 and the following indexes on actor.usr will be dropped and then
20 * actor_usr_first_given_name_unaccent_idx;
21 * actor_usr_second_given_name_unaccent_idx;
22 * actor_usr_family_name_unaccent_idx;
23 * actor_usr_usrname_unaccent_idx;
25 This will be done even if the indexes are already present, and may
26 take a few minutes on a database with many patrons.