SPI_REGISTER_TRIGGER_DATA(3) | PostgreSQL 14.5 Documentation | SPI_REGISTER_TRIGGER_DATA(3) |
NAME¶
SPI_register_trigger_data - make ephemeral trigger data available in SPI queries
SYNOPSIS¶
int SPI_register_trigger_data(TriggerData *tdata)
DESCRIPTION¶
SPI_register_trigger_data makes any ephemeral relations captured by a trigger available to queries planned and executed through the current SPI connection. Currently, this means the transition tables captured by an AFTER trigger defined with a REFERENCING OLD/NEW TABLE AS ... clause. This function should be called by a PL trigger handler function after connecting.
ARGUMENTS¶
TriggerData *tdata
RETURN VALUE¶
If the execution of the command was successful then the following (nonnegative) value will be returned:
SPI_OK_TD_REGISTER
On error, one of the following negative values is returned:
SPI_ERROR_ARGUMENT
SPI_ERROR_UNCONNECTED
SPI_ERROR_REL_DUPLICATE
2022 | PostgreSQL 14.5 |