Nicklas Nordborg a écrit : > Hello Postgres users, > > We have now published some information about a workaround to make it > possible to upgrade a BASE installation running on a Postgres database. > > Hi Nicklas Thanks for the workaround.
I did the updatedb.sh as you suggested: it ran quite smoothly Then I tried the updateindexes.sh script, and I got the message: ================= Table : ExperimentRawBioAssays ================= ================= Table : ExperimentalFactors ================= ================= Table : Experiments Index : name_idx [name] Exists : true(Experiments_name_idx) Safe drop : true DROP-SQL : DROP INDEX "Experiments_name_idx" CREATE-SQL : CREATE INDEX "Experiments_name_idx" ON "Experiments" ("name") Actions : ================= ================= Table : ExtraValueTypes Index : name_idx [name] Exists : true(ExtraValueTypes_name_idx) Safe drop : true DROP-SQL : DROP INDEX "ExtraValueTypes_name_idx" CREATE-SQL : CREATE INDEX "ExtraValueTypes_name_idx" ON "ExtraValueTypes" ("name") Actions : ================= ================= Table : ExtraValues ================= ================= Table : Features Unique : uniquecoordinate [column, row, arraydesignblock_id] Exists : false Safe drop : false DROP-SQL : CREATE-SQL : ALTER TABLE "Features" ADD CONSTRAINT "Features_uniquecoordinate" UNIQUE ("column", "row", "arraydesignblock_id") Actions : CREATE 13:54:53,569 ERROR core:1723 - Exception org.postgresql.util.PSQLException: ERROR: relation "Features_uniquecoordinate" already exists at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1715) at net.sf.basedb.install.InitDB.main(InitDB.java:85) net.sf.basedb.core.BaseException: ERROR: relation "Features_uniquecoordinate" already exists at net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1724) at net.sf.basedb.install.InitDB.main(InitDB.java:85) Caused by: org.postgresql.util.PSQLException: ERROR: relation "Features_uniquecoordinate" already exists at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.sf.basedb.core.HibernateUtil.dbIndexes(HibernateUtil.java:1715) ... 1 more Is it serious ? -- Emmanuel COURCELLE [EMAIL PROTECTED] L.I.P.M. (UMR CNRS-INRA 2594/441) tel (33) 5-61-28-54-50 B.P.52627 - 31326 CASTANET TOLOSAN Cedex - FRANCE ------ ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]