[OPEN-ILS-DEV] 2.1 RC2 upgrade script testing

Bill Ott bott at grpl.org
Thu Aug 18 11:12:10 EDT 2011


On 8/18/11 10:31 AM, Ben Shum wrote:
> Short follow-up, just tested our script on a freshly restored test copy
> of our DB and hit this error twice now:
>
> psql:Evergreen-ILS-2.1-RC2/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6003:
> ERROR:  function force_unicode_normal_form(text, unknown) does not exist
> LINE 1: SELECT force_unicode_normal_form(NEW.value,'NFC')
>                 ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
> QUERY:  SELECT force_unicode_normal_form(NEW.value,'NFC')
> CONTEXT:  PL/pgSQL function "facet_force_nfc" line 2 at assignment
>
> No solution yet, still tinkering with what it means...


I believe that's what I stumbled upon and confused myself.  In short, 
add the schema.

https://bugs.launchpad.net/evergreen/+bug/825881


More information about the Open-ils-dev mailing list