SPI_REGISTER_RELATION(3pg13)

🌸 NAME 🌸

okay so bestie, this is the SPI_REGISTER_RELATION(3) page from the PostgreSQL 13 docs, and it's here to explain how SPI_register_relation literally makes an ephemeral named relation available by name in SPI queries. no cap, that's the whole vibe. 💅

---

✨ SYNOPSIS ✨

the signature is giving:

int SPI_register_relation(EphemeralNamedRelation enr)

---

🦋 DESCRIPTION 🦋

SPI_register_relation makes an ephemeral named relation — with associated information — available to queries planned and executed through the current SPI connection. it's giving matchmaker for your SPI queries, and honestly? iconic. 💖

---

🎀 ARGUMENTS 🎀

• EphemeralNamedRelation enr — the ephemeral named relation registry entry. that's the whole argument, bestie. 🫶

---

🔥 RETURN VALUE 🔥

if the execution of the command was successful, you get this nonnegative value back:

• SPI_OK_REL_REGISTER — if the relation has been successfully registered by name. slay. ✨

on error, one of these negative values is returned:

• SPI_ERROR_ARGUMENT — if enr is NULL or its name field is NULL. 😭
• SPI_ERROR_UNCONNECTED — if called from an unconnected C function. 🙈
• SPI_ERROR_REL_DUPLICATE — if the name specified in the name field of enr is already registered for this connection. 💀

---

that's the whole page, bestie 🫶 — sourced from PostgreSQL 13.23 docs, dated 2025, and it's SPI_REGISTER_RELATION(3), periodt. 💖