PG_ISBUSY(n)

📦 version 3.1.1, in alpine 3.22, alpine 3.23, alpine 3.24, nixpkgs unstable

🎀 NAME 🎀

pg_isbusy — see if a query is busy. okay bestie, you're in the PostgreSQL Tcl Interface Documentation, and this is the page for pg_isbusy. It's giving tiny-but-iconic. 💖

✨ SYNOPSIS ✨

pg_isbusy conn

🦋 DESCRIPTION 🦋

okay so pg_isbusy checks to see if the backend is busy handling a query or not. That's the whole vibe check, no cap. 💅

🌸 ARGUMENTS 🌸

  • conn — the handle of a connection to the database in which the large object exists. That's your connection handle, bestie, and yes it says large object — iykyk. 🫶

⭐ RETURN VALUE ⭐

It returns 1 if the backend is busy — and in that case, a call to pg_getresult would block. Otherwise it returns 0. So 1 = busy/blocky situation 😭, 0 = not busy, slay. 🔥

mwah 💋 this page comes from the PostgreSQL Tcl Interface Documentation and is dated 17 September 2020. byeeee 👑✨

📦 where this page comes from