On Sun, Dec 11, 2016 at 5:38 AM, Andrew Borodin <borodin@octonica.com> wrote: > 1. As far as I can see, we connot use COPY FROM STDIN in bg session? > Since one of purposes is to orchestrate transactions, may be that > would be valuable.
A background worker has no client connection, so what would COPY FROM STDIN do?
It doesn't make sense. But a bgworker may well want to supply input to COPY. A COPY FROM CALLBACK of COPY FROM FILEDESC or whatever.
I have the feeling something like this came up on the logical replication thread. Logical rep needs to efficiently load data via bgworker.