Received: from mailout03.sul.t-online.com (mailout03.sul.t-online.com [194.25.134.81]) by hub.org (8.10.1/8.10.1) with ESMTP id e5DAjTT79448 for ; Tue, 13 Jun 2000 06:45:30 -0400 (EDT) Received: from fwd02.sul.t-online.de by mailout03.sul.t-online.com with smtp id 131oCG-0003S6-01; Tue, 13 Jun 2000 12:45:28 +0200 Received: from hot.jw.home (340000654369-0001@[62.224.101.65]) by fwd02.sul.t-online.de with esmtp id 131oC0-0pGnMuC; Tue, 13 Jun 2000 12:45:12 +0200 Received: (from wieck@localhost) by hot.jw.home (8.8.5/8.8.5) id LAA03468; Tue, 13 Jun 2000 11:58:13 +0200 From: JanWieck@t-online.de (Jan Wieck) Message-Id: <200006130958.LAA03468@hot.jw.home> Subject: Re: sql foregein key In-Reply-To: <20000613044318.5071.qmail@web1103.mail.yahoo.com> from GANESH KUMAR at "Jun 12, 2000 09:43:18 pm" To: GANESH KUMAR Date: Tue, 13 Jun 2000 11:58:13 +0200 (MEST) CC: pgsql-sql@postgresql.org Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sender: 340000654369-0001@t-dialin.net X-Archive-Number: 200006/140 GANESH KUMAR wrote: > > sir , > > i am working 6.5.2 postgresql > in creation foregein key in table > > syntax i am writing is > 1)create table gk > (sno int primary key); > > 2)create table kk > (sno int references gk, > sname varchar(2)); > i am getting message like this foregein key is not > implemented . > please write which version it supports . > please send reply assp FOREIGN KEY is implemented in v7.0. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #