]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/XXXX.data.bibcn_index_normalizers.sql
The identifier|bibcn field is best served by having no normalizers applied
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.data.bibcn_index_normalizers.sql
1 BEGIN;
2
3 -- check whether patch can be applied
4 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5
6 DELETE FROM config.metabib_field_index_norm_map
7     WHERE field = 25 AND norm IN (
8         SELECT id
9         FROM config.index_normalizer
10         WHERE func IN ('search_normalize','split_date_range')
11     );
12
13 \qecho If your site's bibcn searches are affected by this issue, you may wish
14 \qecho to reingest your bib records now.  It's probably not worth it for many
15 \qecho sites.
16
17 COMMIT;