SPI_UNRE..._RELATION(3)

💖 SPI_UNRE..._RELATION(3) — fresh from the PostgreSQL 13.23 Documentation, bestie!

🎀 NAME 🎀

SPI_unregister_relation — remove an ephemeral named relation from the registry. That's the whole assignment, no cap. 🫶

✨ SYNOPSIS ✨

The signature is giving exactly this:

int SPI_unregister_relation(const char * name)

💅 DESCRIPTION 💅

Okay so SPI_unregister_relation removes an ephemeral named relation from the registry for the current connection. That's it — iconic, focused, does one thing. ✨

🫶 ARGUMENTS 🫶

• const char * name — the relation registry entry name. Literally the name of the entry in the relation registry. 🎀

🌈 RETURN VALUE 🌈

If the command runs successfully, you get this (nonnegative) value back:

• SPI_OK_REL_UNREGISTER — if the tuplestore has been successfully removed from the registry. Slay. 💖

On error, one of these negative values comes back:

• SPI_ERROR_ARGUMENT — if name is NULL
• SPI_ERROR_UNCONNECTED — if called from an unconnected C function
• SPI_ERROR_REL_NOT_FOUND — if name is not found in the registry for the current connection

xoxo, PostgreSQL 13.23 Documentation, 2025 💜✨