pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
To: Drozdowski, Catharine I <Drozdowski.Catharine@emeryworld.com>
To: pgsql-sql@postgresql.org
Subject: Re: Foreign Key Implementation
Date: Wed, 5 Apr 2000 09:50:54 +0100
Message-ID: <007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk> (raw)
References: <B1F9E0D87882D21182F8006094519AD80455A760@mwabs021.emeryworld.com>
	<15435.000405@webclub.ru>

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" <avm@webclub.ru>
To: "Drozdowski, Catharine I" <Drozdowski.Catharine@emeryworld.com>;
<pgsql-sql@postgresql.org>
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: <www.etcompany.ru><www.businessweb.ru>
> <www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>>
> mail_to: <avm@webclub.ru><nick_as: <cureman>>>>
>
>
>




view thread (9+ messages)  latest in thread

Message-ID: <007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk>
Permalink:  ../007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk/
Also on:    postgresql.org/message-id/007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: moray.mcconnachie@computing-services.oxford.ac.uk, Drozdowski.Catharine@emeryworld.com
  Subject: Re: Foreign Key Implementation
  In-Reply-To: <007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk>
  References: <B1F9E0D87882D21182F8006094519AD80455A760@mwabs021.emeryworld.com> <15435.000405@webclub.ru> <007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox