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 <[email protected]>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 ([email protected]) > 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.
