From: | "Moray McConnachie" <moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk> |
---|---|
To: | "Drozdowski, Catharine I" <Drozdowski(dot)Catharine(at)emeryworld(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Foreign Key Implementation |
Date: | 2000-04-05 08:50:54 |
Message-ID: | 007301bf9edc$0d87caa0$760e01a3@oucs.ox.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk
----- Original Message -----
From: "Alexey V. Meledin" <avm(at)webclub(dot)ru>
To: "Drozdowski, Catharine I" <Drozdowski(dot)Catharine(at)emeryworld(dot)com>;
<pgsql-sql(at)postgresql(dot)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(at)webclub(dot)ru><nick_as: <cureman>>>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey V. Meledin | 2000-04-05 09:20:23 | Re[2]: planner/optimizer hash index method and so on |
Previous Message | Kovacs Zoltan Sandor | 2000-04-05 08:25:27 | Re: Foreign Key Implementation |