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

FreeBSD Manual Pages

  
 
  

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

NAME
       SPI_commit, SPI_commit_and_chain	- commit the current transaction

SYNOPSIS
       void SPI_commit(void)

       void SPI_commit_and_chain(void)

DESCRIPTION
       SPI_commit commits the current transaction. It is approximately
       equivalent to running the SQL command COMMIT. After the transaction is
       committed, a new	transaction is automatically started using default
       transaction characteristics, so that the	caller can continue using SPI
       facilities. If there is a failure during	commit,	the current
       transaction is instead rolled back and a	new transaction	is started,
       after which the error is	thrown in the usual way.

       SPI_commit_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 COMMIT	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_COMMIT(3)

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

home | help