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