Re: problem with foreign key

An immediate question: did you check that Key (docuuserid)=(8415) is
actually present in table "trade"?

Bèrto

On 5 September 2010 23: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.
>
>
>
> kindly regards
>
> ljubomir erdeljan
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
==============================
Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les
droits du peuple, l'insurrection est, pour le peuple et pour chaque portion
du peuple, le plus sacré des droits et le plus indispensable des devoirs.