Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SPI_ROLLBACK(3)		 PostgreSQL 17.5 Documentation	       SPI_ROLLBACK(3)

NAME
       SPI_rollback, SPI_rollback_and_chain - abort the	current	transaction

SYNOPSIS
       void SPI_rollback(void)

       void SPI_rollback_and_chain(void)

DESCRIPTION
       SPI_rollback rolls back the current transaction.	It is approximately
       equivalent to running the SQL command ROLLBACK. After the transaction
       is rolled back, a new transaction is automatically started using
       default transaction characteristics, so that the	caller can continue
       using SPI facilities.

       SPI_rollback_and_chain is the same, but the new transaction is started
       with the	same transaction characteristics as the	just finished one,
       like with the SQL command ROLLBACK AND CHAIN.

       These functions can only	be executed if the SPI connection has been set
       as nonatomic in the call	to SPI_connect_ext.

PostgreSQL 17.5			     2025		       SPI_ROLLBACK(3)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=SPI_rollback_and_chain&sektion=3&manpath=FreeBSD+Ports+14.3.quarterly>

home | help