]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1415572: ensure correct version of authority.normalize_heading() is in place
authorGalen Charlton <gmc@esilibrary.com>
Wed, 28 Jan 2015 17:24:02 +0000 (17:24 +0000)
committerBen Shum <bshum@biblio.org>
Tue, 3 Feb 2015 21:02:24 +0000 (16:02 -0500)
commite99fa24c328671f45f8a5050a57d46dc54bff483
tree4b5cb0372f9e48f71cb8e7e99858f662fe36dc56
parent0ea16a6aa8ab09919071de9cbbda0a2073e92507
LP#1415572: ensure correct version of authority.normalize_heading() is in place

Some upgraded Evergreen databases can have the wrong version
of the authority.normalize_heading() function in place because
of a mixup in the 0848 schema upgrade script.  The problem can
manifest itself by there being rows in authority.record_entry
where the heading and simple_heading columns have "NOHEADING"
values regardless of the control set:

-[ RECORD 1 ]--+---------------------------------------------
heading | NOHEADING_a ff0ed9fcd13e8944d9a718650840787a
simple_heading | NOHEADING_a ff0ed9fcd13e8944d9a718650840787a

This patch ensures that the correct version is in place and
updates authority.record_entry to fix up affected rows without
requiring a full authority ingest.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.use_current_normalize_heading.sql [new file with mode: 0644]