| From: | Scott Goodwin <scott(at)scottg(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Inherited tables and column references |
| Date: | 2004-02-20 00:42:29 |
| Message-ID: | A960295A-633D-11D8-9E3E-000A95A0910A@scottg.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In the following example:
create table parent (
id integer unique not null,
name varchar(24)
);
create table child (
first_name varchar(256),
last_name varchar(256)
) inherits (parent);
create table relations (
id integer references child (id)
);
Creating the relations table fails with:
ERROR: there is no unique constraint maching given keys for
referenced table "child"
If I change the last table to:
create table relations (
id integer references parent (id)
);
it works.
This essentially means that references must point to the real table
where the referenced column is, and cannot point to that same column in
a table that inherits the real table.
is this by design, is it a bug, is it just not implemented yet, or am I
doing this wrong?
/s.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Patnude | 2004-02-20 03:28:01 | Re: Inherited tables and column references |
| Previous Message | Roopali Sharma | 2004-02-19 23:58:20 | Re: pg_restore problem |