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  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Inherited FK Indexing  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Inherited FK Indexing  (Erik Jones <erik@myemma.com>)
Re: Inherited FK Indexing  (Markus Schiltknecht <markus@bluegap.ch>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Documentation fix regarding atan2
Следующее
От: Panagiotis Pediaditis
Дата:
Сообщение: Re: Locking entire database