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
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 |