Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Re: Problem wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 3427 of 3717
Post > Topic >>

Re: Problem with FOREIGN KEY

by erik@[EMAIL PROTECTED] (Erik Jones) Apr 22, 2008 at 10:37 AM

On Apr 22, 2008, at 10:26 AM, =D0=92=D0=B0=D0=B4=D0=B8=D0=BC =D0=96=D0=B5=
=D1=80=D0=BD=D0=BE=D0=B2=D0=BE=D0=B9 |Vadim=20=20
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=20=
=20
doesn't satisfy the foreign key constraint, i.e. there is a Users
row=20=20
with SecurityRoleId=3D0 and no row in SecurityRole with ID=3D0.

Erik Jones

DBA | Emma=C2=AE
erik@[EMAIL PROTECTED]
 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
 




 3 Posts in Topic:
Problem with FOREIGN KEY
vadim.zhernovoi@[EMAIL PR  2008-04-22 18:26:19 
Re: Problem with FOREIGN KEY
erik@[EMAIL PROTECTED] (  2008-04-22 10:37:33 
Re: Problem with FOREIGN KEY
darcy@[EMAIL PROTECTED]   2008-04-22 12:01:42 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 14:35:42 CDT 2008.