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

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

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

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