Hey presto! It works. Thanks Dan and Mike! jf
On Fri, May 9, 2008 at 9:50 AM, Dan Scott <[EMAIL PROTECTED]> wrote: > 2008/5/9 John Fink <[EMAIL PROTECTED]>: > > 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 > -- http://libgrunt.blogspot.com -- library culture and technology.