SPI_FREEPLAN(3)

📦
version 18.6 · 21 versions
, in alpine 3.23, alpine 3.24, arch rolling, fedora 43, fedora 44, nixos 26.05, ubuntu resolute, ubuntu stonking

🦋 NAME 🦋

okay so bestie, welcome to SPI_FREEPLAN(3), straight outta the PostgreSQL 18.6 Documentation. this one is SPI_freeplan — free a previously saved prepared statement. literally the cleanup bestie we all need. 💖

✨ SYNOPSIS ✨

int SPI_freeplan(SPIPlanPtr plan)

🌸 DESCRIPTION 🌸

SPI_freeplan releases a prepared statement previously returned by SPI_prepare or saved by SPI_keepplan or SPI_saveplan.

no cap, it's giving prepared-statement cleanup queen. 🧹✨

🎀 ARGUMENTS 🎀

  • SPIPlanPtr plan — pointer to statement to free. yeah bestie, just hand over the pointer and let her do her thing. 🫶

⭐ RETURN VALUE ⭐

  • 0 on success; SPI_ERROR_ARGUMENT if plan is NULL or invalid.
so if you get 0, slay. if you get SPI_ERROR_ARGUMENT, check that plan, because she said NULL or invalid and meant it. 💅

PostgreSQL 18.6 · 2026 · SPI_FREEPLAN(3) — that's the footer, bestie. now go free those plans responsibly 💖✨🎀

📦 where this page comes from