| 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: | Whole Thread | Raw Message | 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 |