Re: FK to inherited table, referential integrity violation

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: <yacht(at)seznam(dot)cz>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: FK to inherited table, referential integrity violation
Date: 2003-08-20 19:11:19
Message-ID: 20030820120932.S13175-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 20 Aug 2003 yacht(at)seznam(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2003-08-20 19:13:31 Re: Mail server load
Previous Message Ron Johnson 2003-08-20 19:02:59 Re: Grouping by date range