Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=# SELECT metabib.reingest_metabib_field_entries(
- postgres(# id, TRUE, FALSE, FALSE, TRUE,
- postgres(# (SELECT ARRAY_AGG(id) FROM config.metabib_field WHERE field_class='title' AND (browse_field OR facet_field OR display_field))
- postgres(# ) FROM biblio.record_entry;
- ERROR: relation "biblio.record_entry" does not exist
- LINE 4: ) FROM biblio.record_entry;
- ^
- postgres=# \q
- postgres@testdb:~$ psql -h testdb5 -d eg_test2 psql (10.23 (Debian 10.23-1.pgdg100+1))
- SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
- Type "help" for help.
- eg_test2=# SELECT metabib.reingest_metabib_field_entries(
- eg_test2(# id, TRUE, FALSE, FALSE, TRUE,
- eg_test2(# (SELECT ARRAY_AGG(id) FROM config.metabib_field WHERE field_class='title' AND (browse_field OR facet_field OR display_field))
- eg_test2(# ) FROM biblio.record_entry;
- ERROR: index row size 3136 exceeds maximum 2712 for index "browse_entry_sort_value_value_key"
- HINT: Values larger than 1/3 of a buffer page cannot be indexed.
- Consider a function index of an MD5 hash of the value, or use full text indexing.
- CONTEXT: SQL statement "INSERT INTO metabib.browse_entry
- ( value, sort_value ) VALUES
- ( value_prepped, ind_data.sort_value )
- ON CONFLICT (sort_value, value) DO UPDATE SET sort_value = EXCLUDED.sort_value -- must update a row to return an existing id
- RETURNING id"
- 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