[
http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_85955
]
Richard C. L. Li commented on CONTINUUM-994:
--------------------------------------------
Continuum will generate an exception when using with postgresql and JPOX 1.1.6
upon browsing the web page at the first time, the problem is resides in plexus:
{panel}
http://jira.codehaus.org/browse/PLX-322
{panel}
> 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
> Fix For: 1.1
>
>
> 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
