Re: [GENERAL] foreign key - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: [GENERAL] foreign key
Date
Msg-id Pine.BSI.3.91.991027161916.8846M-100000@access1.lan2wan.com
Whole thread Raw
In response to foreign key  (soundar rajan <psrajan@yahoo.com>)
List pgsql-general
On Wed, 27 Oct 1999, soundar rajan wrote:

> Can any one please let me know the alternative of
> "foreign key" referential integrity.  I'v pg 6.5.2
> under Linux.  I'm not able to use the foreign key
> reference.  when I say "create table emp (id int, dno
> int foreign key references dept(dno));

Foreign keys are fully implemented yet.  You can implement them with a
trigger and the loadable procedure under the contrib directory in the
source distribution.  I believe it is under the spi directory there.

Brett W. McCoy
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
I really hate this damned machine
I wish that they would sell it.
It never does quite what I want
But only what I tell it.


pgsql-general by date:

Previous
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] Auto Ordering
Next
From: Simon Drabble
Date:
Subject: Admin details - disk space used