Skip to content

Instantly share code, notes, and snippets.

@chewmanfoo
Created February 15, 2011 03:08
Show Gist options
  • Save chewmanfoo/827032 to your computer and use it in GitHub Desktop.
Save chewmanfoo/827032 to your computer and use it in GitHub Desktop.
dspace 1.7.0 ant fresh_install error on centos 5.5 with postgresql 8.1.22
load_registries:
[java] 2011-02-15 01:44:05,905 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-02-15 01:44:05,917 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)
[java] 2011-02-15 01:44:06,764 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
[java] org.postgresql.util.PSQLException: ERROR: syntax error at or near "RETURNING"
[java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstracError:
[java] - ERROR: syntax error at or near "RETURNING"
[java] tJdbc2Statement.java:452)
@peterdietz
Copy link

Hi, I saw your post in the #dspace IRC. You need to upgrade the version of postgres you are using. This at a glance page will help with prereqs: https://wiki.duraspace.org/display/DSPACE/RoadMap

Using "returning" in the query is a significant performance of about 50% - 66% for inserts.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment