Hello,
I'm trying to build a set of plpgsql functions in order to ease partitioning by date, let's say
one table per day for a total of 30 days.
I have plpgsql functions to create the partition tables (having a date suffix) and to manage
a retention period, however I still need to solve a problem with indexes/foreign keys.
The partition tables are inherited from a template table, and while inheriting I loose
the information on indexes/keys. One possibility would be to write a facility to execute
a set of ddl statements on all the partition tables using a template (e.g. using a
placeholder for the table name) or maybe one could use the information on Primary/foreign keys
and indexes present also in the system tables so I guess one should be able to use it to build
the PK/FKs and indexes on the partition tables. Any advice?
Thanks in advance,