Received: from oxmail.ox.ac.uk (oxmail2.ox.ac.uk [163.1.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA44732 for ; Wed, 5 Apr 2000 04:52:08 -0400 (EDT) (envelope-from moray.mcconnachie@computing-services.oxford.ac.uk) Received: from ermine.ox.ac.uk ([163.1.2.13]) by oxmail.ox.ac.uk with esmtp (Exim 3.12 #1) id 12clXc-0003kA-00; Wed, 05 Apr 2000 09:52:00 +0100 Received: from ermine.ox.ac.uk ([163.1.2.13] helo=moraypc ident=root) by ermine.ox.ac.uk with smtp (Exim 3.13 #1) id 12clXc-0001im-00; Wed, 05 Apr 2000 09:52:00 +0100 Message-ID: <007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk> From: "Moray McConnachie" To: "Drozdowski, Catharine I" , References: <15435.000405@webclub.ru> Subject: Re: Foreign Key Implementation Date: Wed, 5 Apr 2000 09:50:54 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200004/40 But don't forget that in 7.0, which we see is hopefully coming in ten days' time, foreign keys are almost entirely supported. Look at the mailing list of pgsql-general for last month, and see several people replying to a question I posted with the syntax... Yrs, Moray ---------------------------------------------------------------- Moray.McConnachie@computing-services.oxford.ac.uk ----- Original Message ----- From: "Alexey V. Meledin" To: "Drozdowski, Catharine I" ; Sent: Wednesday, April 05, 2000 7:27 AM Subject: Re: [SQL] Foreign Key Implementation > 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: >>> > > >