Hi Group,
Many Thanks to Mr. Berto D Sera for heading up
I have found two rows in porder1 which refer to non-existing trade record.
after correction creation of foreign key went successful.
Thanks to other Hackers who has replayed me.
Ljubomir Erdeljan
--
Sent via pgadmin-hackers mailing lis
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 EM
