SPI_CURSOR_CLOSE(3)

✨ SPI_CURSOR_CLOSE ✨

okay bestie, welcome to the SPI_CURSOR_CLOSE page, straight out of the PostgreSQL 18.6 docs 💖 this is the little function that says "bye bye" to a cursor and gives its storage back. short page, but it matters, so let's go 🫶

---

🌸 NAME 🌸

SPI_cursor_close — bestie... she closes a cursor. that's the whole vibe. 💅

---

🦋 SYNOPSIS 🦋

void SPI_cursor_close(Portal portal)

like... no return value, she just does it. main character energy fr fr ✨

---

🎀 DESCRIPTION 🎀

so here's the tea ☕: SPI_cursor_close closes a cursor that you already made earlier, and it releases that cursor's portal storage. gone. freed. slay.

and here's the part that lowkey changes your whole life: all open cursors get closed automatically at the end of a transaction. periodt. so the transaction is basically the responsible adult here 👑

which means you only need to call SPI_cursor_close if you want to release those resources sooner — like, before the transaction wraps up. it's not required, it's just... proactive. it's giving "I clean up after myself before the party's over" 💖

---

🌈 ARGUMENTS 🌈

• Portal portal — the portal that's holding the cursor. that's it, that's the whole argument. one portal, one job 🎯

---

⚠️ no cap, the only real thing to remember here: if you don't call this, the end of the transaction will do it for you anyway. so don't stress, but also don't hoard resources like a lil dragon 🐉✨

---

and that's the page, bestie!! this gorgeousness came to you from PostgreSQL 18.6, dated 2026 — mwah 💋 go close those cursors responsibly 👑🎀💖