Greetings,
My colleague accidentally created a sub-community in our DSpace 4 and wants
to delete it, but when he clicks on "Delete Community", he has the
following error:
org.postgresql.util.PSQLException: ERROR: constraint "com2com_child_fk"
does not exist
How could it be fixed?
The community2community table has 47 rows and looks like this:
[image: Snag_255a96d3.png]
Additional information about the table:
-- Table: public.community2community
-- DROP TABLE public.community2community;
CREATE TABLE public.community2community
(
id integer NOT NULL,
parent_comm_id integer,
child_comm_id integer,
CONSTRAINT community2community_pkey PRIMARY KEY (id),
CONSTRAINT community2community_parent_comm_id_fkey FOREIGN KEY
(parent_comm_id)
REFERENCES public.community (community_id) MATCH Unknown
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.community2community
OWNER TO postgres;
==========================================
CREATE TABLE public.community2community (
id integer NOT NULL,
parent_comm_id integer,
child_comm_id integer
);
ALTER TABLE public.community2community OWNER TO postgres;
--
-- TOC entry 206 (class 1259 OID 16451)
-- Name: community2community_seq; Type: SEQUENCE; Schema: public; Owner:
postgres
--
CREATE SEQUENCE public.community2community_seq
START WITH 42
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/3d462066-7db6-4ec5-bd87-4a3f6b57c215n%40googlegroups.com.
