Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C04BB2E364B for ; Tue, 11 Dec 2007 14:53:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 45475-02-2 for ; Tue, 11 Dec 2007 14:53:36 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.174]) by postgresql.org (Postfix) with ESMTP id 9F0A62E3630 for ; Tue, 11 Dec 2007 14:53:35 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis) id 0ML2xA-1J2AEV2FV6-00030k; Tue, 11 Dec 2007 19:53:34 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1J2AEU-0004Fz-00 for pgsql-sql@postgresql.org; Tue, 11 Dec 2007 19:53:30 +0100 Date: Tue, 11 Dec 2007 19:53:30 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Foreign Key for multi PK or design question Message-ID: <20071211185330.GA16159@a-kretschmer.de> References: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> <475ED504.7080006@productivitymedia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <475ED504.7080006@productivitymedia.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1+/QKQvu/s5GI5+iIkDq62L5baRxShwSnqPSdy egalwok0qkprMS368m+29wLAiUY/fOnui0Ja40JEaZacaW2+m9 1RJCCSskPye9UUq5HArhmJMveN0WiFa X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/53 X-Sequence-Number: 29745 am Tue, dem 11.12.2007, um 13:20:52 -0500 mailte PostgreSQL Admin folgendes: > I have a table in which people will have a number of questions to > answer. I want those pk to be placed in my user table. So if a user > answers three question I want those 3 pk's in the user table (fk). > What should I be doing? Explain your problem a little bit more. We need your table-design, for instance. Nobody can help you without more informations. Maybe you are searching for current_user, but i'm not sure. Btw.: Please don't hijack other threads, this problems was a topic on this¹ list today. Your email contains a References: - Header, and you are using Thunderbird. I think, you can understand me what i mean. If yo want to create a new topic, create a *new* mail and don't answer to an existing mail by changing the subject. ¹ it was the [General]-List, sorry Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net