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