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

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jan 16 21:43:46 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
------
master

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

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