Inherited tables and column references

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.

Responses

Browse pgsql-general by date

  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