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

[Lee Dickens]

I just ran through a test upgrade the other day and attached is a diff 
of all the changes I had to make to the script to get it to run 
through.  Ben this addresses the force_unicode_normal_form error as well.

Thanks,
Lee


On 08/18/2011 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...
>
> -- Ben

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2.0-2.1-upgrade-db.sql.diff
Type: text/x-patch
Size: 10787 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110818/f32d476d/attachment.bin>