Ayah, December 17, 2018 - 4:29 pm UTC
But i need it to deal with row by row because i have a trigger in new_jobs that puts sequence number to each new job_id if it is not replicated.
Does what you said work with this case ?
December 17, 2018 - 5:05 pm UTC
Triggers still fire when you do insert-select. If there's an error, you should change the trigger.