From: Lew <noone@lewscanon.com>
To: pgsql-admin@postgresql.org
Subject: Re: problem with foreign key
Date: Mon, 06 Sep 2010 20:22:22 -0400
Message-ID: <i640jg$rk6$1@news.albasani.net> (raw)
In-Reply-To: <4C84025C.1060606@chello.at>
References: <4C83FAD2.6050906@chello.at>
<AANLkTimWR_6BOw8yN7f71chEm86QrVDfvPeQT_RCsH=0@mail.gmail.com>
<4C84025C.1060606@chello.at>
Please do not top-post.
Bèrto ëd Sèra wrote:
>> An immediate question: did you check that Key (docuuserid)=(8415) is
>> actually present in table "trade"?
Ljubomir Erdeljan wrote:
> This relate to different column names
> docuuserid is column in porder1 but relate to tradeid in trade.
You missed the point. Did you check that the key is present in "trade"?
IOW, is there a row in "trade" with "tradeid" equal to 8415? If not, you
cannot create the foreign key because the item in "porder1" cannot point to it.
--
Lew
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: noone@lewscanon.com
Subject: Re: problem with foreign key
In-Reply-To: <i640jg$rk6$1@news.albasani.net>
* 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