X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 727E8D1B505 for ; Mon, 13 Oct 2003 08:56:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 49051-08 for ; Mon, 13 Oct 2003 05:55:49 -0300 (ADT) Received: from n29.grp.scd.yahoo.com (n29.grp.scd.yahoo.com [66.218.66.85]) by svr1.postgresql.org (Postfix) with SMTP id EFCF2D1B503 for ; Mon, 13 Oct 2003 05:55:45 -0300 (ADT) X-eGroups-Return: sentto-2458782-117-1066035347-pgsql-sql=postgresql.org@returns.groups.yahoo.com Received: from [66.218.67.194] by n29.grp.scd.yahoo.com with NNFMP; 13 Oct 2003 08:55:47 -0000 X-Sender: stefan@urkman.de X-Apparently-To: postgres@yahoogroups.de Received: (qmail 46325 invoked from network); 13 Oct 2003 08:55:45 -0000 Received: from unknown (66.218.66.218) by m12.grp.scd.yahoo.com with QMQP; 13 Oct 2003 08:55:45 -0000 Received: from unknown (HELO anrath.info) (217.160.130.42) by mta3.grp.scd.yahoo.com with SMTP; 13 Oct 2003 08:55:45 -0000 Received: (qmail 19156 invoked by uid 1047); 13 Oct 2003 08:55:43 -0000 Received: from pd9540be6.dip.t-dialin.net (HELO sturmxp) (217.84.11.230) by anrath.info with SMTP; 13 Oct 2003 08:55:43 -0000 To: X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <003b01c371f9$9b9933d0$0200a8c0@sturmxp> Thread-Index: AcORZ7lIFzBN7NCmQtukrPLnK2HIQQ== From: "Stefan Sturm" MIME-Version: 1.0 Mailing-List: list postgres@yahoogroups.de; contact postgres-owner@yahoogroups.de Precedence: bulk Date: Mon, 13 Oct 2003 10:55:17 +0200 Subject: [postgres] Foreign Key Reply-To: postgres@yahoogroups.de Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Message-Id: <20031013085545.EFCF2D1B503@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/140 X-Sequence-Number: 15540 Hallo zusammen, ich w=FCrde gerne folgenden Foreign Key in meine DB einbauen. Leider bekomme ich immer eine Fehlermeldung. Hier die Situation: Ich habe 2 Tabellen: status: ID Numeric Name Text logins: ID Numeric Name Text Status__id Numeric In der Tabelle status befinden sich Datens=E4tze. Die Tabelle logins ist leer. Nun versuche ich folgenden Befehl: ALTER TABLE "public"."login " ADD CONSTRAINT "test" FOREIGN KEY ("status__id") REFERENCES "public"."status"("id") ON DELETE RESTRICT ON UPDATE RESTRICT NOT DEFERRABLE; Jetzt bekomme ich immer die Fehlermeldung: ERROR: Query was cancelled. Und das war auch schon alles. Kann mir da einer Helfen? Danke und Gr=FC=DFe, Stefan Sturm PS: Ich mache das ganze mit dem Programm EMS PostgreSQL Manager Version 1.8.0.1 Wenn Sie Ihr Abonnement fuer diese Gruppe kuendigen moechten, senden=20 Sie eine E-Mail an: postgres-unsubscribe@egroups.de =20 Die Nutzung von Yahoo! Groups ist Bestandteil von http://de.docs.yahoo.com/= info/utos.html=20