SPI_FREEPLAN(3)

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

πŸ’… SPI_FREEPLAN(3) β€” the PostgreSQL 14.24 glow-up edition ✨

okay so bestie, welcome to the manual page for SPI_freeplan, straight out of the PostgreSQL 14.24 Documentation. it's short, it's sweet, and it's literally the cleanup crew of prepared statements 🧹🫢


🌸 NAME 🌸

SPI_freeplan β€” frees a prepared statement that you saved earlier. yes queen, we're doing the responsible thing and cleaning up after ourselves πŸ’–


✨ SYNOPSIS ✨

int SPI_freeplan(SPIPlanPtr plan)

one function, one pointer, zero drama. look at her go πŸ¦‹


πŸŽ€ DESCRIPTION πŸŽ€

so here's the tea β˜•: SPI_freeplan releases a prepared statement β€” specifically the kind that was previously returned by SPI_prepare, or saved by SPI_keepplan or SPI_saveplan.

think of it as the "okay bestie, you can go now, thank you for your service" moment πŸ‘‘ like, you kept that plan around, it did its job, and now it's officially time to set it free. main character exit, no cap ✨


πŸ’… ARGUMENTS πŸ’…

  • SPIPlanPtr plan β€” pointer to the statement you want to free. that's it, that's the whole arg. give her the pointer and she'll handle the rest 🫢

🌈 RETURN VALUE 🌈

  • 0 on success β€” slay, the plan is freed, we love a clean exit πŸ’–
  • SPI_ERROR_ARGUMENT if plan is NULL or invalid β€” ngl, if you hand her a null or bogus pointer she will hit you with this πŸ’€ so maybe double-check your pointer first, iykyk

⭐ SEE ALSO ⭐

(fr fr, the original page didn't list any SEE ALSO refs, so there's nothing extra to link here β€” just you, your plan pointer, and the freeing thereof 🧚)


🫢 reminder bestie: freeing something that's NULL or invalid gets you SPI_ERROR_ARGUMENT, not a crash-and-burn situation β€” but still, vibe check your pointers before you send them πŸ’…

and that's the whole page, bestie πŸ’œ short and iconic, just like the original β€” which comes to you courtesy of PostgreSQL 14.24, dated 2026. go forth and free your plans responsibly, mwah πŸ˜­πŸŽ€πŸŒΈ

πŸ“¦ where this page comes from