Avoid collisions of normalized values going into metabib.browse_entry user/senator/reingest-avoid-collision-better
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Mon, 14 May 2012 16:46:44 +0000 (12:46 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Mon, 14 May 2012 16:46:44 +0000 (12:46 -0400)
commitb92ac4e0958753fb17e8f0f4cd209623cc82dd16
tree22cae72051c53f70b2c983862fec5f1aca665990
parenta4561f581eb54c088afb95d8758dd849d6f3d69e
Avoid collisions of normalized values going into metabib.browse_entry

This fixes a bug that prevents successful reingestion of bib records in
some cases.  Reported by George Duimovich.  Key part here:

> ERROR: duplicate key value violates unique constraint
> "browse_entry_value_key"
> DETAIL: Key (value)=(545575) already exists.
> CONTEXT: SQL statement "INSERT INTO metabib.browse_entry (value) VALUES
>                     (metabib.browse_normalize(ind_data.value,

Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reingest_avoid_collision_better.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql