Moritz Kobel wrote:
i would like to reference to the element table, because i have some
tables which inherit from element and i would like to add comments to
these elements.
is this impossible or did i do a silly mistake? i did not find a
solution unsing google.
Foreign-key limitations with inheritance I'm afraid. See the manuals for
details:
http://www.postgresql.org/docs/8.2/static/ddl-inherit.html
5.8.1 Caveats
...
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. Thus,
in the terms of the above example:
...
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
