Обсуждение: sql foregein key

sir ,
   i am working 6.5.2 postgresql 
in creation foregein key in table 

syntax i am writing is
1)create table gk
(sno  int primary key);

2)create table kk
(sno int references gk,
sname varchar(2));
i am getting message like this foregein key is not
implemented .
please write which version it supports .
please send reply assp

ganesh 

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com

You need too add the library 'refint.so', which is included
in the package (prior to v7).  But you have to explicitly write a trigger
in order to do this.  Refer to the docs for more info.

However this problem is solved when you migrate to v7.

herbert

On Mon, 12 Jun 2000, GANESH KUMAR wrote:

> 
> sir ,
> 
>     i am working 6.5.2 postgresql 
> in creation foregein key in table 
> 
> syntax i am writing is
> 1)create table gk
> (sno  int primary key);
> 
> 2)create table kk
> (sno int references gk,
> sname varchar(2));
> i am getting message like this foregein key is not
> implemented .
> please write which version it supports .
> please send reply assp
> 
> ganesh 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> 

GANESH KUMAR wrote:
>
> sir ,
>
>     i am working 6.5.2 postgresql
> in creation foregein key in table
>
> syntax i am writing is
> 1)create table gk
> (sno  int primary key);
>
> 2)create table kk
> (sno int references gk,
> sname varchar(2));
> i am getting message like this foregein key is not
> implemented .
> please write which version it supports .
> please send reply assp
   FOREIGN KEY is implemented in v7.0.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #