You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Jesse McConnell (JIRA)" <ji...@codehaus.org> on 2007/03/09 19:42:12 UTC
[jira] Closed: (CONTINUUM-994) New indexes created during continuum
startup when using postgresql
[ http://jira.codehaus.org/browse/CONTINUUM-994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesse McConnell closed CONTINUUM-994.
-------------------------------------
Resolution: Fixed
this was fixed with the jpox release of 1.1.6 which in turn created some other issues with postgres (but not this one :), however there is a new jpox version coming very soon which fixes those issues which we will upgrade to promptly
> 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-alpha-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