Re: Foreign keys referencing parent table fails on insert

On Wed, 1 Dec 2004, Stephan Szabo wrote:

  On Wed, 1 Dec 2004, postgresbugs wrote:



    > Foreign keys referencing parent table fails on insert if the key is in
> the table that inherits the parent table.



Unfortunately, primary keys, unique constraints and foreign keys do not
inherit to children in a meaningful fashion. It's one of the big
deficiencies right now.




Too bad. Table inheritance is pretty meaningless without these
abilities. Anyone working on them? In the meantime, I will go back to
views and updating the underlying tables.