[OPEN-ILS-DEV] problems with 1.2.1.4-1.2.2.0 postgres upgrade script

[John Fink]

Hey folks,

In the midst of trying to upgrade from 1.2.1.4 to 1.2.2.0, and following the
instructions here:
http://open-ils.org/dokuwiki/doku.php?id=upgrading:1.2.1_to_1.2.2; the
postgres upgrade script yields the following unhappiness:

BEGIN
SELECT
INSERT 0 75369
psql:1.2.1-1.2.2-upgrade-db.sql:29: NOTICE:  ALTER TABLE / ADD PRIMARY KEY
will create implicit index "materialized_simple_record_pkey" for table
"materialized_simple_record"
ALTER TABLE
CREATE VIEW
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
COMMIT
psql:1.2.1-1.2.2-upgrade-db.sql:85: ERROR:  schema "search" does not exist
BEGIN
psql:1.2.1-1.2.2-upgrade-db.sql:93: ERROR:  view "overdue_reports" does not
exist
psql:1.2.1-1.2.2-upgrade-db.sql:100: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:1.2.1-1.2.2-upgrade-db.sql:102: ERROR:  current transaction is aborted,
commands ignored until end of transaction block (and so on and so on
until...)
ROLLBACK

Any ideas about this?

jf

-- 
http://libgrunt.blogspot.com -- library culture and technology.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080509/d7b987c3/attachment.html