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

Re: A question about constraints.

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Stephen Ingram <ingram(at)samsix(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: A question about constraints.
Date: 2001-12-14 18:44:05
Message-ID: 20011214134303.V46676-100000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Stephen IngramDate: 2001-12-14 18:53:04
Subject: Re: A question about constraints.
Previous:From: Leandro FanzoneDate: 2001-12-14 17:36:12
Subject: Re: Multiple IN

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