Ah, right! At any rate, handle_id is NOT part of the mix!
Bill
On Tue, Dec 10, 2013 at 3:10 PM, Brian Freels-Stendel <[email protected]>wrote:
> Upon trying to verify the statement, it looks like postgresql will allow:
>
>
>
> update handle set handle = 'NewH' || SUBSTRING(handle from POSITION('/' in
> handle)) where handle like 'OldH/%'
>
>
>
> So the new code would be:
>
>
>
> sql = "update handle set handle = '" + newH + "' ||
> SUBSTRING(handle from POSITION('/' in handle)) " +
>
> "where handle like '" + oldH + "/%'";
>
>
>
> B--
>
>
>
> *From:* Brian Freels-Stendel [mailto:[email protected]]
> *Sent:* Tuesday, December 10, 2013 1:42 PM
> *To:* Bill Tantzen; dspace-tech
> *Subject:* Re: [Dspace-tech] update-handle-prefix broken?
>
>
>
> I’m thinking maybe:
>
>
>
> set handle = '" + newH + "' || SUBSTRING(handle from POSITION('/' in
> handle)) from handle
>
>
>
> I’ve seen more than a few people on the newsgroups (and we’re in the same
> boat) who have changed the handle suffix so that it doesn’t necessarily
> correspond to the handle_id anymore. I think this would be a very good
> refinement.
>
>
>
> B--
>
>
>
> *From:* Bill Tantzen [mailto:[email protected] <[email protected]>]
> *Sent:* Tuesday, December 10, 2013 1:08 PM
> *To:* dspace-tech
> *Subject:* [Dspace-tech] update-handle-prefix broken?
>
>
>
> Or am I misunderstanding something? In UpdateHandlePrefix.java:
>
>
>
> sql = "update handle set handle = '" + newH + "' || '/' || handle_id " +
>
> "where handle like '" + oldH + "/%'";
>
>
>
> shouldn't this be
>
> set handle = '" + newH + "' || '/' || handle
>
>
>
> What do you think?
>
> Bill
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
