Re: Foreign key references now fails with inherited columns

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: Foreign key references now fails with inherited columns
Date: 2000-10-27 01:24:41
Message-ID: Pine.BSF.4.10.10010261821370.29560-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 26 Oct 2000, Oliver Elphick wrote:

> The following sequence, which works in 7.0.2, now fails in current
> sources:

> [example snipped]
>
> I think this means that the FOREIGN KEY installer thinks that table
> "individual" does not have columns "id" and "address", which are
> inherited from "person". However, if this is correct, the wording of the
> error message is poorly chosen, since it seems to refer to the columns
> mentioned after the REFERENCES keyword.

Yeah, that is what it means, and yes, that was probably a bad choice of
wording (will fix that too). Hmm, without looking (no access to code from
work unless I get another copy), that probably means that the list of
columns in the function doesn't get those columns (at least by that
point).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-10-27 02:31:50 Re: more multibyte/After TGL...
Previous Message Kevin O'Gorman 2000-10-27 01:05:05 Select syntax (broken in current CVS tree)