Re: [HACKERS] Adding support for Default partition in partitioning

Поиск
Список
Период
Сортировка
От Jeevan Ladhe
Тема Re: [HACKERS] Adding support for Default partition in partitioning
Дата
Msg-id CAOgcT0MBOK+hPbexJEXbhTh8LvPhm=LeaVEc+ZQ_SFnhKkw1+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Adding support for Default partition in partitioning  (amul sul <sulamul@gmail.com>)
Ответы Re: [HACKERS] Adding support for Default partition in partitioning  (amul sul <sulamul@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


IIUC, default partition constraints is simply NOT IN (<values of all
other sibling partitions>).
If constraint on the default partition refutes the new partition's
constraints that means we have overlapping partition, and perhaps
error.

You are correct Amul, but this error will be thrown before we try to
check for the default partition data. So, in such cases I think we really
do not need to have logic to check if default partition refutes the new
partition contraints.

Regards,
Jeevan Ladhe

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

Предыдущее
От: amul sul
Дата:
Сообщение: Re: [HACKERS] Adding support for Default partition in partitioning
Следующее
От: Josh Berkus
Дата:
Сообщение: [HACKERS] Notes on testing Postgres 10b1