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

  
 
  

home | help 
SPI_ROLLBACK(3) 	  PostgreSQL 18.6 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 equiv-
     alent  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 18.6 		      2026			 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+15.1.quarterly>

home | help