I am working on CentOS release 6.8 (Final) based server without sudo access. I compiled PostgreSQL v9.6 beta 2.
When I am loading data using ant, I get am.amcanorder column doesn't exist error which I don't know how to fix.
I am following a tutorial to set up Intermine data warehousing system and I am on this step.
ant -Dsource=uniprot-malaria -v
This will take a couple of minutes to complete, the command runs the following steps:
The bold part is what (in my opinion) causing the error. The relevant error verbose is:
org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Position: 407
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4234)
at org.intermine.task.CreateIndexesTask.execute(CreateIndexesTask.java:212)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
Well the problem was fixed by compiling v9.5.3, the latest stable version at this time. Previously, I was using v9.6beta2 ... which has a reported error when working with JDBC & v9.6beta2.