Thread: 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