| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | "Henning(dot)Baldersheim(at)devoll(dot)no" <Henning(dot)Baldersheim(at)devoll(dot)no> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: INHERITS and Foreign keys |
| Date: | 2003-12-13 19:55:17 |
| Message-ID: | 20031213115043.C11737@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sat, 13 Dec 2003, Henning(dot)Baldersheim(at)devoll(dot)no wrote:
> Hi
>
> I have some problem with INHERITS and foreign keys. I do not know if I have
> not got the clue or not. Anyway I have tried to simplify the problem so
> that you can guide me on the right track.
Foreign keys, unique and primary key constraints do not meaningfully
inherit currently. At some point in the future, that's likely to change,
but for now you're pretty much stuck with workarounds (for example, using
a separate table to store the ids and triggers/rules on each of the tables
in the hierarchy in order to keep the id table in date.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henning.Baldersheim@devoll.no | 2003-12-13 21:07:57 | Re: INHERITS and Foreign keys |
| Previous Message | Henning.Baldersheim@devoll.no | 2003-12-13 19:43:44 | INHERITS and Foreign keys |