On Tuesday, September 19, 2017, Job <
Job@colliniconsulting.it> wrote:
and would not care about table partitioning (COPY command fire partitioned-table triggers).
You might want to write a script that inserts directly into the partitions and bypass routing altogether.
Insert into ... select from ... is your only option for table-to-table and you are stuck with whatever locks the execution of the command needs to take.
David J.