On Nov 1, 2010, at 12:38 PM, Nima Ghorbany wrote: > > hello guys, > i am using openerp which uses postgres as its database .when i do some database changes in openerp i get this error which is a reflection of postgres internall error.do u have any idea what does it mean? > Error: "document_directory_group_rel" violates foreign key constraint "document_directory_group_rel_item_id_fkey" > DETAIL: Key (item_id)=(230) is not present in table "document_directory". > > i know that foreign key contraint avoid entering invalid data into a table but how can i find this key and delete it? > > thanks I think error message itself is giving the information of item_id=230 Since parent table "document_director" does not have this value therefore it's not allowing to insert the values in table document_directory_group_rel. Thanks & Regards, Vibhor Kumar (PCP & OCP) ITIL V3 Cerftified. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
