]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Jan 2017 18:27:47 +0000 (13:27 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Jan 2017 18:27:47 +0000 (13:27 -0500)
commit47d32a464a8a5e70c95fe52d6b3e3a3fb25fd845
treed60792f020d3368591d51d85e94586b5f2591b03
parent4779d6ca20f7ce89c61b7729a6c714a258586d75
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function.

A client copy can't work inside a function because the FE/BE wire protocol
doesn't support nesting of a COPY operation within query results.  (Maybe
it could, but the protocol spec doesn't suggest that clients should support
this, and libpq for one certainly doesn't.)

In most PLs, this prohibition is enforced by spi.c, but SQL functions don't
use SPI.  A comparison of _SPI_execute_plan() and init_execution_state()
shows that rejecting client COPY is the only discrepancy in what they
allow, so there's no other similar bugs.

This is an astonishingly ancient oversight, so back-patch to all supported
branches.

Report: https://postgr.es/m/BY2PR05MB2309EABA3DEFA0143F50F0D593780@BY2PR05MB2309.namprd05.prod.outlook.com
src/backend/executor/functions.c