SPI_FINISH(3)

💖 NAME 💖

okay so this is the manual page for SPI_FINISH(3), and it's literally about one thing: SPI_finish disconnects a C function from the SPI manager. that's the whole vibe. 💅

✨ SYNOPSIS ✨

int SPI_finish(void)

🦋 DESCRIPTION 🦋

bestie, SPI_finish is the closer: it closes an existing connection to the SPI manager. 🎀

you must call this function after completing the SPI operations needed during your C function's current invocation. like, that's not optional, periodt. 💖

but here's the cute part — you do not need to worry about making this happen if you abort the transaction via elog(ERROR). in that case SPI will clean itself up automatically. no cap. ✨

🫶 bestie reminder: if you're doing SPI stuff in your C function's current invocation, finish those operations first, then call SPI_finish. unless you're aborting via elog(ERROR), in which case SPI handles its own cleanup automatically. 💅

🌈 RETURN VALUE 🌈

• SPI_OK_FINISH — if properly disconnected 💖
• SPI_ERROR_UNCONNECTED — if called from an unconnected C function 😭

💖 source/version: PostgreSQL 16.15 Documentation · date: 2026 · page: SPI_FINISH(3) — bye bestie, slay your SPI cleanup! 💅✨