From: Erik Jones <erik@myemma.com>
To: Вадим Жерновой |Vadim Zhernovoi| <vadim.zhernovoi@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with FOREIGN KEY
Date: Tue, 22 Apr 2008 10:37:33 -0500
Message-ID: <4C22A975-793B-42A6-911C-85ABDDCEAF64@myemma.com> (raw)
In-Reply-To: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com>
References: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com>
On Apr 22, 2008, at 10:26 AM, Вадим Жерновой |Vadim
Zhernovoi| wrote:
> I have a Problem with Foreign key query...i've posted the code on
> http://pgsl.privatepaste.com/e44p3Orqiq, so it have syntax higlight.
> Please, need help!
What that's telling you is that there is data in your Users table that
doesn't satisfy the foreign key constraint, i.e. there is a Users row
with SecurityRoleId=0 and no row in SecurityRole with ID=0.
Erik Jones
DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: erik@myemma.com, vadim.zhernovoi@gmail.com
Subject: Re: Problem with FOREIGN KEY
In-Reply-To: <4C22A975-793B-42A6-911C-85ABDDCEAF64@myemma.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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