Re: postgreSQL foreign key constraint - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: postgreSQL foreign key constraint
Date
Msg-id 35C20B32.E86197B5@jpl.nasa.gov
Whole thread Raw
List pgsql-hackers
> 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

pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] OR clause status report
Next
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] OR clause status report - working