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.
How to do it...
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:
- In the first scenario we will drop an existing partition table. Here it is the
country_code_satable that will be dropped:
Before dropping the
country_log_sachild table, first see the records in the
postgres=# SELECT * from country_log; created_at ...