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:18:19 |
Message-ID: | 37a6274c0709060618i38db99d8t1f3db21a34af563e@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 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Rajaram J | 2007-09-06 13:25:17 | Wrong dynamic link ../../../src/interfaces/libpq/libpq.sl.3 |
Previous Message | Lincoln Yeoh | 2007-09-06 13:06:06 | Re: Need suggestion on how best to update 3 million rows |