]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Make dblink interruptible, via new libpqsrv APIs.
authorNoah Misch <noah@leadboat.com>
Mon, 8 Jan 2024 19:39:56 +0000 (11:39 -0800)
committerNoah Misch <noah@leadboat.com>
Thu, 3 Apr 2025 16:34:01 +0000 (09:34 -0700)
commit63f6ecb6b023143becd4d8a580c23c0a3259dc84
tree3ba0335293540bf45ca91dec7aa3961b7de73765
parent9e129a2243e2c1e5b7107cec06262aad26533f0c
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
contrib/dblink/dblink.c
src/backend/replication/libpqwalreceiver/libpqwalreceiver.c
src/include/libpq/libpq-be-fe-helpers.h