Received: from holmes.infopro.spb.su (holmes.infopro.spb.su [195.242.2.2]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA29146 for ; Wed, 5 Apr 2000 02:25:17 -0400 (EDT) (envelope-from avm@webclub.ru) Received: from barrymore.peterlink.ru (barrymore.peterlink.ru [195.242.2.8]) by holmes.infopro.spb.su (8.9.1/8.9.1) with ESMTP id KAA20492; Wed, 5 Apr 2000 10:25:14 +0400 (MSD) Received: from turtle.interforge.ru (interforge.dialup.peterlink.ru [195.242.31.96]) by barrymore.peterlink.ru (8.9.1/8.9.1) with ESMTP id KAA06857; Wed, 5 Apr 2000 10:25:10 +0400 (MSD) Date: Wed, 5 Apr 2000 10:27:14 +0400 From: "Alexey V. Meledin" X-Mailer: The Bat! (v1.36) S/N F29DEE5D / Educational Reply-To: "Alexey V. Meledin" Organization: InterForge Developers Group, Spb X-Priority: 3 (Normal) Message-ID: <15435.000405@webclub.ru> To: "Drozdowski, Catharine I" , pgsql-sql@postgresql.org Subject: Re: Foreign Key Implementation In-reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/38 Hi, I! Wednesday, April 05, 2000, 3:19:56 AM, you wrote: DCI>But I need to know how to implement foreign keys using postgres. I did not find anything in the DCI> documentation and several searches on "foreign" key produced nothing. There is no way to implement foreign keys. Data will always be copy when you'll try to pass it as FK. DCI> Does Postgres have foreign key functionality. And if not why and when??? postgresql 7.0 coming So, with posgres 6.* you can implement only relational integrity. I Use Erwin and it's macroses to implement automatic RI creation. Regards, Alexey V. Meledin InterForge Developers Group, Saint-Petersburg look_to: >>>>>>>>>>>>>>>> mail_to: >>>