SPI_FINISH(3)

hiiii bestie, welcome to the SPI_finish page — the SPI_FINISH(3) one from the PostgreSQL 15.19 Documentation ✨ this is the lil disconnect moment for a C function and the SPI manager, and it’s giving “wrap it up, we’re done here” energy 💅

🌸 NAME 🌸

SPI_finish — disconnect a C function from the SPI manager 🫶

✨ SYNOPSIS ✨

int SPI_finish(void)

💖 DESCRIPTION 💖

okay so SPI_finish closes an existing connection to the SPI manager. Literally the disconnect step, no cap 🎀

You must call this function after completing the SPI operations needed during your C function’s current invocation. Like, finish your SPI business first, then call it — periodt ✨

🙈 but bestie, 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 💀💖

🔥 RETURN VALUE 🔥

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

mwah 💖 this iconic lil page comes from PostgreSQL 15.19, dated 2026, and it’s all about SPI_FINISH(3) — slay, go disconnect responsibly 🫶🌸