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,
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 wrote:
> hi group,
>
> trying to create foreign key:
>
> ALTER TABLE porder1 ADD CONSTRAINT order_exist
> FOREIGN KEY (docuuserid) REFERENCE
On 5 September 2010 22:17, Ljubomir Erdeljan 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 tradeidis serial
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 tradeidis serial in trade and belong to primary key (single
column)
getting In E
