Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
- index 481f831344..a58d8b5efb 100644
- --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql
- +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
- @@ -1135,7 +1135,7 @@ BEGIN
- INSERT INTO metabib.browse_entry
- ( value, sort_value ) VALUES
- ( value_prepped, ind_data.sort_value )
- - ON CONFLICT (sort_value, value) DO UPDATE SET id = EXCLUDED.id -- must update a row to return an existing id
- + ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
- RETURNING id INTO mbe_id;
- END IF;
- diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql
- index 4dd12bd353..13abd49d35 100644
- --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql
- +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql
- @@ -1041,7 +1041,7 @@ BEGIN
- INSERT INTO metabib.browse_entry
- ( value, sort_value ) VALUES
- ( value_prepped, ind_data.sort_value )
- - ON CONFLICT (sort_value, value) DO UPDATE SET id = EXCLUDED.id -- must update a row to return an existing id
- + ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
- RETURNING id INTO mbe_id;
- END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement