foreign key violation - Mailing list pgsql-novice

From Larry Holish
Subject foreign key violation
Date
Msg-id 20010405225649.A15371@badlands.philberts.org
Whole thread Raw
List pgsql-novice
Hello,

I am inserting rows from a temp table into table A using INSERT INTO.
Table A has a foreign key referencing table B's primary key.  I get
the following error:

<unnamed> referential integrity violation - key referenced from table
A not found in table B

Is there a way to tell which row(s) is causing the problem?  I am
using ver. 7.02. Thanks in advance,

--
Larry Holish
<ljholish@speakeasy.net>

pgsql-novice by date:

Previous
From: Joel Burton
Date:
Subject: diff -c pgsql mysql (Was Database Name Case Sensitivity)
Next
From: "Tom Brown"
Date:
Subject: Postmaster hangs until Ctrl-C