From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | soundar rajan <psrajan(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] foreign key |
Date: | 1999-10-27 20:21:24 |
Message-ID: | Pine.BSI.3.91.991027161916.8846M-100000@access1.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 27 Oct 1999, soundar rajan wrote:
> Can any one please let me know the alternative of
> "foreign key" referential integrity. I'v pg 6.5.2
> under Linux. I'm not able to use the foreign key
> reference. when I say "create table emp (id int, dno
> int foreign key references dept(dno));
Foreign keys are fully implemented yet. You can implement them with a
trigger and the loadable procedure under the contrib directory in the
source distribution. I believe it is under the spi directory there.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
I really hate this damned machine
I wish that they would sell it.
It never does quite what I want
But only what I tell it.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Drabble | 1999-10-28 03:29:06 | Admin details - disk space used |
Previous Message | David Sauer | 1999-10-27 19:17:27 | problem with date |