In this recipe, we are going to show how the partitioning scheme remains intact when an existing partition is dropped or a new partition is added.
Refer to the first recipe, Implementing partitioning, before reading the steps outlined in this recipe.
There are two scenarios here. One is what happens when an existing partition is deleted and the other is what happens when a new partition is added. Let's discuss both cases:
country_code_satable that will be dropped:
Before dropping the
country_log_sa child table, first see the records in the
country_log master table:
postgres=# SELECT * from country_log; created_at ...