pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Integrity Error
2+ messages / 2 participants
[nested] [flat]

* Integrity Error
@ 2010-11-01 07:08  Nima Ghorbany <nima.g.67@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nima Ghorbany @ 2010-11-01 07:08 UTC (permalink / raw)
  To: 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Integrity Error
@ 2010-11-01 07:20  Vibhor Kumar <vibhor.aim@gmail.com>
  parent: Nima Ghorbany <nima.g.67@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Vibhor Kumar @ 2010-11-01 07:20 UTC (permalink / raw)
  To: Nima Ghorbany <nima.g.67@gmail.com>; +Cc: pgsql-admin


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

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 table document_directory_group_rel.

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-11-01 07:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-01 07:08 Integrity Error Nima Ghorbany <nima.g.67@gmail.com>
2010-11-01 07:20 ` Vibhor Kumar <vibhor.aim@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox