Perfect - thanks very much. Anthony
-----Original Message----- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Tuesday, December 10, 2013 10:32 AM To: Anthony Petryk Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Error when adding a new bitstream format On Tue, Dec 10, 2013 at 3:52 PM, Anthony Petryk <anthony.pet...@uottawa.ca> wrote: > Is there a fix for this? I could update the database manually but > would prefer that it worked via the web UI. We’re on version 1.8.2. Hi Anthony, run [dspace]/etc/postgres/update-sequences.sql (using the psql command). That will update the value of the bitstreamformatregistry_seq sequence to the highest value of bitstream_format_id in bitstreamformatregistry and thus the sequence will return an available value on the next nextval() call when adding a new row to that table. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
