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® [EMAIL PROTECTED] 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
