PG_CANCELREQUEST(n)

πŸ“¦ version 3.1.1, in alpine 3.22, alpine 3.23, alpine 3.24, nixpkgs unstable

πŸ’… NAME πŸ’…

pg_cancelrequest β€” request that PostgreSQL abandon processing of the current command πŸ’–

okay so this is the PG_CANCELREQUEST page from the PostgreSQL Tcl Interface Documentation β€” yes bestie, that exact manual, and we're about to make it make sense ✨

πŸ¦‹ SYNOPSIS πŸ¦‹

pg_cancelrequest conn

🌸 DESCRIPTION 🌸

pg_cancelrequest requests that the processing of the current command be abandoned. That's the whole vibe: it's giving "please stop processing this current command" energy, and the request gets dispatched πŸ’…

πŸŽ€ ARGUMENTS πŸŽ€

  • conn β€” the handle of a connection to the database in which the large object exists. Keep that handle close, bestie 🫢

✨ RETURN VALUE ✨

Returns nothing if the command was successfully dispatched or if no query was being processed. Otherwise, returns an error. So: silence means dispatched or nothing was running; error means something went sideways 😭


mwah πŸ’– this iconic little page comes from the PostgreSQL Tcl Interface Documentation, dated 17 September 2020 β€” periodt, we're done here πŸ‘‘

πŸ“¦ where this page comes from