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

[Jim Taylor]

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/20180423/518c75e0/attachment.html>