foreign key violation

Поиск
Список
Период
Сортировка
Искать
От
Larry Holish
Тема
foreign key violation
Дата
Msg-id
20010405225649.A15371@badlands.philberts.org
Список
Дерево обсуждения
Re: foreign key violation Vijay Deval <deval@giaspn01.vsnl.net.in>
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:

 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

В списке pgsql-novice по дате отправления
От: Joel Burton
Дата:
От: Tom Brown
Дата:
Сообщение: Postmaster hangs until Ctrl-C
FAQ