[
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
