Re: [SQL] sql foregein key

2000-06-13 Thread Jan Wieck
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

Re: [SQL] sql foregein key

2000-06-12 Thread Herbert Rabago Ambos
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:

[SQL] sql foregein key

2000-06-12 Thread GANESH KUMAR
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