On Tue, 22 Apr 2008 18:26:19 +0300 "????? ???????? |Vadim Zhernovoi|" <[EMAIL PROTECTED]> 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!
That message is not telling you the the referenced table doesn't have the field. It is saying that the referenced table does not have a matching row for one or more rows in the table being checked. In other words it is checking your existing data exactly the same as it will check new data that you insert. Your database is already violating the rule that you are trying to enforce with the new constraint. Also, I am pretty sure that you do not want the constraint FK1_SecurityRolePermission that you created on SecurityRole. What do you think that will accomplish? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql