From: | Ketema Harris <ketema(at)ketema(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Inherited FK Indexing |
Date: | 2007-09-14 15:35:31 |
Message-ID: | 93F5BA88-AB62-494D-84E6-DD4BFCFAE008@ketema.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the following table set up:
CREATE TABLE states
(
state_id integer NOT NULL DEFAULT nextval
('state_province_id_seq'::regclass),
state character(2),
full_name character varying,
timezone character varying,
CONSTRAINT "PK_state_id" PRIMARY KEY (state_id)
)
CREATE TABLE canadian_provinces
(
-- Inherited: state_id integer NOT NULL DEFAULT nextval
('state_province_id_seq'::regclass),
-- Inherited: state character(2),
-- Inherited: full_name character varying,
-- Inherited: timezone character varying,
CONSTRAINT "PK_province_id" PRIMARY KEY (state_id)
)
as expected I can do select * from states and get everything out of
the child table as well. What I can't do is create a FK to the
states table and have it look in the child table as well. Is this on
purpose? Is it possible to have FK that spans into child tables?
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-09-14 15:54:02 | Re: Documentation fix regarding atan2 |
Previous Message | Mike Charnoky | 2007-09-14 15:19:14 | Re: problems with large table |