A.71. Release 4.0.20

Fix bug in query cache. (Tatsuo Ishii)

Pgpool-II did not cache the query like "Select '2022-02-18 07:00:00.006547'::timestamp". SELECTs include TIMESTAMP, TIME and DATE are cached, and SELECTs include TIMESTAMPZ and TIMEZ are not cached because the result can be changed by SET TIME ZONE command etc. Furthermore, SELECTs having functions with return types are timestamptz or timetz are not cached too as same reason. Discussion: [pgpool-general: 8285]

Doc: mention that certain SELECTs are not cached. (Tatsuo Ishii)

certain SELECTs are follows.

• SELECTs including TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE

• SELECTs including CAST to TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE

• SELECTs including SQLValueFunction (CURRENT_TIME, CURRENT_USER etc.)

Doc: fix description about using PCP password file when connect to Unix domain socket (Masaya Kawamoto)

The localhost entry in pcppass matches only for the default PCP socket directory path, not all Unix socket connections. This behavior is the same as pgpass.

Doc: fix wrong explanation on memqcache_maxcache, memqcache_expire. (Tatsuo Ishii)

Those parameters cannot be changed by reloading config file. Restarting pgpool is required. Discussion: [pgpool-general: 8195]

Allow to run pgpool_setup on PostgreSQL 15. (Tatsuo Ishii)

Per ticket 757

Test: print Pgpool-II version in the regression test. (Tatsuo Ishii)

Test: Fix regression test script to look for pgpool.conf in the proper install directory. (Tatsuo Ishii)