Re: Allow COPY to use parameters - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow COPY to use parameters
Date
Msg-id 6771.1464113800@sss.pgh.pa.us
Whole thread Raw
In response to Allow COPY to use parameters  (David Fetter <david@fetter.org>)
Responses Re: Allow COPY to use parameters
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> Per discussion on IRC and some test code, COPY can't take parameters
> in a PREPARE, which feature would make it even more useful.

Uh, what?

regression=# prepare foo as copy c from stdin;
ERROR:  syntax error at or near "copy"
LINE 1: prepare foo as copy c from stdin;                      ^

Passing parameters into a utility statement of any stripe is a pretty
considerable project, IIRC; the infrastructure isn't there.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Next
From: Tom Lane
Date:
Subject: Re: effective_io_concurrency in 9.6beta