Thread

1. foreign key

   soundar rajan <psrajan@yahoo.com> — 1999-10-27T19:12:35Z

   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
   
   

2. Re: [GENERAL] foreign key

   Brett W. McCoy <bmccoy@lan2wan.com> — 1999-10-27T20:21:24Z

   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.