Hi,
I have postgresql 7.2.3-5.80 running on RedHat 8.0 distribution.
I got the error message:
ERROR: No such attribute or function 'oid'
I'm using the JDBC driver that comes with RedHat 8.0 Distribution.
I'm able to create tables in the database but metadata.getColumns() fails.
Does anyone else have the same problem?
What possibly could be the reason for this error message?
Any help will be greatly appreciated!
Thank you in advance!
Milen
P.S. please find detailed error log bellow:
-----------------------------------------------------------------------------
[dspace@localhost dspace]$ ant fresh_install
Buildfile: build.xml
update:
install_code:
setup_database:
[java] 2003-03-30 16:09:44,832 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
load_registries:
[java] 2003-03-30 16:09:48,518 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
[java] java.sql.SQLException: ERROR: No such attribute or function 'oid' [java] at org.postgresql.Connection.ExecSQL(Connection.java:533)
[java] at org.postgresql.Connection.ExecSQL(Connection.java:400)
[java] at org.postgresql.jdbc2.DatabaseMetaData.getColumns(DatabaseMetaData.java:1894)
[java] at org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseManager.java:1078)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseManager.java:1044)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.java:525)
[java] at org.dspace.storage.rdbms.DatabaseManager.getColumnNames(DatabaseManager.java:584)
[java] at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:260)
[java] at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:358)
[java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:205)
[java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:172)
[java] at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:111)
BUILD FAILED
file:/dspace/build.xml:257: Java returned: 1
Total time: 7 seconds
[dspace@localhost dspace]$