Integrity Error

From: Nima Ghorbany <nima(dot)g(dot)67(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Integrity Error
Date: 2010-11-01 07:03:55
Message-ID: AANLkTinxvoCq43XWrQEm31Vst11OJsbmKk2seRhpUHv0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message A B 2010-11-01 12:44:56 How to have two not null constraints at the same time
Previous Message m 2010-10-31 08:12:53 Re: detecting metadata corruption after dirty shutdown