Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Can not delete node due to database table constraint
Description
If a node has an entry in the ipnettomedia table it can not be deleted.
opennms=# delete from node where nodeid=114 ; ERROR: update or delete on table "node" violates foreign key constraint "fk_ipnettomedia_nodeid" on table "ipnettomedia" DETAIL: Key (nodeid)=(114) is still referenced from table "ipnettomedia".
If a node has an entry in the ipnettomedia table it can not be deleted.
opennms=# delete from node where nodeid=114 ;
ERROR: update or delete on table "node" violates foreign key constraint "fk_ipnettomedia_nodeid" on table "ipnettomedia"
DETAIL: Key (nodeid)=(114) is still referenced from table "ipnettomedia".