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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 28 11:36:18 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_1_STABLE

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

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    | 12 +++---
5 files changed, 53 insertions(+), 52 deletions(-)



More information about the pgpool-committers mailing list