[pgpool-committers: 9063] pgpool: Fix pgpool_adm: pcp_pool_status.

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jan 16 21:44:03 JST 2023


Fix pgpool_adm: pcp_pool_status.

If the function is used with PostgreSQL 15, it fails with:

ERROR:  table-function protocol for value-per-call mode was not followed

pcp_pool_status actually returns set of record but it was declared as
"returns record".  This sloppiness had been tolerated until 14 but 15
becomes more strict. To fix this we need to change the return type of
pcp_pool_status from "returns record" to "returns setof record".
So the pgpool_adm extension version is bumped up.

Branch
------
V4_4_STABLE

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

Modified Files
--------------
.../src/sgml/ref/pgpool_adm_pcp_pool_status.sgml   |   4 +-
doc/src/sgml/ref/pgpool_adm_pcp_pool_status.sgml   |   4 +-
src/Makefile.am                                    |   2 +
src/sql/pgpool_adm/Makefile                        |   3 +-
src/sql/pgpool_adm/pgpool_adm--1.4--1.5.sql        |  28 ++++++
src/sql/pgpool_adm/pgpool_adm--1.4.sql             |   2 +-
src/sql/pgpool_adm/pgpool_adm--1.5.sql             | 101 +++++++++++++++++++++
src/sql/pgpool_adm/pgpool_adm.control              |   2 +-
8 files changed, 139 insertions(+), 7 deletions(-)



More information about the pgpool-committers mailing list