On Friday 14 December 2001 01:44 pm, Francisco Reyes wrote:
> 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.
Thanks for the reply. I'll check that out and see if its the case.
I don't know why I didn't think of that!? Well, I did think I
was doing something stupid :)
In response to
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2001-12-14 19:13:41|
|Subject: Re: Storing number '001' ?|
|Previous:||From: Francisco Reyes||Date: 2001-12-14 18:44:05|
|Subject: Re: A question about constraints.|