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