Re: Foreign keys on inherited attributes

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Shawn Harrison <harrison(at)tbc(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign keys on inherited attributes
Date: 2004-01-27 14:50:16
Message-ID: 20040127064802.X61306@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 26 Jan 2004, Shawn Harrison wrote:

> I'm using pg 7.3.5 and playing with table inheritance, and I've run into the
> fact that foreign keys cannot be defined on inherited attributes. (As much
> is stated in the documentation, but it didn't sink in until I ran into the
> fact.)
>
> The documents say this will probably be fixed in a future release. My
> question is, are there any definite plans in that direction at this point?

AFAIK, there's nobody actively looking at dealing with the various
constraint/inheritance issues at this point.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Uros 2004-01-27 15:10:48 dynamic queries
Previous Message Simon Riggs 2004-01-27 14:49:57 Re: Recursive optimization of IN subqueries