Re: [BUG?] table inhiritance violates primary key

From: Sven Köhler <skoehler(at)upb(dot)de>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [BUG?] table inhiritance violates primary key
Date: 2003-06-25 14:38:33
Message-ID: 3EF9B3E9.7020009@upb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Table inheritance is fairly broken right now. Foreign keys and unique
> constraints (including primary key) don't inherit to children, you can't
> even get the effect that is generally desired by putting a separate
> constraint on the child table since then the parent and the child could
> each insert a 1 value. Workarounds have been discussed in the past, so
> you can probably find details in the archives. There was also talk
> recently about multi-table indexes on either general or hackers, so you
> can find that discussion as well for more info.

I'm very disappointed now. Table inheritance was the feature that
attracted me the most. Is it currently an experimental feature? Is it a
goal to achieve stability for future versions of postgresql? Which
version might be first with stable table inheritance?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-25 14:40:53 Re: [GENERAL] capturing and storing query statement with rules
Previous Message Bruce Momjian 2003-06-25 14:33:03 Re: Determining table size