Re: [GENERAL] foreign key

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.