[OPEN-ILS-GENERAL] Change in DB action regarding SQL marc update

[Josh Stompro]

Jim, I wonder if this is a scope/search path issue?  "oils_xpath" looks like it has no schema specified there.

When I run "show search_path" I get

show search_path;
          search_path
-------------------------------
evergreen, public, pg_catalog

Josh Stompro - LARL IT Director

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Jim Taylor
Sent: Monday, April 23, 2018 2:48 PM
To: 'Evergreen Discussion Group' <open-ils-general at list.georgialibraries.org>
Subject: [OPEN-ILS-GENERAL] Change in DB action regarding SQL marc update

I haven't done this for a while but just tried a straightforward SQL update of the "marc" field in the biblio.record_entry table and get the error below.   Have done this 10's of thousands of times within the last year or so with no problem.  Currently running version 2.12.6.   Did something change which would purposely cause such an action to fail?   Suggestions?   Thanks.


Jim


ERROR:  function oils_xpath(text, text, text[]) does not exist
LINE 6:                         (oils_xpath(
                                 ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT COALESCE(
            naco_normalize(
                ARRAY_TO_STRING(
                    oils_xpath(
                        '//text()',
                        (oils_xpath(
                            idx.xpath,
                            transformed_xml,
                            ARRAY[ARRAY[xfrm.prefix, xfrm.namespace_uri]]
                        ))[1]
                    ),
                    ''
                )
            ),
            ''
        )
CONTEXT:  PL/pgSQL function biblio.extract_fingerprint(text) line 34 at assignment
PL/pgSQL function biblio.fingerprint_trigger() line 10 at assignment
********** Error **********

ERROR: function oils_xpath(text, text, text[]) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Context: PL/pgSQL function biblio.extract_fingerprint(text) line 34 at assignment
PL/pgSQL function biblio.fingerprint_trigger() line 10 at assignment

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20180424/d5f24629/attachment-0001.html>