Message-ID: <45F1547F.4070105@archonet.com>
Date: Fri, 09 Mar 2007 12:35:11 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: IceDove 1.5.0.9 (X11/20061220)
MIME-Version: 1.0
To: Moritz Kobel <mailinglists@weisshorn.kobelnet.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: Table inherit & foreign key problem
References: <20070309114303.GC12129@alvier.kobelnet.intra>
In-Reply-To: <20070309114303.GC12129@alvier.kobelnet.intra>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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