Integrity Error

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

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vibhor Kumar 2010-11-01 07:20:31 Re: Integrity Error
Previous Message Dimitri Fontaine 2010-10-31 18:45:53 Re: large database: problems with pg_dump and pg_restore