[pgpool-committers: 9228] pgpool: Use schema qualification for internal queries.

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 28 11:36:25 JST 2023


Use schema qualification for internal queries.

Some of objects such as function and cast did not use "pg_catalog."
schema qualification.  This does not lead to immediate security
concern but using the schema qualification is always good practice.

Not that for this I had to increase some buffer length:

- POOL_RELCACHE.query was changed from 1024 to 1500.
- query buffer size in pool_search_relcache was changed from 1024 to 1500.

Back patch to all supported branches: 4.4 to 4.0

Branch
------
V4_2_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=0e492df2deb560b3b07239a0ccdabf051eea36c3

Modified Files
--------------
src/include/utils/pool_relcache.h |  3 +-
src/query_cache/pool_memqcache.c  |  2 +-
src/rewrite/pool_timestamp.c      | 86 +++++++++++++++++++--------------------
src/utils/pool_relcache.c         |  2 +-
src/utils/pool_select_walker.c    | 14 +++----
5 files changed, 54 insertions(+), 53 deletions(-)



More information about the pgpool-committers mailing list