Re: Needless additional partition check in INSERT?

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Needless additional partition check in INSERT?
Дата
Msg-id CAKJS1f8gw4k+B3hLKRppYaspW+uM5PDu6nYbK=YhdtC5kkHKMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Needless additional partition check in INSERT?  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Needless additional partition check in INSERT?  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
On 10 May 2018 at 21:56, David Rowley <david.rowley@2ndquadrant.com> wrote:
> On 10 May 2018 at 17:42, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Patch is good.
>>
>> The cause of this oversight is the lack of comments to explain the
>> original coding, so we need to correct that in this patch, please.
>
> Thanks for looking.
>
> Yeah, the comments do need work. In order to make it a bit easier to
> document I changed the way that check_partition_constr is set. This is
> now done with an if/else if/else clause for both COPY and INSERT.
>
> Hopefully, that's easier to understand and prevents further mistakes.
>
> Patch attached.

While this does not cause any undesired behaviour, I think it's quite
clear that it's unintended, so I've added this to the v11 open items
list.

If there's consensus that this is not the case then we can remove it
from the list. I've just added it to ensure that a proper evaluation
has been done.

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


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [GSoC] Question about returning bytea array
Следующее
От: Amit Langote
Дата:
Сообщение: Re: postgres_fdw: Oddity in pushing down inherited UPDATE/DELETEjoins to remote servers