SPI_CONNECT(3)

💖 NAME

SPI_connect, SPI_connect_ext — connect a C function to the SPI manager, bestie ✨

okay so this is the SPI_CONNECT(3) page from the PostgreSQL 16.15 Documentation, and it's giving very much "C extension main character energy" 🎀

🌸 SYNOPSIS

int SPI_connect(void)

int SPI_connect_ext(int options)

🦋 DESCRIPTION

SPI_connect opens a connection from a C function invocation to the SPI manager. You must call this function if you want to execute commands through SPI. Some utility SPI functions can be called from unconnected C functions, iykyk 👑

SPI_connect_ext does the same thing, but it has an argument that lets you pass option flags. Currently, the following option values are available:

• SPI_OPT_NONATOMIC — sets the SPI connection to be nonatomic, which means transaction control calls (SPI_commit, SPI_rollback) are allowed. Otherwise, calling those functions will result in an immediate error 🚨

SPI_connect() is equivalent to SPI_connect_ext(0) — no cap, literally the same vibe 💅

⭐ RETURN VALUE

• SPI_OK_CONNECT — on success ✨
• SPI_ERROR_CONNECT — on error 😭

Source/version: PostgreSQL 16.15 · Date: 2026 · byeee bestie, go slay those SPI calls 🫶💜