rkrage
Rails model class cannot be defined with a partition with sub-partitions
For example, setting the model class with range_partition_by { "(report_date::date)" }
I cannot set sub-partitions of hash kind, although I can create these partitions and sub partitions using:
create_range_partition_of
:main_table,
name: main_table_partition,
start_range: "#{current_year}-#{current_month}-01",
end_range: "#{current_year}-#{current_month}-#{current_month_last_day}",
partition_type: :hash,
partition_key: :org_id
and then create sub-partitions:
10.times do |i|
create_hash_partition_of
main_table_partition,
name: "#{main_table_partition}_org#{i}".to_sym,
modulus: 10,
remainder: i
end
Honestly, I'm not super familiar with how sub-partitioning works in this gem. That was implemented by @webandtech in https://github.com/rkrage/pg_party/pull/54
Can you provide a bit more info on what error you're seeing?
It's not really about the error, more about the inability to configure a rails model with a partition kind, which has a configuration for sub-partitions.