On Dec 31, 2010, at 7:34 AM, Clive Gould wrote: > Hi everyone > > I've just tried to upgrade DSpace on our test server (CentOS Linux) > from version 1.6.2 to 1.7.0 > > I have got to the very end of the upgrade procedure only to be faced > by the following error message when I try to run the index script: > > [dsp...@standbyvle dspace-1.7.0-build.dir]$ psql -U dspace -f > /home/dspace/dspace-1.7.0-src-release/dspace/etc/postgres/database_schema_16-17.sql > dspace > DROP SEQUENCE > [dsp...@standbyvle dspace-1.7.0-build.dir]$ /home/dspace/bin/dspace index-init > Started: 1293794521880 > Ended: 1293794523440 > Elapsed time: 1 secs (1560 msecs) > Exception: org.postgresql.util.PSQLException: ERROR: syntax error at > or near "RETURNING"
Clive, DSpace 1.7 requires a PostgreSQL version of 8.2 or higher. This looks like a message that you might receive when you use an older version. --keith ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
