Hmm, what's oils_xpath_tag_to_table ? Cause it's referenced in the changes for the vandelay function, but I can't find it anywhere in our current schemas.
So I got errors like this showing up in my logs where my system can't find that function:
open-ils.cstore 2015-08-18 21:05:40 [ERR :54272:oils_sql.c:2486:14399364235426638] open-ils.cstore ERROR inserting vandelay::queued_bib_record object using query
LINE 2: FROM oils_xpath_tag_to_table( (SELECT mar... ^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT * FROM oils_xpath_tag_to_table( (SELECT marc FROM vandelay.queued_bib_record WHERE id = import_id), attr_def.tag, xpaths) AS t( ol TEXT, clib TEXT, cn TEXT, cnum TEXT, cs TEXT, cl TEXT, circ TEXT, dep TEXT, dep_amount TEXT, r TEXT, hold TEXT, pr TEXT, bc TEXT, circ_mod TEXT, circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id TEXT, stat_cat_data TEXT, opac_vis TEXT )
CONTEXT: PL/pgSQL function vandelay.ingest_items(bigint,bigint) line 195 at FOR over SELECT rows
Is something missing from this branch or am I not having the right functions for some reason? I couldn't find oils_xpath_tag_to_table anywhere in the stock Evergreen code either...
Marking incomplete pending further details on this.
Hmm, what's oils_xpath_ tag_to_ table ? Cause it's referenced in the changes for the vandelay function, but I can't find it anywhere in our current schemas.
So I got errors like this showing up in my logs where my system can't find that function:
open-ils.cstore 2015-08-18 21:05:40 [ERR :54272: oils_sql. c:2486: 143993642354266 38] open-ils.cstore ERROR inserting vandelay: :queued_ bib_record object using query tag_to_ table( (SELECT mar...
^
FROM oils_xpath_ tag_to_ table( (SELECT marc FROM vandelay. queued_ bib_record WHERE id = import_id), attr_def.tag, xpaths)
AS t( ol TEXT, clib TEXT, cn TEXT, cnum TEXT, cs TEXT, cl TEXT, circ TEXT,
dep TEXT, dep_amount TEXT, r TEXT, hold TEXT, pr TEXT, bc TEXT, circ_mod TEXT,
circ_ as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id TEXT,
stat_ cat_data TEXT, opac_vis TEXT ) ingest_ items(bigint, bigint) line 195 at FOR over SELECT rows
LINE 2: FROM oils_xpath_
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT *
CONTEXT: PL/pgSQL function vandelay.
Is something missing from this branch or am I not having the right functions for some reason? I couldn't find oils_xpath_ tag_to_ table anywhere in the stock Evergreen code either...
Marking incomplete pending further details on this.