FAQ
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>

Search Discussions

  • Vijay Deval at Apr 10, 2001 at 3:56 pm
    If you put condition

    WHERE primery key from ref. table= its mirror in temp table, the inserts
    should go through.

    if objective is to find out the rows, NOT EXISTS could be used on temp and
    ref. table

    Vijay

    Larry Holish wrote:
    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>

    ---------------------------(end of broadcast)---------------------------
    TIP 4: Don't 'kill -9' the postmaster

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedApr 6, '01 at 3:59a
activeApr 10, '01 at 3:56p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Larry Holish: 1 post Vijay Deval: 1 post

People

Translate

site design / logo © 2022 Grokbase