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
[email protected]
"Be pleasant until ten o'clock in the morning and the rest of the day
will take care of itself." ~ Elbert Hubbard
