Andrea:
I'm running 1.4.1 and so dcvalue is a view in this version. So I don't
think I have to use this command :
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue
Right?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrea
Bollini
Sent: Thursday, April 05, 2007 3:58 AM
To: Jose Blanco
Cc: [email protected]
Subject: Re: [Dspace-tech] inser/delete into the metadatavalue table
Hi Jose,
you can of course add metadata with a java script using DSpace API
without any problems. If you want add metadata from sql script you need
only to reset the metadata sequence at the end of your script.
SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
metadatavalue;
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue;
Of course you need also to run index-all at the end.
Best wishes,
Andrea
PS: deleting metadata doesn't require sequence update
Jose Blanco ha scritto:
>
> I sent this question out a few days ago, and did not hear anything.
> If some one has some info on it, could you let me know.
>
>
>
> Thanks!
>
>
>
> ------------------------------------------------------------------------
>
> *From:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Jose
> Blanco
> *Sent:* Monday, April 02, 2007 12:53 PM
> *To:* [email protected]
> *Subject:* [Dspace-tech] inser/delete into the metadatavalue table
>
>
>
> I have a big chunk of items I would like to add and delete metadata
> to. Previously I have updated the metadatavalue table when I have
> just wanted to do updates to certain metadata values, and then ran
> index-all, but I have never done inserts and deletes to this table via
> a script, and I want to make sure this will not cause any problems.
> Could some one let me know if this is safe to do?
>
>
>
> Thanks!
>
>
>
> Jose
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
