On Thu, Mar 6, 2014 at 1:01 AM, Keir Vaughan-Taylor
<[email protected]> wrote:
> nextValueId=$(psql -A -t -c "select max(metadata_value_id)+1
> from metadatavalue")
No, no no. This defeats the purpose of sequences.
> psql -A -t -c "insert into metadatavalue (metadata_value_id,
> item_id, metadata_field_id, text_value, text_lang,confidence) values
> ($nextValueId, $itemid, $metaDataCode1, '$md1', 'en', -1 )"
Use nextval('metadatavalue_seq') instead of $nextValueId.
I didn't check the rest.
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&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
