On Fri, 14 Dec 2001, Stephen Ingram wrote:
> 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 believe the copy command tells you the record that it is having problems
with. In your example above it seems the problem occurred in the very
first record. So far every time I have had problems with copy it reported
the line that it had the problems with.
In response to
pgsql-novice by date
|Next:||From: Stephen Ingram||Date: 2001-12-14 18:53:04|
|Subject: Re: A question about constraints.|
|Previous:||From: Leandro Fanzone||Date: 2001-12-14 17:36:12|
|Subject: Re: Multiple IN|