4 ms·
What happens if I try to insert into a master partition table, and there are no child tables that can store my data? For example, data is partitioned by month,
by xfalcox 9y ago
What happens if I try to insert into a master partition table, and there are no child tables that can store my data?
For example, data is partitioned by month, and I have no table for the month in the data I'm trying to insert.
- jeltz 9y agoIt will throw an error. Partitioning support in PostgreSQL 10 only solves a few simple use cases well, but the next version should get much more generally useful partitioning. This is how PostgreSQL usually releases major features.