Inherited FK Indexing
От | Ketema Harris |
---|---|
Тема | Inherited FK Indexing |
Дата | |
Msg-id | 93F5BA88-AB62-494D-84E6-DD4BFCFAE008@ketema.net обсуждение исходный текст |
Ответ на | Partition Reindexing (Nik <XLPizza@gmail.com>) |
Ответы |
Re: Inherited FK Indexing
Re: Inherited FK Indexing Re: Inherited FK Indexing Re: Inherited FK Indexing |
Список | 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
В списке pgsql-general по дате отправления: