foreign key violation error with partitioned table

From: "gunce orman" <guncepostgres(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: foreign key violation error with partitioned table
Date: 2007-09-06 13:26:59
Message-ID: 37a6274c0709060626x2720ad45w85566f293eeeb910@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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 as 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?

Browse pgsql-general by date

  From Date Subject
Next Message SHARMILA JOTHIRAJAH 2007-09-06 13:37:28 Re: foreign key violation error with partitioned table
Previous Message Richard Huxton 2007-09-06 13:26:05 Re: ANY