DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=BOHoJYjp/n89ZFkIzXEsVV6t8FOhNlPUvBIrh1MZgn+MgxIvK6RDvW10sm7f74Hxbz
	VjsFPEepQSQ+aR/xz7EvYZ5W/Rj2jWEs8Cg8k6RsO4tVjwOFPUNg181vJ2oZqmLSYMuq
	wGHbSTn1tGmtjFkjJqMF0rFnzTrHzHrADT/EM=
Subject: Re: Integrity Error
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <AANLkTikp5c0xNwicLXdeF9xbsRtgvS8aX-Cgyb5RbswS@mail.gmail.com>
Date: Mon, 1 Nov 2010 12:50:31 +0530
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <13139F86-6692-4C95-91C6-1452383253BE@gmail.com>
References: <AANLkTikp5c0xNwicLXdeF9xbsRtgvS8aX-Cgyb5RbswS@mail.gmail.com>
To: Nima Ghorbany <nima.g.67@gmail.com>


On Nov 1, 2010, at 12:38 PM, Nima Ghorbany wrote:

>=20
> 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)=3D(230) is not present in table =
"document_directory".
>=20
> i know that foreign key contraint avoid entering invalid data into a =
table but how can i find this key and delete it?
>=20
> thanks

I think error message itself is giving the information of item_id=3D230

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.