---
name: "SPI_register_relation"
section: "3"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/SPI_register_relation"
---

# SPI\_register\_relation(3)

make an ephemeral named relation available by name in SPI queries

## NAME

SPI\_register\_relation - make an ephemeral named relation available by name in SPI queries

## SYNOPSIS

```
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.

## ARGUMENTS

EphemeralNamedRelation *enr*

the ephemeral named relation registry entry

## RETURN VALUE

If the execution of the command was successful then the following (nonnegative) value will be returned:

SPI\_OK\_REL\_REGISTER

if the relation has been successfully registered by name

On error, one of the following 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