Soni writes:
>> currently we are planning to migrate inheritance partitioning to
>> declarative partitioning by range values of int on pg10. But the key
>> values can contain null. I know that range partitioning does not allow
>> null values.
In v11 you could use a default partition ...
I think it's better to had list partitioning of true/false based on
(int_key_column is null)
CREATE TABLE partitioned_table_name (like table_name) partition by list
((int_key_column is null));
On 16/04/2019 9:37, Soni wrote:
Hello All,
currently we are planning to migrate inheritance partition