Dear Colleagues,
tried to transfer the database dump from DSpace 7.6 to DSpace version 8.0:

pg_restore: dropping CONSTRAINT item item_uuid_key
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3637; 2606 18745 CONSTRAINT item item_uuid_key 
dspace
pg_restore: error: could not execute query: ERROR:  cannot drop constraint 
item_uuid_key on table public.item because other objects depend on it
DETAIL:  constraint item_uuid_fkey on table public.qaevent_processed 
depends on index public.item_uuid_key
constraint notifypatterns_to_trigger_item_id_fkey on table 
public.notifypatterns_to_trigger depends on index public.item_uuid_key
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
Command was: ALTER TABLE IF EXISTS ONLY public.item DROP CONSTRAINT IF 
EXISTS item_uuid_key;
---------------------------------------
Сreated the dump with this command:
pg_dump -U postgres -W -h localhost -Fc -v -C -E UTF8 -d dspace -f 
dspace.sql

tried to transfer:
pg_restore -U postgres -W -h localhost -v -e -c --if-exists -d dspace 
dspace.sql

PostgreSQL 15
------------------------------------------
Has the database structure changed in the DSpace 8.0?
Help me fix this error.

DSpace UI 8 / REST API 8

Best regards,
Alex







-- 
All messages to this mailing list should adhere to the Code of Conduct: 
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/26b0724b-36eb-42de-b845-ff071ddb136fn%40googlegroups.com.

Reply via email to