[
https://jira.duraspace.org/browse/DS-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17922#action_17922
]
Sands Fish commented on DS-729:
-------------------------------
+1 for having a db migration script. If the old cruft isn't cleaned out of the
database as we move along, it's going to make for some very messy db tables in
the future and no good way to track why some things are left in but unused.
> update-sequences.sql script errors out, as it refers to an old, obsolete
> 'dctyperegistry' table
> -----------------------------------------------------------------------------------------------
>
> Key: DS-729
> URL: https://jira.duraspace.org/browse/DS-729
> Project: DSpace
> Issue Type: Bug
> Affects Versions: 1.5.0, 1.5.1, 1.5.2, 1.6.0, 1.6.1, 1.6.2
> Environment: Oracle or PostgreSQL database
> Reporter: Tim Donohue
> Assignee: Tim Donohue
> Fix For: 1.7.0
>
> Attachments: update-sequences.patch
>
>
> The 'update-sequences.sql' script is currently broken for both PostgreSQL and
> Oracle, as it refers to the old 'dctyperegistry' table (which was removed
> back in DSpace 1.4.0, I believe).
> I've attached a patch which removes the references to 'dctyperegistry' table,
> along with the 'dctyperegistry_seq' sequence (which is no longer used by
> DSpace). I'll commit this patch to Trunk shortly for the 1.7 release.
> We may want to also create a 1.6->1.7 database upgrade script to remove this
> unused sequence (though admittedly it won't hurt any DSpace instances to keep
> that 'dctyperegistry_seq' sequence around). But, that idea is up for debate
> -- any strong opinions on this?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.duraspace.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
