Re: BUG #15724: Can't create foreign table as partition

On Thu, Jun 20, 2019 at 6:07 AM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

>
>
> With this patch, an index creation will no longer fail in the presence
> of a partition that is a foreign table, as long as the index is not a
> constraint index (not unique, not primary key). Conversely,
> creating/attaching a partition that is a foreign table does not fail if
> the partitioned table only has non-constraint indexes.
>
>
Like others suggested above, I also think that we should make this is a
no-op on the foreign tables i.e. not fail even when there exists a UNIQUE
or PRIMARY KEY on the parent table. We simply assume that the appropriate
constraints will be defined on the foreign side and violations will be
caught. This is same as CHECK constraints on the foreign partitions, that
we assume the foreign server will enforce.

Thanks,
Pavan

--
Pavan Deolasee http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services