1SPI_ROLLBACK(3) PostgreSQL 13.4 Documentation SPI_ROLLBACK(3)
2
3
4
6 SPI_rollback, SPI_rollback_and_chain - abort the current transaction
7
9 void SPI_rollback(void)
10
11 void SPI_rollback_and_chain(void)
12
14 SPI_rollback rolls back the current transaction. It is approximately
15 equivalent to running the SQL command ROLLBACK. After a transaction is
16 rolled back, a new transaction has to be started using
17 SPI_start_transaction before further database actions can be executed.
18
19 SPI_rollback_and_chain is the same, but a new transaction is
20 immediately started with the same transaction characteristics as the
21 just finished one, like with the SQL command ROLLBACK AND CHAIN.
22
23 These functions can only be executed if the SPI connection has been set
24 as nonatomic in the call to SPI_connect_ext.
25
26
27
28PostgreSQL 13.4 2021 SPI_ROLLBACK(3)