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.
pgsql-novice by date
|Next:||From: Leandro Fanzone||Date: 2001-12-14 17:36:12|
|Subject: Re: Multiple IN|
|Previous:||From: Josh Berkus||Date: 2001-12-14 16:56:01|
|Subject: Re: Custom Reports|