Using the example of Postgres Partitioning Docs 9.3 , if the main table "dimension" receives the rows inserted during the insertion after creating the trigger functions and call?
Using the example specified in the documents when inserting, both the main and the child table have inserted rows. Although I use <RETURN NULL> in the trigger function, it will prevent the assembly of the main tables.
Rows are not inserted in the parent table. They are simply visible from the parent table, as the child table extends it.
SELECT * FROM ONLY measurement;, , measurement, . ONLY , " , ".
SELECT * FROM ONLY measurement;
measurement
ONLY
explain select * from measurement, , , ONLY. UNION ALL , .
explain select * from measurement
UNION ALL