You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
But if I create history table as normal and then substitute its name with name of partitioned
table all works fine:
UPDATE periods.system_versioning SET history_table_name = TO_REGCLASS('partitioned_table_hist')
WHERE history_table_name='normal_table_hist'::regclass;
The only problem is management. I have to change all partitioned table names every time I need to add
a new history table.
The text was updated successfully, but these errors were encountered:
Is it possible to allow history table to be partitioned?
Function
add_system_versioning
doesn't allow me to do so, probably here:periods/periods--1.2.sql
Line 2601 in d7b2081
But if I create history table as normal and then substitute its name with name of partitioned
table all works fine:
The only problem is management. I have to change all partitioned table names every time I need to add
a new history table.
The text was updated successfully, but these errors were encountered: