Re: Foreign keys referencing parent table fails on insert

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: postgresbugs <postgresbugs(at)grifent(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Foreign keys referencing parent table fails on insert
Date: 2004-12-01 22:25:29
Message-ID: 20041201142344.G66421@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2004-12-02 04:41:49 oid2name core dump
Previous Message Tom Lane 2004-12-01 22:01:17 Re: Beta4 postgres.exe crash "...terminated by signal 5"