From: Tom Lane <tgl@sss.pgh.pa.us>
To: stankiewiczal@gmail.com
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17195: Can't bind $1::int param when I use COPY TO STDOUT
 statement - libpq, C++
In-reply-to: <17195-895cc4ceea72abbd@postgresql.org>
References: <17195-895cc4ceea72abbd@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Sun, 19 Sep 2021 09:17:08 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1552783.1632064109.1@sss.pgh.pa.us>
Date: Sun, 19 Sep 2021 11:08:29 -0400
Message-ID: <1552784.1632064109@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1552784.1632064109%40sss.pgh.pa.us>
Precedence: bulk

PG Bug reporting form <noreply@postgresql.org> writes:
>     auto sql = "COPY(SELECT version_ts FROM test_point WHERE serie_id =
> $1::int) TO STDOUT (FORMAT binary)";

Don't hold your breath for that to work :-(.  Utility statements in
general do not support parameterization.  COPY is not an exception,
even when it contains what looks like a full DML command.  Maybe
somebody will improve that someday, but we'll certainly treat it
as a new feature not a bug fix.

			regards, tom lane