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.