Re: dblink query interruptibility

Noah Misch <noah@leadboat.com>

From: Noah Misch <noah@leadboat.com>

To: Andreas Karlsson <andreas@proxel.se>

Cc: pgsql-hackers@postgresql.org

Date: 2025-04-03T21:29:34Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Make dblink interruptible, via new libpqsrv APIs.
- 186c586c3717 13.21 landed
- a8a9189376af 14.18 landed
- 63f6ecb6b023 15.13 landed
- 82a8f0f465ea 16.9 landed
- d3c5f37dd543 17.0 landed
Remove excess #include "utils/wait_event.h".
- 0efc83184777 17.0 landed
dblink, postgres_fdw: Handle interrupts during connection establishment
- e4602483e95b 16.0 cited
Fix old-fd issues using global barriers everywhere.
- e2f65f42555f 15.0 cited

On Wed, Mar 12, 2025 at 11:03:41AM +0100, Andreas Karlsson wrote:
> On 3/12/25 12:48 AM, Noah Misch wrote:
> > Overall, in the absence of objections, I will queue a task to back-patch the
> > non-postgres_fdw portion of commit d3c5f37 to v13-v16.

Pushed (e.g. v16 has commit 82a8f0f).  Only v16 had libpq-be-fe-helpers.h at
all, so I also back-patched 28a5917 to add it.  The original use case for
libpq-be-fe-helpers.h was interrupting PQconnectdbParams(), commit e460248.  I
decided not to back-patch that one, since connection-time delays are often
limited in ways query runtime is not.  We could change that decision.