[pgpool-committers: 9585] pgpool: Fix Describe() so that it does not abort with portal created by

Tatsuo Ishii ishii at sraoss.co.jp
Mon Oct 2 19:14:36 JST 2023


Fix Describe() so that it does not abort with portal created by DECLARE.

When DECLARE foo CURSOR FOR is executed, a portal named "foo" is
automatically created by PostgreSQL. As the portal is not managed by
Pgpool-II, "Describe foo" message failed with "unable to execute
Describe. unable to get the bind message" error.

To fix this, make Describe() creates a dummy write query context so
that the describe message is sent to primary (streaming replication
mode) or all nodes (replication/snapshot isolation mode).

Problem analysis by Heather Lapointe.
Discussion: https://www.pgpool.net/pipermail/pgpool-general/2023-September/008995.html

Branch
------
V4_4_STABLE

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

Modified Files
--------------
src/protocol/pool_proto_modules.c | 48 ++++++++++++++++++++++++++++++++++-----
1 file changed, 42 insertions(+), 6 deletions(-)



More information about the pgpool-committers mailing list