Andrea: In looking at the dspace code, it seems like I could use this SQL: SELECT getnextid(metadatavalue)
And then issue and insert into metadavalue values ( ... ) using the metadata_value_id I get from the SELECT statement. Will this also work? -----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
