To speed up reingest, we might want to just use the evergreen.xml_famous5_to_text() function directly. As an attempted first-pass, at least, we could do something like:
=# UPDATE metabib.browse_entry SET value=evergreen.xml_famous5_to_text(value) WHERE value LIKE '%&%;
This has the potential to fail if the decoded version of the string was saved previous to this problem existing, but in that case the slower browse-only reingest could be run instead.
To speed up reingest, we might want to just use the evergreen. xml_famous5_ to_text( ) function directly. As an attempted first-pass, at least, we could do something like:
=# UPDATE metabib. browse_ entry SET value=evergreen .xml_famous5_ to_text( value) WHERE value LIKE '%&%;
This has the potential to fail if the decoded version of the string was saved previous to this problem existing, but in that case the slower browse-only reingest could be run instead.