Guest User

Untitled

a guest
Jul 19th, 2023
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. postgres=# SELECT metabib.reingest_metabib_field_entries(
  2. postgres(# id, TRUE, FALSE, FALSE, TRUE,
  3. postgres(# (SELECT ARRAY_AGG(id) FROM config.metabib_field WHERE field_class='title' AND (browse_field OR facet_field OR display_field))
  4. postgres(# ) FROM biblio.record_entry;
  5. ERROR: relation "biblio.record_entry" does not exist
  6. LINE 4: ) FROM biblio.record_entry;
  7. ^
  8. postgres=# \q
  9. postgres@testdb:~$ psql -h testdb5 -d eg_test2 psql (10.23 (Debian 10.23-1.pgdg100+1))
  10. SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
  11. Type "help" for help.
  12.  
  13. eg_test2=# SELECT metabib.reingest_metabib_field_entries(
  14. eg_test2(# id, TRUE, FALSE, FALSE, TRUE,
  15. eg_test2(# (SELECT ARRAY_AGG(id) FROM config.metabib_field WHERE field_class='title' AND (browse_field OR facet_field OR display_field))
  16. eg_test2(# ) FROM biblio.record_entry;
  17.  
  18. ERROR: index row size 3136 exceeds maximum 2712 for index "browse_entry_sort_value_value_key"
  19. HINT: Values larger than 1/3 of a buffer page cannot be indexed.
  20. Consider a function index of an MD5 hash of the value, or use full text indexing.
  21. CONTEXT: SQL statement "INSERT INTO metabib.browse_entry
  22. ( value, sort_value ) VALUES
  23. ( value_prepped, ind_data.sort_value )
  24. ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
  25. RETURNING id"
  26. PL/pgSQL function metabib.reingest_metabib_field_entries(bigint,boolean,boolean,boolean,boolean,integer[]) line 88 at SQL statement
Advertisement
Add Comment
Please, Sign In to add comment