Обсуждение: foreign key

Hi all,

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

the error message points to "foreign" key.  Can any
one help me in this solving theis problem.






=====
Thanks.
Soundar.
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

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.