SPI_CURSOR_CLOSE(3)

πŸ“¦ version 15.19, in opensuse-leap 16.0

✨ NAME ✨

SPI_cursor_close β€” bestie, it closes a cursor πŸŽ€

This is from the SPI_CURSOR_CLOSE(3) page in the PostgreSQL 15.19 docs, and yes we're getting into it πŸ’…


🌸 SYNOPSIS 🌸

void SPI_cursor_close(Portal portal)

πŸ¦‹ DESCRIPTION πŸ¦‹

Okay so here's the tea: SPI_cursor_close closes a cursor you already made earlier, and it releases that cursor's portal storage. Cleanup era, honestly 🧹✨

And like β€” good news β€” all open cursors are closed automatically at the end of a transaction. So the whole thing handles itself, no cap. You only need to actually call SPI_cursor_close if you're being extra and want to release those resources sooner than the transaction ending. Main character resource management, we love to see it πŸ‘‘


πŸ’– ARGUMENTS πŸ’–

  • Portal portal β€” the portal containing the cursor 🫢

⭐ that's the whole page ⭐

Short and iconic, fr fr. This little beauty came to you from PostgreSQL 15.19 documentation, dated 2026 β€” so when the docs said SPI_CURSOR_CLOSE(3), they meant it πŸ˜­πŸ’œ

bye bestie, go close those cursors responsibly πŸ’…πŸŒΈ

πŸ“¦ where this page comes from