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 41B0AC88.8000802@grifent.com
Whole thread Raw
In response to Re: Foreign keys referencing parent table fails on insert  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Stephan Szabo wrote:
<blockquote cite="mid20041202203001.L37573@megazone.bigpanda.com"
 type="cite">
  On Thu, 2 Dec 2004, postgresbugs wrote:



     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.



There's noone actively working on it at the moment that I know of (and if
there is, hopefully they'll see this and correct me) although I believe
there was some noise in the last dev cycle of people thinking about the
unique (and pkey) side of it.


Thanks. I would think that if the primary and unique keys worked
properly the foreign key problem would just fall out naturally. I would
volunteer for this except I do all my programing in JAVA these days and
my C and C++ are too rusty to be useful.

I hope someone picks this up. It would go a long way in doing away with
the problems of views and inserts and updates.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: "invalid memory alloc request size " in deferred trigger causes transaction to fail, but the backend keeps running
Next
From: Peter Eisentraut
Date:
Subject: Re: [Fwd: Bug#283856: postgresql: mistakes in src/backend/po/fr.po]