I need to divide the data in all my application tables by year. It seems like table partitioning would be the ideal solution. But Tryton doesn’t have this option? If I add partitioning to the tables, will there be any issues with upgrading the module?
Apparently it is not possible to change the schema of a partitioned table: PostgreSQL: Documentation: 18: 5.12. Table Partitioning
So the upgrade process for such table will need to be done manually prior to the Tryton upgrade in such way that Tryton will not try to make any alteration on the table.
Also IIRC the partition key must be part of the primary key for the table, which is not really compatible with Tryton IDs.
Tryton does not check nor enforce a specific primary key. It just checks that a column id exists and it must have a serial sequence attached.