Using Postgresql is normal for a table in the main partition, are rows inserted along with the child table?

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.

+4
source share
1 answer

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 , " , ".

explain select * from measurement, , , ONLY. UNION ALL , .

+4

All Articles