Обсуждение: Integrity Error

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

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
whichis 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
tabledocument_directory_group_rel. 

Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.