Re: COPY table FROM STDIN via SPI

2023-07-12 Thread Joe Conway
On 7/12/23 14:43, c...@anastigmatix.net wrote: On 2023-07-12 14:18, Joe Conway wrote: On 7/11/23 22:52, James Sewell wrote: What about running a COPY directly from C - is that possible? https://www.postgresql.org/docs/current/libpq-copy.html Or is the question about a COPY kicked off from s

Re: COPY table FROM STDIN via SPI

2023-07-12 Thread chap
On 2023-07-12 14:18, Joe Conway wrote: On 7/11/23 22:52, James Sewell wrote: What about running a COPY directly from C - is that possible? https://www.postgresql.org/docs/current/libpq-copy.html Or is the question about a COPY kicked off from server-side C code (following up a question about

Re: COPY table FROM STDIN via SPI

2023-07-12 Thread Joe Conway
On 7/11/23 22:52, James Sewell wrote: No.  It'd be a wire protocol break, and even if it weren't I would not expect many clients to be able to deal with it.  They're in the middle of a query cycle (for the SELECT or CALL that got you into SPI), and suddenly the backend asks for C

Re: COPY table FROM STDIN via SPI

2023-07-11 Thread James Sewell
> > No. It'd be a wire protocol break, and even if it weren't I would not > expect many clients to be able to deal with it. They're in the middle > of a query cycle (for the SELECT or CALL that got you into SPI), and > suddenly the backend asks for COPY data? What are they supposed to > send, or

Re: COPY table FROM STDIN via SPI

2023-07-11 Thread Tom Lane
James Sewell writes: > Is $subject possible? No. It'd be a wire protocol break, and even if it weren't I would not expect many clients to be able to deal with it. They're in the middle of a query cycle (for the SELECT or CALL that got you into SPI), and suddenly the backend asks for COPY data?