| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Andrew Snow <andrew(at)modulus(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inheritance & Referential Integrity |
| Date: | 2001-05-14 17:50:37 |
| Message-ID: | Pine.BSF.4.21.0105141044560.16214-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 14 May 2001, Andrew Snow wrote:
> I note that it still is not possible (v7.1.1) to have a table with a foreign
> key check on an inherited column for rows in child tables. Will this ever
> be supported, and what is the status of work on this feature?
It will eventually be supported. There's a bit of support work that needs
to come first (inherited unique constraints) and a fair amount of work on
the fk stuff itself. I think that getting the fk to completely work on
normal tables (there are still some problem cases with deferred
constraints and the constraints really should be referencing
oids and shouldn't use a self-conflicting lock for locking rows) probably
happens first.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Crute | 2001-05-14 17:59:38 | Re: problems with timestamp fields |
| Previous Message | Stuart Foster | 2001-05-14 17:07:19 | How to save images in a table. |