| From: | Garrett Kalleberg <experimental(at)metadada(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: foreign key constraints and inheritence |
| Date: | 2005-07-17 12:59:43 |
| Message-ID: | 512490CE-5C44-40B9-B464-6AE76AB064EE@metadada.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jul 17, 2005, at 5:35 AM, Michael Fuhr wrote:
> See the inheritance documentation:
>
> http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
>
> "A serious limitation of the inheritance feature is that indexes
> (including unique constraints) and foreign key constraints only
> apply to single tables, not to their inheritance children. This
> is true on both the referencing and referenced sides of a foreign
> key constraint."
I think I was just in denial. I'd read it some time ago, but
yesterday I just didn't want to believe it.
What I'd like to believe: that all behaviors (i.e. constraints) are
inherited down the table hierarchy and may be overridden by
identically named behaviors lower in the hierarchy.
Garrett
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-07-17 14:12:48 | Re: foreign key constraints and inheritence |
| Previous Message | Sander Steffann | 2005-07-17 10:38:48 | Re: foreign key constraints and inheritence |