PG_BLOCKING(n)

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

🦋 PG_BLOCKING() 🦋

🎀 NAME 🎀

pg_blocking — see or set whether or not a connection is set to blocking or nonblocking. she's part of the PostgreSQL Tcl Interface Documentation, and she's literally here to help you vibe-check your connection. 💅

✨ SYNOPSIS ✨

pg_blocking conn [mode]

💖 DESCRIPTION 💖

okay so pg_blocking can set the connection to either blocking or nonblocking, and it can also see which way the connection is currently set. two jobs, one icon, she ate. 🫶

🌸 ARGUMENTS 🌸

  • conn — the handle of a connection to the database in which the large object exists. yep, that connection. 🔌
  • mode — if present, sets the mode of the connection to nonblocking if it's 0. otherwise, it sets the connection to blocking. no cap. 💀

⭐ RETURN VALUE ⭐

  • if you call her with the mode argument, she returns nothing. like, void energy. 🫥
  • otherwise, she returns 1 if the connection is set for blocking, or 0 if the connection is set for nonblocking. iconic behavior, honestly. 👑

🫶 that's the whole page, bestie — from the PostgreSQL Tcl Interface Documentation, dated 17 September 2020. periodt. 💅

📦 where this page comes from