[Dspace-tech] upgrade from 1.5. to 1.6x Postgres error

2011-01-10 Thread Jeffrey Trimble
I've just attempted to upgrade a test server and got the following error while 
running the sql update script:

psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:105:
 ERROR:  constraint community2collection_collection_id_fkey does not exist
ALTER TABLE
psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:108:
 ERROR:  constraint community2community_child_comm_id_fkey does not exist
ALTER TABLE
psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:111:
 ERROR:  constraint collection2item_item_id_fkey does not exist
ALTER TABLE
UPDATE 0
UPDATE 0

Anything to be concerned about?  Or is there something missing?

Thanks in advance,


Jeffrey Trimble
System LIbrarian
William F.  Maag Library
Youngstown State University
330.941.2483 (Office)
jatrim...@ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
For he is the Kwisatz Haderach...

--
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure 
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl ___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] upgrade from 1.5. to 1.6x Postgres error

2011-01-10 Thread Claudia Juergen
Hi Jeffrey,

yes you should mend this, as you now will be unable to delete collections,
communities etc. For details see

http://www.mail-archive.com/dspace-tech@lists.sourceforge.net/msg11522.html

Hope that helps

Claudia Jürgen

 I've just attempted to upgrade a test server and got the following error
 while running the sql update script:

 psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:105:
 ERROR:  constraint community2collection_collection_id_fkey does not
 exist
 ALTER TABLE
 psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:108:
 ERROR:  constraint community2community_child_comm_id_fkey does not exist
 ALTER TABLE
 psql:/dspace-1.6.2-src-release/dspace/etc/postgres/database_schema_15-16.sql:111:
 ERROR:  constraint collection2item_item_id_fkey does not exist
 ALTER TABLE
 UPDATE 0
 UPDATE 0

 Anything to be concerned about?  Or is there something missing?

 Thanks in advance,


 Jeffrey Trimble
 System LIbrarian
 William F.  Maag Library
 Youngstown State University
 330.941.2483 (Office)
 jatrim...@ysu.edu
 http://www.maag.ysu.edu
 http://digital.maag.ysu.edu
 For he is the Kwisatz Haderach...

 --
 Gaining the trust of online customers is vital for the success of any
 company
 that requires sensitive data to be transmitted over the Web.   Learn how
 to
 best implement a security strategy that keeps consumers' information
 secure
 and instills the confidence they need to proceed with transactions.
 http://p.sf.net/sfu/oracle-sfdevnl
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech



Mit freundlichen Gruessen

Claudia Juergen
Universitaetsbibliothek Dortmund
Eldorado
0231/755-4043
https://eldorado.tu-dortmund.de/
Tel.: 0049-231-755-4043




--
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure 
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl 
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech