| From: | Sbob <sbob(at)quadratum-braccas(dot)com> | 
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> | 
| Subject: | Local parent table and Foreign table(s) as partition(s), is it possible? | 
| Date: | 2022-09-14 17:41:24 | 
| Message-ID: | 25206e71-b388-3c51-ce17-5fd0912398eb@quadratum-braccas.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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|
    <https://www.postgresql.org/docs/current/sql-createtable.html> 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|
    <https://www.postgresql.org/docs/current/sql-createtable.html> 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|
    <https://www.postgresql.org/docs/current/sql-altertable.html>.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-09-14 18:01:11 | Re: Local parent table and Foreign table(s) as partition(s), is it possible? | 
| Previous Message | Alvaro Herrera | 2022-09-13 11:11:14 | Re: Error when execute insert/update |