pgsql: Make dblink interruptible, via new libpqsrv APIs. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Make dblink interruptible, via new libpqsrv APIs.
Date
Msg-id E1u0NYl-002UM1-1L@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Make dblink interruptible, via new libpqsrv APIs.

This replaces dblink's blocking libpq calls, allowing cancellation and
allowing DROP DATABASE (of a database not involved in the query).  Apart
from explicit dblink_cancel_query() calls, dblink still doesn't cancel
the remote side.  The replacement for the blocking calls consists of
new, general-purpose query execution wrappers in the libpqsrv facility.
Out-of-tree extensions should adopt these.

The original commit d3c5f37dd543498cc7c678815d3921823beec9e9 did not
back-patch.  Back-patch now to v16-v13, bringing coverage to all supported
versions.  This back-patch omits the orignal's refactoring in postgres_fdw.

Discussion: https://postgr.es/m/20231122012945.74@rfd.leadboat.com

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/63f6ecb6b023143becd4d8a580c23c0a3259dc84

Modified Files
--------------
contrib/dblink/dblink.c                            |  25 ++--
.../libpqwalreceiver/libpqwalreceiver.c            |   9 +-
src/include/libpq/libpq-be-fe-helpers.h            | 127 +++++++++++++++++++++
3 files changed, 144 insertions(+), 17 deletions(-)


pgsql-committers by date:

Previous
From: Álvaro Herrera
Date:
Subject: pgsql: Remove duplicate set of print_notnull
Next
From: Masahiko Sawada
Date:
Subject: pgsql: Restrict copying of invalidated replication slots.