Local parent table and Foreign table(s) as partition(s), is it possible?

Поиск
Список
Период
Сортировка
От Sbob
Тема Local parent table and Foreign table(s) as partition(s), is it possible?
Дата
Msg-id 25206e71-b388-3c51-ce17-5fd0912398eb@quadratum-braccas.com
обсуждение исходный текст
Ответы Re: Local parent table and Foreign table(s) as partition(s), is it possible?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin

All;


I see the below options in the CREATE FOREIGN TABLE, however I assume these would both connect to a master/parent table on the foreign server. Is it possible to have a Foreign Table that acts as a partition of a local parent table, via either method (INHERITS or PARTITION OF)?


Thanks in advance...


INHERITS ( parent_table [, ... ] )

The optional INHERITS clause specifies a list of tables from which the new foreign table automatically inherits all columns. Parent tables can be plain tables or foreign tables. See the similar form of CREATE TABLE for more details.

PARTITION OF parent_table { FOR VALUES partition_bound_spec | DEFAULT }

This form can be used to create the foreign table as partition of the given parent table with specified partition bound values. See the similar form of CREATE TABLE for more details. Note that it is currently not allowed to create the foreign table as a partition of the parent table if there are UNIQUE indexes on the parent table. (See also ALTER TABLE ATTACH PARTITION.)


В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Error when execute insert/update
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Local parent table and Foreign table(s) as partition(s), is it possible?