|
Hi
I don't understand what the following error
means.
I am trying to add a foreign key to table image,
that holds column device_id. This is to be controlled by column
devices_id in table devices.
ALTER TABLE distributors ADD CONSTRAINT distfk
FOREIGN KEY (address) REFERENCES addresses (address) MATCH FULL;
ERROR: insert or update on table "image"
violates foreign key constraint "deviceidfk"
DETAIL: Key (device_id)=(4022) is not present in table "devices". Help appreciated.
Bob
|
