Advertisement
Guest User

Untitled

a guest
Oct 27th, 2022
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
  2. index 481f831344..a58d8b5efb 100644
  3. --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql
  4. +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
  5. @@ -1135,7 +1135,7 @@ BEGIN
  6. INSERT INTO metabib.browse_entry
  7. ( value, sort_value ) VALUES
  8. ( value_prepped, ind_data.sort_value )
  9. - ON CONFLICT (sort_value, value) DO UPDATE SET id = EXCLUDED.id -- must update a row to return an existing id
  10. + ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
  11. RETURNING id INTO mbe_id;
  12. END IF;
  13.  
  14. 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
  15. index 4dd12bd353..13abd49d35 100644
  16. --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql
  17. +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.queued_ingest.sql
  18. @@ -1041,7 +1041,7 @@ BEGIN
  19. INSERT INTO metabib.browse_entry
  20. ( value, sort_value ) VALUES
  21. ( value_prepped, ind_data.sort_value )
  22. - ON CONFLICT (sort_value, value) DO UPDATE SET id = EXCLUDED.id -- must update a row to return an existing id
  23. + ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
  24. RETURNING id INTO mbe_id;
  25. END IF;
  26.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement