Re: svn commit: r631076 - /ofbiz/trunk/applications/content/entitydef/entitymodel.xml

[Rashko Rejmer <rr...@iguanait.com>]

Hi all,

During run-install I got this error message:

     [java] 2008-04-07 14:39:23,226 (main) [
DatabaseUtil.java:2953:ERROR] Could not create foreign key indices for
entity [DataResource]: SQL Exception while executing the following:
     [java] CREATE INDEX SURVEY ON public.DATA_RESOURCE (SURVEY_ID)
     [java] Error was: org.postgresql.util.PSQLException: ERROR:
relation "survey" already exists


Maybe it is better to add explicit foreign key:


Index: applications/content/entitydef/entitymodel.xml
===================================================================
--- applications/content/entitydef/entitymodel.xml	(revision 645459)
+++ applications/content/entitydef/entitymodel.xml	(working copy)
@@ -804,7 +804,7 @@
       <relation type="one" fk-name="DATA_REC_LMB_ULGN"
title="LastModifiedBy" rel-entity-name="UserLogin">
         <key-map field-name="lastModifiedByUserLogin"
rel-field-name="userLoginId"/>
       </relation>
-        <relation type="one" rel-entity-name="Survey">
+        <relation type="one" fk-name="DATA_REC_TO_SURVEY"
rel-entity-name="Survey">
             <key-map field-name="surveyId"/>
         </relation>
         <relation type="one" rel-entity-name="SurveyResponse">

Regards,
Rashko Rejmer