Обсуждение: pgsql: Allow the planner-related functions and hook to accept the query

Поиск
Список
Период
Сортировка

pgsql: Allow the planner-related functions and hook to accept the query

От
Fujii Masao
Дата:
Allow the planner-related functions and hook to accept the query string.

This commit adds query_string argument into the planner-related functions
and hook and allows us to pass the query string to them.

Currently there is no user of the query string passed. But the upcoming patch
for the planning counters will add the planning hook function into
pg_stat_statements and the function will need the query string. So this change
will be necessary for that patch.

Also this change is useful for some extensions that want to use the query
string in their planner hook function.

Author: Pascal Legrand, Julien Rouhaud
Reviewed-by: Yoshikazu Imai, Tom Lane, Fujii Masao
Discussion: https://postgr.es/m/CAOBaU_bU1m3_XF5qKYtSj1ua4dxd=FWDyh2SH4rSJAUUfsGmAQ@mail.gmail.com
Discussion: https://postgr.es/m/1583789487074-0.post@n3.nabble.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6aba63ef3e606db71beb596210dd95fa73c44ce2

Modified Files
--------------
src/backend/commands/copy.c          |  3 ++-
src/backend/commands/createas.c      |  3 ++-
src/backend/commands/explain.c       |  2 +-
src/backend/commands/extension.c     |  2 +-
src/backend/commands/matview.c       |  2 +-
src/backend/commands/portalcmds.c    |  2 +-
src/backend/executor/functions.c     |  1 +
src/backend/optimizer/plan/planner.c | 10 ++++++----
src/backend/tcop/postgres.c          | 13 ++++++++-----
src/backend/utils/cache/plancache.c  |  3 ++-
src/include/optimizer/optimizer.h    |  3 ++-
src/include/optimizer/planner.h      |  4 +++-
src/include/tcop/tcopprot.h          |  6 ++++--
13 files changed, 34 insertions(+), 20 deletions(-)