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