From: Ljubomir Erdeljan <ljubomir.erdeljan@chello.at>
To: pgsql-admin@postgresql.org
Subject: Re: problem with foreign key
Date: Sun, 05 Sep 2010 22:49:32 +0200
Message-ID: <4C84025C.1060606@chello.at> (raw)
In-Reply-To: <AANLkTimWR_6BOw8yN7f71chEm86QrVDfvPeQT_RCsH=0@mail.gmail.com>
References: <4C83FAD2.6050906@chello.at>
<AANLkTimWR_6BOw8yN7f71chEm86QrVDfvPeQT_RCsH=0@mail.gmail.com>
This relate to different column names
docuuserid is column in porder1 but relate to tradeid in trade.
Thank you,
On 05/09/2010 22:40, Bèrto ëd Sèra wrote:
> 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.erdeljan@chello.at <mailto:ljubomir.erdeljan@chello.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@postgresql.org
> <mailto:pgsql-admin@postgresql.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ljubomir.erdeljan@chello.at
Subject: Re: problem with foreign key
In-Reply-To: <4C84025C.1060606@chello.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox