New indexes created during continuum startup when using postgresql
------------------------------------------------------------------

                 Key: CONTINUUM-994
                 URL: http://jira.codehaus.org/browse/CONTINUUM-994
             Project: Continuum
          Issue Type: Bug
          Components: Database
    Affects Versions: 1.0.3
            Reporter: Richard C. L. Li


I used postgresql 8.1.4 with continuum and everytime when continuum startup, it 
creates a set of indexes.  I configured to restart continuum once a day and 
after 2 months it generated tens of indexes in every table.

I guessed this maybe the problem of the the UPPER CASE of the table and column 
names, this may make the detection of indexes fails and the JDO recreate 
everytime it startup.

Workaround: after starting continuum for the first time and set the property 
org.jpox.autoCreateSchema to false so that indexes will not recreated.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to