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.