[OPEN-ILS-DEV] problems with 1.2.1.4-1.2.2.0 postgres upgrade script
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.
Re: [OPEN-ILS-DEV] problems with 1.2.1.4-1.2.2.0 postgres upgrade script
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
Re: [OPEN-ILS-DEV] problems with 1.2.1.4-1.2.2.0 postgres upgrade script
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.