Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group