[OPEN-ILS-DEV] Issue Upgrading DB from 2.3.7 to 2.4

[Alan Rykhus]

Hello,

I'm trying to upgrade a 2.3.7 Postgress 9.1 DB to 2.4.0

The version-upgrade/2.3-2.4.0-upgrade-db.sql script is erring off with 
the following:

psql:version-upgrade/2.3-2.4.0-upgrade-db.sql:1877: ERROR:  function 
unapi.bmp(integer, text, text, text[], text, integer, hstore, hstore, 
boolean) does not exist
LINE 48:                                 SELECT  unapi.bmp( id, CAST(...
                                                  ^
HINT:  No function matches the given name and argument types. You might 
need to add explicit type casts.

This comes from line 1834:

SELECT  unapi.bmp( id, 'xml', 'monograph_part', 
evergreen.array_remove_item_by_value( 
evergreen.array_remove_item_by_value($5,'bre'), 'holdings_xml'), $3, $4, 
$6, $7, FALSE)

I tried using CAST changing the line to:

SELECT  unapi.bmp(CAST(id as bigint), CAST('xml' as text), 
CAST('monograph_part' as text), evergreen.array_remove_item_by_value( 
evergreen.array_remove_item_by_value($5,'bre'), 'holdings_xml'), $3, $4, 
$6, $7, FALSE)

This returns:

psql:version-upgrade/2.3-2.4.0-upgrade-db.sql:1877: ERROR:  function 
unapi.bmp(integer, text, text, text[], text, integer, hstore, hstore, 
boolean) does not exist
LINE 48:                                 SELECT  unapi.bmp( id, CAST(...
                                                  ^
HINT:  No function matches the given name and argument types. You might 
need to add explicit type casts.

and

SELECT  unapi.bmp(CAST(id as bigint), CAST('xml' as text), 
CAST('monograph_part' as text), evergreen.array_remove_item_by_value( 
evergreen.array_remove_item_by_value($5,'bre'), 'holdings_xml'), $3, $4, 
CAST($6 as public.hstore), CAST($7 as public.hstore), FALSE)

This returns:

psql:version-upgrade/2.3-2.4.0-upgrade-db.sql:1877: ERROR:  cannot cast 
type hstore to public.hstore
LINE 48: ...item_by_value($5,'bre'), 'holdings_xml'), $3, $4, CAST($6 as...
                                                               ^

Al


-- 
Alan Rykhus
PALS, A Program of the Minnesota State Colleges and Universities
(507)389-1975
alan.rykhus at mnsu.edu
"Be pleasant until ten o'clock in the morning and the rest of the day
will take care of itself." ~ Elbert Hubbard