added a comment -
2004-06-02 11:28 Virtual NODE type field, error during creation of table.
11:22:23,583 ERR 18056 kb storage.implementation.database.DatabaseStorageManager create.1302 - java.sql.SQLException: ERROR: column "channel" does not exist
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183)
at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:54)
at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1299)
at org.mmbase.storage.implementation.database.JDBC2NodeWrapper.create(JDBC2NodeWrapper.java:214)
at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:427)
It tries to create in index on this field, which it can't because it is virtual.
11:22:23,583 ERR 18056 kb storage.implementation.database.DatabaseStorageManager create.1302 - java.sql.SQLException: ERROR: column "channel" does not exist
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183)
at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:54)
at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1299)
at org.mmbase.storage.implementation.database.JDBC2NodeWrapper.create(JDBC2NodeWrapper.java:214)
at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:427)
It tries to create in index on this field, which it can't because it is virtual.