I have a table in PostgreSQL 9.4 that I partitioned so that all inserts to the parent actually go into one of the child partitions. The problem is that I already have hundreds of millions of rows of data in the parent table from before I created partitions.
The parent and children exist in different schemas:
Here is how I created the partitions.
TRUNCATE the parent but not the children?