1 Fix for Authority Records with Long Subfields
2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
3 Importing or updating authority records with long subfields, i.e. in
4 the vicinity of 5,000 characters or more in length, can cause database
5 errors that will prevent the update or import from happening. The
6 error occurs because non-full text indexes in PostgreSQL have a
7 limited length, and long fields sometimes lead to index entries that
8 exceed this maximum value.
10 In order to rectify this issue, two database indexes on the
11 `authority.full_rec` table's `value` column have been redefined to
12 match their counterparts in the `metabib.real_full_rec` table. After
13 this update, only the first 1024 characters of an authority field or
14 subfield will be considered by these indexes.
16 NOTE: These indexes are not used for authority record search, though
17 they are used for sorting and paging.