DBLINK_CANCEL_QUERY(3)

💖 dblink_cancel_query(3) — PostgreSQL 13.23 Documentation 💖

okay so bestie, this is the manual page for dblink_cancel_query(3), straight outta the PostgreSQL 13.23 docs, and it’s here to help you cancel a query on a connection. iconic behavior, honestly 🫶

🌸 NAME 🌸

dblink_cancel_query — cancels any active query on the named connection, no cap 💅

✨ SYNOPSIS ✨

dblink_cancel_query(text connname) returns text

🦋 DESCRIPTION 🦋

okay so dblink_cancel_query attempts to cancel any query that is in progress on the named connection. but bestie, listen: this is not certain to succeed — 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. you still have to complete the normal query protocol, for example by calling dblink_get_result. fr fr, don’t skip that part.

🎀 ARGUMENTS 🎀

• connname — name of the connection to use. that’s the vibe.

⭐ RETURN VALUE ⭐

Returns OK if the cancel request has been sent, or the text of an error message on failure. periodt.

🔥 EXAMPLES 🔥

SELECT dblink_cancel_query('dtest1');

byeee bestie 💜 this page is from PostgreSQL 13.23 and it’s dated 2025 — mwah 🎀✨