Upgrading from 1.4.2 to 1.5, I notice errors like the following when I
run dspace/etc/database_schema_14-15.sql:
psql:dspace/etc/database_schema_14-15.sql:98: ERROR: syntax error
at or near "CONSTRAINTS" at character 34
The line the error refers to reads:
DROP TABLE ItemsByAuthor CASCADE CONSTRAINTS;
It appears that the use of "CONSTRAINTS" on a DROP TABLE is Oracle-
specific. Those tables that should be dropped remain in the database
unless "CONSTRAINTS" is removed from those queries.
Gabriel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
