SPI_register_relation

SPI_register_relation
Prev	Up	46.1. Interface Functions	Home	Next

SPI_register_relation

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 procedure
SPI_ERROR_REL_DUPLICATE: if the name specified in the name field of enr is already registered for this connection

Prev	Up	Next
SPI_saveplan	Home	SPI_unregister_relation