| 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: | Whole Thread | Raw Message | 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).
| 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) |