SPI_FINISH(3)

🎀 NAME 🎀

okay bestie, welcome to SPI_FINISH(3) 💖 — this one is literally about how to disconnect a C function from the SPI manager. no cap, that's the whole vibe. ✨

🌸 SYNOPSIS 🌸

int SPI_finish(void)

🦋 DESCRIPTION 🦋

So SPI_finish closes an existing connection to the SPI manager. iconic cleanup behavior, honestly. 🫶

You must call this function after completing the SPI operations needed during your C function's current invocation. like, finish your little SPI tasks first, then close the connection — 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. slay, self-cleaning king behavior. 👑✨

💜 RETURN VALUE 💜

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

ngl, the vibe check here is simple: call SPI_finish when you're done, unless elog(ERROR) already yeeted the transaction and SPI handled its own cleanup. 🧚

xoxo, this was your PostgreSQL 13.23 documentation moment from 2025, and yes she ate 💅🎀💖