SAVEPOINT Table "save.sample"
testdb=# BEGIN;
BEGIN
testdb=# CREATE TABLE sample(id integer);
CREATE TABLE
testdb=# INSERT INTO sample VALUES(1);
INSERT 0 1
testdb=# INSERT INTO sample VALUES(2);
INSERT 0 1
testdb=# SAVEPOINT sp;
SAVEPOINT
testdb=# INSERT INTO sample VALUES(3);
INSERT 0 1
testdb=# SAVEPOINT sp;
SAVEPOINT
testdb=# INSERT INTO sample VALUES(4);
INSERT 0 1
testdb=# RELEASE SAVEPOINT sp;
testdb=# ROLLBACK TO sp;
ROLLBACK
testdb=# SELECT * FROM sample;
id
----
1
2
(2 rows)
testdb=# \d sample
Table "save.sample"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
この記事が気に入ったらサポートをしてみませんか?