ERROR: update or delete on table "addresses" violates foreign key constraint "fk_systems_interfaces_address" on table "interface_addresses" DETAIL: Key (address)=(2620:8d:8000:e50::fffc) is still referenced from table "interface_addresses". CONTEXT: SQL statement "DELETE FROM "ip"."addresses" WHERE "ip"."addresses"."address" << OLD."subnet"" PL/pgSQL function "subnets_update" line 35 at SQL statement SQL statement "UPDATE "ip"."subnets" SET autogen = $3, date_modified = localtimestamp(0), last_modifier = api.get_current_user() WHERE "subnet" = $1" PL/pgSQL function "modify_ip_subnet" line 20 at EXECUTE statement
ERROR: update or delete on table "addresses" violates foreign key constraint "fk_systems_interfaces_address" on table "interface_addresses" DETAIL: Key (address)=(2620:8d:8000:e50::fffc) is still referenced from table "interface_addresses". CONTEXT: SQL statement "DELETE FROM "ip"."addresses" WHERE "ip"."addresses"."address" << OLD."subnet"" PL/pgSQL function "subnets_update" line 35 at SQL statement SQL statement "UPDATE "ip"."subnets" SET autogen = $3, date_modified = localtimestamp(0), last_modifier = api.get_current_user() WHERE "subnet" = $1" PL/pgSQL function "modify_ip_subnet" line 20 at EXECUTE statement