[ome-users] upgrade db for beta 3.0.1 to 3.1.1 failed

[Kent Nasveschuk]

Hello,
        
        I got the following errors during the database upgrade from
        Omero
        Beta3.0.1 to Beta3.1.1
        :
        ...
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        ALTER TABLE
        CREATE SEQUENCE
        CREATE SEQUENCE
        DROP TABLE
        CREATE VIEW
        DROP TABLE
        CREATE VIEW
        ERROR:  syntax error at or near "," at character 975
        LINE 23:         FOR dup1, dup2 IN EXECUTE sql LOOP
                                 ^
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        ERROR:  current transaction is aborted, commands ignored until
        end of
        transaction block
        
        ....(many of these above)
        
        Suggestions?
        
        Kent
        
-- 
Kent L. Nasveschuk
Systems Administrator
Marine Biological Laboratory
7 MBL Street
Woods Hole, MA 02543
Tel. (508) 289-7263