Обсуждение: Foreign Keys

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!

> 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

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