Gabriel, Where did you get your copy of 1.5 (download from Sourceforge, SVN, etc)?
It looks like something's wrong with your copy. In my 1.5, /dspace/etc/database_schema_14-15.sql looks like this: lines 97-101: DROP TABLE ItemsByAuthor CASCADE; DROP TABLE ItemsByTitle CASCADE; DROP TABLE ItemsByDate CASCADE; DROP TABLE ItemsByDateAccessioned CASCADE; DROP TABLE ItemsBySubject CASCADE; You are right that the "CONSTRAINTS" shouldn't be there...I'm just confused as to how they got there in your copy of 1.5. - Tim Gabriel Farrell wrote: > 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 > -- Tim Donohue Research Programmer, Illinois Digital Environment for Access to Learning and Scholarship (IDEALS) University of Illinois at Urbana-Champaign [EMAIL PROTECTED] | (217) 333-4648 ------------------------------------------------------------------------- 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
