Re: [HACKERS] Foreign tables don't enforce the partition constraint

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: [HACKERS] Foreign tables don't enforce the partition constraint
Дата
Msg-id 4c7579cd-9d96-72ff-69a1-2e0e71e61a0d@lab.ntt.co.jp
обсуждение исходный текст
Список pgsql-hackers
On 2017/04/03 16:44, Amit Langote wrote:
> Hi Ashutosh,
> 
> On 2017/04/03 15:49, Ashutosh Bapat wrote:
>>>> Similarly, a partition constraint
>>>> should also be enforced at the foreign server. Probably we should
>>>> update documentation of create foreign table to mention this.
>>>
>>> That is a good idea.
>>>
>>> Here's the patch.
> 
> Thanks for creating the patch.
> 
> +    Constraints and partition bounds on foreign tables (such as
> 
> We use "partition constraint" instead of "partition bounds" to mean the
> implicit constraint of a partition (there are a few instances of that in
> the documentation).  So, perhaps this could be written as: Constraints
> (both the user-defined constraints such as <literal>CHECK</>
> or <literal>NOT NULL</> clauses and the partition constraint) are not
> enforced by the core <productname>PostgreSQL</> system, ...
> 
> And once we've mentioned that a constraint means one of these things, we
> need not repeat "partition bounds/constraints" in the subsequent
> paragraphs.  If you agree, attached is the updated patch.

Since it seems that we agree that this documentation tweak is good idea, I
will add this to the open items list to avoid it being missed.

Thanks,
Amit





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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] No-op case in ExecEvalConvertRowtype
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] Interval for launching the table sync worker