DBLINK_CANCEL_QUERY(3)

💅 DBLINK_CANCEL_QUERY 💅

okay bestie, welcome to the dblink_cancel_query page — it's a PostgreSQL 18.6 manual page, section 3 (that's the library-call girlies, iykyk) ✨

---

🌸 NAME 🌸

dblink_cancel_query — cancels any active query on the named connection 🛑

🦋 SYNOPSIS 🦋

dblink_cancel_query(text connname) returns text

✨ DESCRIPTION ✨

so what this does is: dblink_cancel_query attempts to cancel any query that's in progress on the named connection. it's giving "hey bestie, wrap it up" 🫶

but real talk — this is not certain to succeed. not to be dramatic but it literally cannot promise you anything, because (for example) the remote query might already have finished by the time you ask. a cancel request simply improves the odds that the query will fail soon. that's it. that's the whole vibe 💀

and the part people always forget: you must still complete the normal query protocol, for example by calling dblink_get_result. the cancel is not a substitute for finishing your homework, bestie, it's just a lil nudge 🎀

👑 ARGUMENTS 👑

• connname — name of the connection to use. like, which one. the connection. the name of it. 💅

🌈 RETURN VALUE 🌈

returns OK if the cancel request has been sent ✅ — or the text of an error message on failure 😭

🍓 EXAMPLES 🍓

SELECT dblink_cancel_query('dtest1');

---

not me writing an entire manpage just to say "we tried to cancel it, no promises" 😭 this is lowkey the most honest function in the whole extension and I respect it fr fr

okay that's the whole page, slay, you're welcome 💖 main character energy from you for reading all of it ✨

PostgreSQL 18.6 · 2026 · DBLINK_CANCEL_QUERY(3) — bye bestie, go cancel something 🦋