[HACKERS] fix empty array expression in get_qual_for_list()

Поиск
Список
Период
Сортировка
От Jeevan Ladhe
Тема [HACKERS] fix empty array expression in get_qual_for_list()
Дата
Msg-id CAOgcT0OChrN--uuqH6wG6Z8+nxnCWJ+2Q-uhnK4KOANdRRxuAw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] fix empty array expression in get_qual_for_list()  (Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>)
Re: [HACKERS] fix empty array expression in get_qual_for_list()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
Hi,

In case of list partitioned table:
1. If there is a partition accepting only null values and nothing else, then
currently the partition constraints for such a partition are constructed as
"((a IS NULL) OR (a = ANY (ARRAY[]::integer[])))".
I think there it is better to avoid constructing an empty array to avoid
executing ANY expression.

2.Also, we are constructing an expression using index 0 of arrays in
PartitionKey since currently we have only one column for list partition in key,
added an assert for this.

PFA.

Regards,
Jeevan Ladhe
Вложения

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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Race between SELECT and ALTER TABLE NO INHERIT
Следующее
От: Jeevan Ladhe
Дата:
Сообщение: Re: [HACKERS] fix empty array expression in get_qual_for_list()