{"Entry":{"collection":"sql","key":"release-savepoint","name":"RELEASE SAVEPOINT","aliases":["release-savepoint"],"metadata":{"aliases":["release-savepoint"],"changed_in":[],"changes":[{"from":"7.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"8.0"},{"from":"8.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["compatibility"],"removed":[]},"status":"changed","synopsis":null,"to":"8.1"},{"from":"8.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"8.3"},{"from":"9.6","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["notes"],"removed":[]},"status":"changed","synopsis":null,"to":"10"},{"from":"15","purpose_changed":true,"renamed":null,"sections":{"added":[],"changed":["description","parameters","notes","examples"],"removed":[]},"status":"changed","synopsis":null,"to":"16"},{"from":"16","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["examples"],"removed":[]},"status":"changed","synopsis":null,"to":"17"}],"content_hash":"8424df1092db6465d1cdaf100ab2b88e3d0ac42a7cfa3bdc314570f7aa639f70","editorial":{},"first_version":"8.0","group":"transaction","imported_at":"2026-09-30T17:43:39.370017+08:00","last_version":"20","name":"RELEASE SAVEPOINT","object":"SAVEPOINT","position":13010,"present_in":["8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"purpose":"release a previously defined savepoint","purpose_zh":"","related":["begin","commit","rollback","rollback-to-savepoint","savepoint"],"slug":"release-savepoint","source_rev":"a709ab85","synopsis":"RELEASE [ SAVEPOINT ] savepoint_name","verb":"RELEASE"}},"Definition":{"Collection":"sql","Key":"release-savepoint","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"release-savepoint","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-RELEASE-SAVEPOINT","file":"sql-release-savepoint.html","lang":"en","name":"RELEASE SAVEPOINT","purpose":"release a previously defined savepoint","purpose_zh":"","related":["begin","commit","rollback","rollback-to-savepoint","savepoint"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e releases the named savepoint and all active savepoints that were created after the named savepoint, and frees their resources. All changes made since the creation of the savepoint that didn't already get rolled back are merged into the transaction or savepoint that was active when the named savepoint was created. Changes made after \u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e will also be part of this active transaction or savepoint.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the savepoint to release.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eSpecifying a savepoint name that was not previously defined is an error.\u003c/p\u003e\u003cp\u003eIt is not possible to release a savepoint when the transaction is in an aborted state; to do that, use \u003ca href=\"/docs/18/sql-rollback-to.html\" title=\"ROLLBACK TO SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e.\u003c/p\u003e\u003cp\u003eIf multiple savepoints have the same name, only the most recently defined unreleased one is released. Repeated commands will release progressively older savepoints.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eTo establish and later release a savepoint:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n    INSERT INTO table1 VALUES (3);\n    SAVEPOINT my_savepoint;\n    INSERT INTO table1 VALUES (4);\n    RELEASE SAVEPOINT my_savepoint;\nCOMMIT;\n\u003c/pre\u003e\u003cp\u003eThe above transaction will insert both 3 and 4.\u003c/p\u003e\u003cp\u003eA more complex example with multiple nested subtransactions:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n    INSERT INTO table1 VALUES (1);\n    SAVEPOINT sp1;\n    INSERT INTO table1 VALUES (2);\n    SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (3);\n    RELEASE SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (4))); -- generates an error\n\u003c/pre\u003e\u003cp\u003eIn this example, the application requests the release of the savepoint \u003ccode class=\"literal\"\u003esp2\u003c/code\u003e, which inserted 3. This changes the insert's transaction context to \u003ccode class=\"literal\"\u003esp1\u003c/code\u003e. When the statement attempting to insert value 4 generates an error, the insertion of 2 and 4 are lost because they are in the same, now-rolled back savepoint, and value 3 is in the same transaction context. The application can now only choose one of these two commands, since all other commands will be ignored:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eROLLBACK;\nROLLBACK TO SAVEPOINT sp1;\n\u003c/pre\u003e\u003cp\u003eChoosing \u003ccode class=\"command\"\u003eROLLBACK\u003c/code\u003e will abort everything, including value 1, whereas \u003ccode class=\"command\"\u003eROLLBACK TO SAVEPOINT sp1\u003c/code\u003e will retain value 1 and allow the transaction to continue.\u003c/p\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003eThis command conforms to the \u003cacronym\u003eSQL\u003c/acronym\u003e standard. The standard specifies that the key word \u003ccode class=\"literal\"\u003eSAVEPOINT\u003c/code\u003e is mandatory, but \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e allows it to be omitted.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/begin/?v=18\" title=\"BEGIN\"\u003e\u003cspan class=\"refentrytitle\"\u003eBEGIN\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/commit/?v=18\" title=\"COMMIT\"\u003e\u003cspan class=\"refentrytitle\"\u003eCOMMIT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback/?v=18\" title=\"ROLLBACK\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback-to-savepoint/?v=18\" title=\"ROLLBACK TO SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/savepoint/?v=18\" title=\"SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eSAVEPOINT\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"RELEASE [ SAVEPOINT ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"RELEASE [ SAVEPOINT ] savepoint_name"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"release-savepoint","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"RELEASE SAVEPOINT","Summary":"释放一个先前定义的保存点","BodyHTML":"\u003cpre\u003eRELEASE [ SAVEPOINT ] savepoint_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eRELEASE SAVEPOINT\u003c/code\u003e释放指定名称的保存点，以及在该保存点之后创建且仍处于活动状态的所有保存点，并释放它们占用的资源。自该保存点创建以来所做、且之前尚未被回滚的所有更改，都会并入在创建该保存点时处于活动状态的事务或保存点中。在\u003ccode\u003eRELEASE SAVEPOINT\u003c/code\u003e之后所做的更改，也将成为该活动事务或保存点的一部分。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e要释放的保存点名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e注解\u003c/h2\u003e\u003cp\u003e指定一个此前未定义的保存点名称是一种错误。\u003c/p\u003e\u003cp\u003e当事务处于已中止状态时，不能释放保存点；要这样做，请使用\u003ca href=\"/docs/18/sql-rollback-to.html\" title=\"ROLLBACK TO SAVEPOINT\" rel=\"nofollow\"\u003e\u003cspan\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e如果有多个保存点使用相同名称，则只会释放最近定义且尚未释放的那个。重复执行该命令会逐步释放更早的同名保存点。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e建立并随后释放一个保存点：\u003c/p\u003e\u003cpre\u003eBEGIN;\n    INSERT INTO table1 VALUES (3);\n    SAVEPOINT my_savepoint;\n    INSERT INTO table1 VALUES (4);\n    RELEASE SAVEPOINT my_savepoint;\nCOMMIT;\n\u003c/pre\u003e\u003cp\u003e上面的事务将插入 3 和 4。\u003c/p\u003e\u003cp\u003e一个包含多个嵌套子事务的更复杂示例：\u003c/p\u003e\u003cpre\u003eBEGIN;\n    INSERT INTO table1 VALUES (1);\n    SAVEPOINT sp1;\n    INSERT INTO table1 VALUES (2);\n    SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (3);\n    RELEASE SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (4))); -- 产生错误\n\u003c/pre\u003e\u003cp\u003e在这个例子中，应用程序请求释放保存点\u003ccode\u003esp2\u003c/code\u003e，值 3 是在其中插入的。这样会把该插入操作的事务上下文改为\u003ccode\u003esp1\u003c/code\u003e。当试图插入值 4 的语句产生错误时，2 和 4 的插入都会丢失，因为它们位于同一个随后被回滚的保存点中，而值 3 现在也位于同一事务上下文中，因此同样会丢失。由于此后所有其他命令都会被忽略，应用程序现在只能在以下两个命令中选择一个：\u003c/p\u003e\u003cpre\u003eROLLBACK;\nROLLBACK TO SAVEPOINT sp1;\n\u003c/pre\u003e\u003cp\u003e选择\u003ccode\u003eROLLBACK\u003c/code\u003e将中止所有内容，包括值 1；而\u003ccode\u003eROLLBACK TO SAVEPOINT sp1\u003c/code\u003e会保留值 1，并允许事务继续。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e该命令符合\u003cacronym\u003eSQL\u003c/acronym\u003e标准。标准规定关键字\u003ccode\u003eSAVEPOINT\u003c/code\u003e是强制的，但\u003cspan\u003ePostgreSQL\u003c/span\u003e允许省略它。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/begin/?v=18\" title=\"BEGIN\" rel=\"nofollow\"\u003e\u003cspan\u003eBEGIN\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/commit/?v=18\" title=\"COMMIT\" rel=\"nofollow\"\u003e\u003cspan\u003eCOMMIT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback/?v=18\" title=\"ROLLBACK\" rel=\"nofollow\"\u003e\u003cspan\u003eROLLBACK\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback-to-savepoint/?v=18\" title=\"ROLLBACK TO SAVEPOINT\" rel=\"nofollow\"\u003e\u003cspan\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/savepoint/?v=18\" title=\"SAVEPOINT\" rel=\"nofollow\"\u003e\u003cspan\u003eSAVEPOINT\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"85ac41f10fd3e5b40fb3b32f7e88f026a595c3fffb60a4104a8474f477492310","Payload":{"purpose_zh":"释放一个先前定义的保存点","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e释放指定名称的保存点，以及在该保存点之后创建且仍处于活动状态的所有保存点，并释放它们占用的资源。自该保存点创建以来所做、且之前尚未被回滚的所有更改，都会并入在创建该保存点时处于活动状态的事务或保存点中。在\u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e之后所做的更改，也将成为该活动事务或保存点的一部分。\u003c/p\u003e","key":"description","title":"描述"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e要释放的保存点名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e指定一个此前未定义的保存点名称是一种错误。\u003c/p\u003e\u003cp\u003e当事务处于已中止状态时，不能释放保存点；要这样做，请使用\u003ca href=\"/docs/18/sql-rollback-to.html\" title=\"ROLLBACK TO SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e如果有多个保存点使用相同名称，则只会释放最近定义且尚未释放的那个。重复执行该命令会逐步释放更早的同名保存点。\u003c/p\u003e","key":"notes","title":"注解"},{"html":"\u003cp\u003e建立并随后释放一个保存点：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n    INSERT INTO table1 VALUES (3);\n    SAVEPOINT my_savepoint;\n    INSERT INTO table1 VALUES (4);\n    RELEASE SAVEPOINT my_savepoint;\nCOMMIT;\n\u003c/pre\u003e\u003cp\u003e上面的事务将插入 3 和 4。\u003c/p\u003e\u003cp\u003e一个包含多个嵌套子事务的更复杂示例：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n    INSERT INTO table1 VALUES (1);\n    SAVEPOINT sp1;\n    INSERT INTO table1 VALUES (2);\n    SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (3);\n    RELEASE SAVEPOINT sp2;\n    INSERT INTO table1 VALUES (4))); -- 产生错误\n\u003c/pre\u003e\u003cp\u003e在这个例子中，应用程序请求释放保存点\u003ccode class=\"literal\"\u003esp2\u003c/code\u003e，值 3 是在其中插入的。这样会把该插入操作的事务上下文改为\u003ccode class=\"literal\"\u003esp1\u003c/code\u003e。当试图插入值 4 的语句产生错误时，2 和 4 的插入都会丢失，因为它们位于同一个随后被回滚的保存点中，而值 3 现在也位于同一事务上下文中，因此同样会丢失。由于此后所有其他命令都会被忽略，应用程序现在只能在以下两个命令中选择一个：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eROLLBACK;\nROLLBACK TO SAVEPOINT sp1;\n\u003c/pre\u003e\u003cp\u003e选择\u003ccode class=\"command\"\u003eROLLBACK\u003c/code\u003e将中止所有内容，包括值 1；而\u003ccode class=\"command\"\u003eROLLBACK TO SAVEPOINT sp1\u003c/code\u003e会保留值 1，并允许事务继续。\u003c/p\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e该命令符合\u003cacronym\u003eSQL\u003c/acronym\u003e标准。标准规定关键字\u003ccode class=\"literal\"\u003eSAVEPOINT\u003c/code\u003e是强制的，但\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e允许省略它。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/begin/?v=18\" title=\"BEGIN\"\u003e\u003cspan class=\"refentrytitle\"\u003eBEGIN\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/commit/?v=18\" title=\"COMMIT\"\u003e\u003cspan class=\"refentrytitle\"\u003eCOMMIT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback/?v=18\" title=\"ROLLBACK\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/rollback-to-savepoint/?v=18\" title=\"ROLLBACK TO SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eROLLBACK TO SAVEPOINT\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/savepoint/?v=18\" title=\"SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eSAVEPOINT\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"RELEASE [ SAVEPOINT ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"RELEASE [ SAVEPOINT ] savepoint_name"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}