Re: COPY table FROM STDIN via SPI - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY table FROM STDIN via SPI
Date
Msg-id 2478511.1689072418@sss.pgh.pa.us
Whole thread Raw
In response to COPY table FROM STDIN via SPI  (James Sewell <james.sewell@gmail.com>)
Responses Re: COPY table FROM STDIN via SPI
List pgsql-hackers
James Sewell <james.sewell@gmail.com> 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?  What are they supposed to
send, or where are they supposed to put it for the COPY-out case?
There's just not provision for nesting protocol operations like that.

            regards, tom lane



pgsql-hackers by date:

Previous
From: James Sewell
Date:
Subject: COPY table FROM STDIN via SPI
Next
From: Tom Lane
Date:
Subject: Re: unrecognized node type while displaying a Path due to dangling pointer