On Wed, Apr 11, 2018 at 1:13 PM, Don Seiler <don@xxxxxxxxx> wrote:
I had considered this as well, as this would allow me to rollback the delete (assuming my intel on postgres_fdw transactions was correct, which it may not be after all). I wondered if a remote insert would be broken up into individual inserts like the remote delete was, as that would be equally unappealing for the same reasons. But obviously worth confirming.
I have now confirmed that a remote INSERT does get broken up into a single INSERT for each row.
Don Seiler
www.seiler.us
www.seiler.us
