Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9E2EF2E0052 for ; Tue, 22 Apr 2008 12:37:41 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90425-03 for ; Tue, 22 Apr 2008 12:37:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp176.iad.emailsrvr.com (smtp176.iad.emailsrvr.com [207.97.245.176]) by developer.postgresql.org (Postfix) with ESMTP id 37EB92E0046 for ; Tue, 22 Apr 2008 12:37:35 -0300 (ADT) Received: from relay7.relay.iad.mlsrvr.com (localhost [127.0.0.1]) by relay7.relay.iad.mlsrvr.com (SMTP Server) with ESMTP id 93B5A1B4342; Tue, 22 Apr 2008 11:37:34 -0400 (EDT) Received: by relay7.relay.iad.mlsrvr.com (Authenticated sender: erik-AT-myemma.com) with ESMTP id 6D4871B4191; Tue, 22 Apr 2008 11:37:34 -0400 (EDT) Cc: pgsql-sql@postgresql.org Message-Id: <4C22A975-793B-42A6-911C-85ABDDCEAF64@myemma.com> From: Erik Jones To: =?UTF-8?Q?=D0=92=D0=B0=D0=B4=D0=B8=D0=BC_=D0=96=D0=B5=D1=80?= =?UTF-8?Q?=D0=BD=D0=BE=D0=B2=D0=BE=D0=B9_|Vadim_Zhernovoi|?= In-Reply-To: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: Problem with FOREIGN KEY Date: Tue, 22 Apr 2008 10:37:33 -0500 References: <509ab3740804220826l685baaa3x1bd9cc4bd2a08f1@mail.gmail.com> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/143 X-Sequence-Number: 30682 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 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= doesn't satisfy the foreign key constraint, i.e. there is a Users row =20= with SecurityRoleId=3D0 and no row in SecurityRole with ID=3D0. Erik Jones DBA | Emma=C2=AE 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