- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 279字
- 2021-07-09 19:57:11
Making use of savepoints
In professional applications, it can be pretty hard to write reasonably long transactions without ever encountering a single error. To solve the problem, users can utilize something called SAVEPOINT. As the name indicates, it is a safe place inside a transaction that the application can return to in the event things go terribly wrong. Here is an example:
test=# BEGIN;
BEGIN
test=# SELECT 1;
?column?
----------
1
(1 row)
test=# SAVEPOINT a;
SAVEPOINT
test=# SELECT 2 / 0;
ERROR: division by zero
test=# ROLLBACK TO SAVEPOINT a;
ROLLBACK
test=# SELECT 3;
?column?
----------
3
(1 row)
test=# COMMIT;
COMMIT
After the first SELECT clause, I decided to create a SAVEPOINT to make sure that the application can always return to this point inside the transaction. As you can see, a SAVEPOINT has a name, which is referred to later.
After returning to a, the transaction can proceed normally. The code has jumped back before the error, so everything is fine.
The number of savepoints inside a transaction is practically unlimited. We have seen customers with over 250,000 savepoints in a single operation. PostgreSQL can easily handle that.
If you want to remove a savepoint from inside a transaction, there is RELEASE SAVEPOINT:
test=# h RELEASE SAVEPOINT
Command: RELEASE SAVEPOINT
Description: destroy a previously defined savepoint
Syntax:
RELEASE [ SAVEPOINT ] savepoint_name
Many people ask, What will happen if you try to reach a savepoint after a transaction has ended? The answer is that the life of a savepoint ends as soon as the transaction ends. In other words, there is no way to return to a certain point in time after the transactions have been completed.
- PPT,要你好看
- Oracle SOA Governance 11g Implementation
- 火格局的時空變異及其在電網(wǎng)防火中的應用
- 21天學通PHP
- 計算機應用基礎·基礎模塊
- STM32嵌入式微控制器快速上手
- OpenStack Cloud Computing Cookbook
- Python:Data Analytics and Visualization
- Machine Learning with the Elastic Stack
- Linux嵌入式系統(tǒng)開發(fā)
- 實用網(wǎng)絡流量分析技術
- 人工智能:語言智能處理
- ZigBee無線通信技術應用開發(fā)
- 空間機器人智能感知技術
- 西門子S7-1200/1500 PLC從入門到精通