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>>>>
>
>
>