Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 086DB475DC0 for ; Thu, 12 Dec 2002 04:54:36 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 8B6A0475AE6 for ; Thu, 12 Dec 2002 04:54:35 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 736AD43A8FC; Thu, 12 Dec 2002 04:54:35 -0500 (EST) From: Huub X-Newsgroups: comp.databases.postgresql.sql Subject: Re: primary + foreign key Date: Thu, 12 Dec 2002 10:54:21 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 27 Message-ID: References: <3DF85C53.6010309@klaster.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en In-Reply-To: <3DF85C53.6010309@klaster.net> To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/151 X-Sequence-Number: 10739 Thanks for pointing out. I'm not that experienced in SQL yet; so detail could as well be some extra instruction and I've never seen 'references master' before. But I think I'll manage now. Thanks Tomasz Myrta wrote: > Huub wrote: > > >>Hi, >> >>I suppose 'detail' is the table name? And what is master? >> >>Thanks >> >>Huub > > > You should know that. > Detail is a table you want to create and master is a table where foreign > key points to. > > Tomasz Myrta > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster