aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor/functions.c
diff options
context:
space:
mode:
authorNoah Misch <noah@leadboat.com>2025-05-01 16:51:59 -0700
committerNoah Misch <noah@leadboat.com>2025-05-01 16:51:59 -0700
commitc6a26e4ccd1bf090ab755df2f597103798284d3a (patch)
tree892711e95bac21c274b989172063f44845a7aa94 /src/backend/executor/functions.c
parent0064020680c1293ec6ce9fe2588e33d6aebdb015 (diff)
downloadpostgresql-c6a26e4ccd1bf090ab755df2f597103798284d3a.tar.gz
postgresql-c6a26e4ccd1bf090ab755df2f597103798284d3a.zip
Doc: stop implying recommendation of insecure search_path value.
SQL "SET search_path = 'pg_catalog, pg_temp'" is silently equivalent to "SET search_path = pg_temp, pg_catalog, "pg_catalog, pg_temp"" instead of the intended "SET search_path = pg_catalog, pg_temp". (The intent was a two-element search path. With the single quotes, it instead specifies one element with a comma and a space in the middle of the element.) In addition to the SET statement, this affects SET clauses of CREATE FUNCTION, ALTER ROLE, and ALTER DATABASE. It does not affect the set_config() SQL function. Though the documentation did not show an insecure command, remove single quotes that could entice a reader to write an insecure command. Back-patch to v13 (all supported versions). Reported-by: Sven Klemm <sven@timescale.com> Author: Sven Klemm <sven@timescale.com> Backpatch-through: 13
Diffstat (limited to 'src/backend/executor/functions.c')
0 files changed, 0 insertions, 0 deletions