Re: FK to inherited table, referential integrity violation - Mailing list pgsql-general

From Stephan Szabo
Subject Re: FK to inherited table, referential integrity violation
Date
Msg-id 20030820120932.S13175-100000@megazone.bigpanda.com
Whole thread Raw
In response to FK to inherited table, referential integrity violation  (yacht@seznam.cz)
List pgsql-general
On Wed, 20 Aug 2003 yacht@seznam.cz wrote:

> Is it bug?

Just an unimplemented feature. Foreign keys currently reference only
the named table and not any of the subtables.  Inheritance has some
serious limitations right now (for example, the primary key on base
doesn't inherit to child as well which means you can insert multiple
rows with the same key into child).  If you want the gory details, this
comes up every few months so there are lots of discussions in the
archives.


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Grouping by date range
Next
From: The Hermit Hacker
Date:
Subject: Re: Mail server load