Re: [Dspace-tech] Database Question

2009-09-22 Thread Van Ly
On 16/09/2009, at 7:20 AM, Greg Johnson wrote: > The question I have is this: If we were to take a "do-over" and > recreate DSpace from scratch, having copied our Postgres database > prior the rebuild, would not the communities and collections that > we currently have be transferrable to t

[Dspace-tech] Database Question

2009-09-15 Thread Greg Johnson
We are having issues with our current installation of DSpace (1.5.1) that we have been troubleshooting and can't seem to solve. One option as a solution would be to download and recreate DSpace from scratch. The question I have is this: If we were to take a "do-over" and recreate DSpace from scra

Re: [Dspace-tech] Database question

2007-09-11 Thread Bernadette Schlonsok
Hello Mika, this error says, you have duplicated values in a column with unique index. For DSpace 1.4 you can check all unique index as follow: select name, count(*) from epersongroup group by name having count(*)>1; select short_description, count(*) from BitstreamFormatRegistry group by short_d

[Dspace-tech] Database question

2007-09-10 Thread Mika Stenberg
While reindexing Dspace database I get following error. Wonder whats causing this and how could I fix this? reindexdb: reindexing of database "dspace" failed: ERROR: could not create unique index DETAIL: Table contains duplicated values. -Mika -