foreign key violation error with partitioned table

Поиск
Список
Период
Сортировка
От gunce orman
Тема foreign key violation error with partitioned table
Дата
Msg-id 37a6274c0709060618i38db99d8t1f3db21a34af563e@mail.gmail.com
обсуждение исходный текст
Ответы Re: foreign key violation error with partitioned table  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Список pgsql-general
hello,

i have a partitioned table t_kayit with  6 partitions and kayit_id is primary key on this table. My other t_vto_sonuclari table use that kayit_id as foreign key. I'm trying to insert  values which contains kayit_id to t_vto_sonuclari and i'm sure those  kayit_ids are   in t_kayit table too but  when i'm inserting , i had  error.

ERROR:  insert or update on table "t_vto_sonuclari" violates foreign key constraint "fk_t_kayit_kayit_id"
DETAIL:  Key(kayit_id)=(54168) is not present in table t_kayit


I created a new test table which is totally same  as t_kayit but non partitioned . I create new foreign key on that t_vto_sonuclari which refers to the new test table.  In that case i didn't had that error.I could insert. what am i supposed to do for partitioned table?

В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Need suggestion on how best to update 3 million rows
Следующее
От: "Rajaram J"
Дата:
Сообщение: Wrong dynamic link ../../../src/interfaces/libpq/libpq.sl.3