table inheritance and foreign key troubles

From: Kevin Way <kevin(dot)way(at)overtone(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: table inheritance and foreign key troubles
Date: 2001-09-11 08:04:52
Message-ID: 20010911080452.A76783@bean.overtone.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm having a little trouble with some inherited tables and a foreign key. Here's
a simplified case, to show the trouble.

CREATE TABLE node (
node_id SERIAL NOT NULL,
name TEXT NOT NULL,
PRIMARY KEY (node_id)
);
-- works just fine

CREATE TABLE users (
email TEXT NOT NULL
) INHERITS (node);
-- so far so good....

CREATE TABLE item (
reason TEXT NOT NULL,
author_id INT NOT NULL REFERENCES users (node_id)
) INHERITS (node);
ERROR: UNIQUE constraint matching given keys for referenced table "users" not found

Does this operation just require differing syntax, because the referenced field
is inherited from another table, or is this not possible?

Kevin Way

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Miguel González 2001-09-11 08:41:42 SQL Query
Previous Message Jan Wieck 2001-09-11 07:08:31 Re: calling a shell script from pl/pgsql