Skip site navigation (1) Skip section navigation (2)

Re: A question about constraints.

From: Stephen Ingram <ingram(at)samsix(dot)com>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: A question about constraints.
Date: 2001-12-14 18:53:04
Message-ID: 20011214190050.SEAG5156.femail16.sdc1.sfba.home.com@there (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Hi Francisco,

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 :)

Thanks again.

Steve

In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2001-12-14 19:13:41
Subject: Re: Storing number '001' ?
Previous:From: Francisco ReyesDate: 2001-12-14 18:44:05
Subject: Re: A question about constraints.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group