What's the situation with foreign keys? Do we have them in 6.5?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

Thu, 10 Jun 1999 11:40:27 +0200
Michael Meskes <meskes@postgresql.org>
Foreign Keys
> What's the situation with foreign keys? Do we have them 
> in 6.5?

Not natively. You can enforce referential integrity using procedures;
I think the contrib area has examples (but I'll bet you already knew
that).

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Thu, 10 Jun 1999 14:25:06 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] Foreign Keys
Thomas Lockhart wrote:
> 
> > What's the situation with foreign keys? Do we have them
> > in 6.5?
> 
> Not natively. You can enforce referential integrity using procedures;
> I think the contrib area has examples (but I'll bet you already knew
> that).

But unfortunately, in 6.5 one should use SHARE/SHARE ROW EXCLISIVE
locks when using refint.c, as described in release notes.

Vadim

Thu, 10 Jun 1999 22:37:13 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] Foreign Keys