Re: Foreign keys referencing parent table fails on insert - Mailing list pgsql-bugs

From postgresbugs
Subject Re: Foreign keys referencing parent table fails on insert
Date
Msg-id 41AF4720.3020503@grifent.com
Whole thread Raw
In response to Foreign keys referencing parent table fails on insert  (postgresbugs <postgresbugs@grifent.com>)
Responses Re: Foreign keys referencing parent table fails on insert  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Column names: where, group by, having inconsistent behaviour?
Next
From: Bruce Momjian
Date:
Subject: Re: [pgsql-hackers-win32] PLTCL