Date: Tue, 22 Apr 2008 12:01:42 -0400
From: "D'Arcy J.M. Cain" <darcy@druid.net>
To: =?ISO-8859-1?Q?"=3F=3F=3F=3F=3F_=3F=3F=3F=3F=3F=3F=3F=3F_|Vadim_Zherno?=
	=?ISO-8859-1?Q?voi|"?= <vadim.zhernovoi@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with FOREIGN KEY
Message-Id: <20080422120142.c87d8f04.darcy@druid.net>
In-Reply-To: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com>
References: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, 22 Apr 2008 18:26:19 +0300
"????? ???????? |Vadim Zhernovoi|" <vadim.zhernovoi@gmail.com> 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?

--=20
D'Arcy J.M. Cain <darcy@druid.net>         |  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.