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

[John Fink]

Hey presto!  It works.  Thanks Dan and Mike!

jf

On Fri, May 9, 2008 at 9:50 AM, Dan Scott <denials at gmail.com> wrote:

> 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
>



-- 
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/904e5e32/attachment.html