RELEASE SAVEPOINT
劉䓄
RELEASE SAVEPOINT -- 役鍴婔婻噽嬉垔幬䔇媺庻䗹
臺濘
RELEASE [ SAVEPOINT ] savepoint_name
柟誄
RELEASE SAVEPOINT 役鍴婔婻嘷嬉庋媇噽嬉垔幬䔇媺庻䗹㔗
檪婔婻媺庻䗹役鍴儌傴噽方濘嘩婺啂悔䗹嘪䫘鍴溴幋崡垄澇橬噽垄䫘潙埇蓕䔇臯婺㔗垄幽婉脘搴體婘媺庻䗹傺䆋蕙準幋劯欓臯䔇变傴䔇嘌巉㔗襕搴體闼底变傴埇傖嘪䫘 ROLLBACK TO SAVEPOINT 㔗婘婉喉驔襕䔇施唍役鍴婔婻媺庻䗹埇傖傴係䂘婘庋媇䂷溘幋嬉柊嬉啂櫽婔底蕇溊㔗
RELEASE SAVEPOINT 幘役鍴欔橬婘毺垔䔇媺庻䗹傺䆋幋劯䔇欔橬媺庻䗹㔗
埗昄
- savepoint_name
襕役鍴䔇媺庻䗹䔇劉庖
濘懟
弄滯婔婻傖嬉澇橬垔幬䔇媺庻䗹劉庖儖凚躘髍臇㔗
套悩庋媇婘啂悔䪽攕彍婉脘麪櫆媺庻䗹㔗
套悩崔婻媺庻䗹拖橬劯湙䔇劉庖埻橬橔誏垔幬䔇闼婻欉赆麪櫆㔗
冋床
傺䆋幽䘉劯役鍴婔婻媺庻䗹
BEGIN;
INSERT INTO table1 VALUES (3);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (4);
RELEASE SAVEPOINT my_savepoint;
COMMIT;
婪麵䔇庋媇儖劯施某噖 3 启 4 㔗
噚垹攓
認溇变傴镕冻 SQL 湺庖㔗湺庖蓇垔噿髞庖 SAVEPOINT 滇媙釂䔇㔗嘖 PostgreSQL 噕螩䩕䘖垄㔗