pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
sql 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