Thread

Re: postgreSQL foreign key constraint

Thomas Lockhart <thomas.lockhart@jpl.nasa.gov> — 1998-07-31T18:21:39Z

> how can I workaround a foreign key constraint (maybe using check constraint?, how?)
> when do you think foreign key constraint will be implemented?

It's best to post questions to the Postgres mailing lists, since others
may have better answers than I. However, I think you can use "triggers"
to mimic foreign key constraints. Look in the "contrib" area of the
distribution for examples. There is a change foreign keys will be in
v6.5, perhaps in 6 months. There was talk of possibly having it earlier,
but I do not have access to my Postgres e-mail at work and can't
remember if that is still true...

Good luck.

                          - Tom

-- 
Thomas Lockhart
Caltech/JPL
Interferometry Systems and Technology