Advertisement
chrissharp123

Untitled

Jan 8th, 2020
423
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. 2020-01-08 00:18:21 brick05-head open-ils.cstore: [ERR :72530:oils_sql.c:5898:15784605447240195] open-ils.cstore: Error with query [SELECT * FROM unapi.metabib_virtual_record_feed( '{2361339}', 'marcxml', '{holdings_xml,mra,mmr.unapi}', 'PINES', '0', 'acn=>5,acp=>5,bre=>5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ) AS "unapi.metabib_virtual_record_feed" ;]: 466560 466560: ERROR: set-returning functions are not allowed in COALESCE#012LINE 11: WITH aou AS (SELECT COALESCE(id, (evergreen....#012 ^#012HINT: You might be able to move the set-returning function into a LATERAL FROM item.#012QUERY: #012 SELECT XMLELEMENT(#012 name attributes,#012 XMLATTRIBUTES(#012 CASE WHEN $9 THEN 'http://open-ils.org/spec/indexing/v1' ELSE NULL END AS xmlns,#012 'tag:open-ils.org:U2@mmr/' || $1 AS metarecord#012 ),#012 (SELECT XMLAGG(foo.y)#012 FROM (#012 WITH sourcelist AS (#012 WITH aou AS (SELECT COALESCE(id, (evergreen.org_top()).id) AS id FROM actor.org_unit WHERE shortname = $5 LIMIT 1),#012 basevm AS (SELECT c_attrs FROM asset.patron_default_visibility_mask()),#012 circvm AS (SELECT search.calculate_visibility_attribute_test('circ_lib', ARRAY_AGG(aoud.id)) AS mask#012 FROM aou, LATERAL actor.org_unit_descendants(aou.id, $6) aoud)#012 SELECT source#012 FROM aou, circvm, basevm, metabib.metarecord_source_map mmsm#012 WHERE mmsm.metarecord = $1 AND (#012 EXISTS (#012 ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement