Re: sql foregein key

From: Herbert Rabago Ambos <herbert(at)hindang(dot)msuiit(dot)edu(dot)ph>
To: GANESH KUMAR <itsganesh(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: sql foregein key
Date: 2000-06-13 13:43:03
Message-ID: Pine.LNX.4.10.10006132139150.2266-100000@hindang.msuiit.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emils Klotins 2000-06-13 14:42:05 Q:Postgres 7.0 & Access'97?
Previous Message rocael 2000-06-13 12:11:40 dump from access to pg on linux