[ https://jira.duraspace.org/browse/DS-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17917#action_17917 ]
Tim Donohue commented on DS-729: -------------------------------- Committed patch to Trunk in r5682. This patch removes all references to 'dctyperegistry' and its obsolete sequence from our 'database_schema' and 'update-sequences' scripts. I have not yet created 'database_schema_16-17.sql' upgrade scripts to remove this obsolete sequence from existing databases. Do others agree this should be done, even though it looks to be the *only* DB schema change in 1.7.0? IMHO we probably should have an upgrade script, even though this DB change is extremely minor. I'll keep this issue open until we come to a consensus on whether a schema upgrade script is warranted. > 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 Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel