pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsql foregein key
3+ messages / 3 participants
[nested] [flat]
* sql foregein key
@ 2000-06-13 04:43 GANESH KUMAR <itsganesh@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: GANESH KUMAR @ 2000-06-13 04:43 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: sql foregein key
@ 2000-06-13 09:58 Jan Wieck <JanWieck@t-online.de>
parent: GANESH KUMAR <itsganesh@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: JanWieck@t-online.de @ 2000-06-13 09:58 UTC (permalink / raw)
To: GANESH KUMAR <itsganesh@yahoo.com>; +Cc: pgsql-sql
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 #
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: sql foregein key
@ 2000-06-13 13:43 Herbert Rabago Ambos <herbert@hindang.msuiit.edu.ph>
parent: GANESH KUMAR <itsganesh@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Herbert Rabago Ambos @ 2000-06-13 13:43 UTC (permalink / raw)
To: GANESH KUMAR <itsganesh@yahoo.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-06-13 13:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-13 04:43 sql foregein key GANESH KUMAR <itsganesh@yahoo.com>
2000-06-13 09:58 ` Jan Wieck <JanWieck@t-online.de>
2000-06-13 13:43 ` Herbert Rabago Ambos <herbert@hindang.msuiit.edu.ph>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox