Re: Problem with FOREIGN KEY - Mailing list pgsql-sql

From Erik Jones
Subject Re: Problem with FOREIGN KEY
Date
Msg-id 4C22A975-793B-42A6-911C-85ABDDCEAF64@myemma.com
Whole thread Raw
In response to Problem with FOREIGN KEY  ("Вадим Жерновой |Vadim Zhernovoi|" <vadim.zhernovoi@gmail.com>)
List pgsql-sql
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





pgsql-sql by date:

Previous
From: "Вадим Жерновой |Vadim Zhernovoi|"
Date:
Subject: Problem with FOREIGN KEY
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Problem with FOREIGN KEY