Re: COPY table FROM STDIN via SPI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Sewell <james(dot)sewell(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPY table FROM STDIN via SPI
Date: 2023-07-11 10:46:58
Message-ID: 2478511.1689072418@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

James Sewell <james(dot)sewell(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-07-11 11:00:41 Re: unrecognized node type while displaying a Path due to dangling pointer
Previous Message James Sewell 2023-07-11 10:25:23 COPY table FROM STDIN via SPI