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

[Dan Scott]

2008/5/9 John Fink <john.fink at gmail.com>:
> 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

Hey John:

Try http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/src/sql/Pg/1.2.1-1.2.2-upgrade-db.sql
instead - I noticed the same problem and reported it back to Mike, who
updated the script accordingly - but of course that's not in the
1.2.2.0 tarball.

-- 
Dan Scott
Laurentian University