From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | Ljubomir Erdeljan <ljubomir(dot)erdeljan(at)chello(dot)at> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: problem with foreign key |
Date: | 2010-09-05 20:38:34 |
Message-ID: | AANLkTiknXbdLo1PtO=3JqPjFi5vhVWQusKJuYUybv7uT@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 5 September 2010 22:17, Ljubomir Erdeljan <ljubomir(dot)erdeljan(at)chello(dot)at>wrote:
> hi group,
>
> trying to create foreign key:
>
> ALTER TABLE porder1 ADD CONSTRAINT order_exist
> FOREIGN KEY (docuuserid) REFERENCES trade(tradeid) ON DELETE RESTRICT;
>
> column docuuserid is integer in porder1
> column tradeid is serial in trade and belong to primary key (single
> column)
>
> getting In EMS PostgreSQL
> ERROR: insert or update on table "porder1" violates foreign key constraint
> "order_exist"
> DETAIL: Key (docuuserid)=(8415) is not present in table "trade".
>
> In PostgreSQL Code Factory
> SQL Error: ERROR: insert or update on table "porder1" violates foreign key
> constraint "order_exist"
> DETAIL: Key (docuuserid)=(8415) is not present in table "trade".
>
> postgresql 8.4.4-1 on windows 7 ultimate 64 bit standard installation
>
> I'm not able to figure out what should be a problem.
>
>
During the foreign key creation, database checks if all rows are correct,
and they are not. There is a row in the porder1 table where field docuuserid
= 8415 and there is no row in the table trader where tradeid=8415.
regards
Szymon Guz
From | Date | Subject | |
---|---|---|---|
Next Message | Bèrto ëd Sèra | 2010-09-05 20:40:48 | Re: problem with foreign key |
Previous Message | Ljubomir Erdeljan | 2010-09-05 20:17:22 | problem with foreign key |