Dear community,
In documentation, when partitioning tables, it is said that "Optionally,
define a trigger or rule to redirect data inserted into the master table
to the appropriate partition."
Is the trigger creation optional? I mean, partitioning will not work as
expected if we don't have the trigger, right? Or will PostgreSQL "decide
automatically" which table to use?
If the trigger is not there, when I add a row to "measurement" table
(like in docs example), it will be phisically inserted into
"measurement" table, not in the childs tables.
Am I right in this understanding?
Thanks,
Edson