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

[Scott Myers]

Alan,

I think this line ERROR:  cannot cast type hstore to public.hstore might be pointing to either not being logged in as evergreen or missing evergreen from your default search. It probably wants to use the evergreen.hstore.

I hope that helps.

Scott Myers

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Alan Rykhus
Sent: Tuesday, July 23, 2013 9:29 AM
To: Evergreen Development Discussion List
Subject: [OPEN-ILS-DEV] Issue Upgrading DB from 2.3.7 to 2.4

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