Hullo,
I have added a constraint to a table to prevent it loading
data unless its key field is in another table (whose data
I have previously loaded)
ALTER TABLE OnMap ADD CONSTRAINT objid_check1 FOREIGN KEY (fname, lname)
REFERENCES Object (fname, lname);
Indeed, the constraint works:
COPY OnMap FROM '/data/OnMap.dump' USING DELIMITERS '|'
psql:OnMap:1: ERROR: objid_check1 referential integrity violation - key referenced
from onmap not found in object
But... is there anyway to get PostgreSQL to tell me which record or records
are failing to load ?
I am assuming I am doing something stupid here.
Cheers
Steve