Here, we are going to show you how the partitioning scheme remains intact when an existing partition is dropped or a new partition is added.
Please refer to the first recipe, Implementing partitioning, before you read the steps outlined in this recipe.
There are two scenarios here. One scenario shows what happens when you delete an existing partition, and another shows what happens when a new partition is added. Let's discuss both the cases.
country_code_satable will be dropped, as follows:
country_log_sachild table, see the records in the
postgres=# SELECT * from country_log; created_at ...