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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
