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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
