Re: foreign key violation

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(at)speakeasy(dot)net>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster