{"Entry":{"collection":"sql","key":"rollback-to-savepoint","name":"ROLLBACK TO SAVEPOINT","aliases":["rollback-to"],"metadata":{"aliases":["rollback-to"],"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":["notes"],"removed":[]},"status":"changed","synopsis":null,"to":"8.3"},{"from":"8.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["notes"],"removed":[]},"status":"changed","synopsis":null,"to":"9.0"},{"from":"15","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"16"}],"content_hash":"a61e03cc77c74ae6506dc90ad2e7f56e1ef327a3a40a1a38e38e07557d929d10","editorial":{},"first_version":"8.0","group":"transaction","imported_at":"2026-09-30T17:43:39.382582+08:00","last_version":"20","name":"ROLLBACK TO SAVEPOINT","object":"TO SAVEPOINT","position":13011,"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":"roll back to a savepoint","purpose_zh":"","related":["begin","commit","release-savepoint","rollback","savepoint"],"slug":"rollback-to-savepoint","source_rev":"a709ab85","synopsis":"ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name","verb":"ROLLBACK"}},"Definition":{"Collection":"sql","Key":"rollback-to-savepoint","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"rollback-to-savepoint","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-ROLLBACK-TO","file":"sql-rollback-to.html","lang":"en","name":"ROLLBACK TO SAVEPOINT","purpose":"roll back to a savepoint","purpose_zh":"","related":["begin","commit","release-savepoint","rollback","savepoint"],"sections":[{"html":"\u003cp\u003eRoll back all commands that were executed after the savepoint was established and then start a new subtransaction at the same transaction level. The savepoint remains valid and can be rolled back to again later, if needed.\u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003eROLLBACK TO SAVEPOINT\u003c/code\u003e implicitly destroys all savepoints that were established after the named 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 savepoint to roll back to.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eUse \u003ca href=\"/docs/18/sql-release-savepoint.html\" title=\"RELEASE SAVEPOINT\"\u003e\u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e\u003c/a\u003e to destroy a savepoint without discarding the effects of commands executed after it was established.\u003c/p\u003e\u003cp\u003eSpecifying a savepoint name that has not been established is an error.\u003c/p\u003e\u003cp\u003eCursors have somewhat non-transactional behavior with respect to savepoints. Any cursor that is opened inside a savepoint will be closed when the savepoint is rolled back. If a previously opened cursor is affected by a \u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e or \u003ccode class=\"command\"\u003eMOVE\u003c/code\u003e command inside a savepoint that is later rolled back, the cursor remains at the position that \u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e left it pointing to (that is, the cursor motion caused by \u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e is not rolled back). Closing a cursor is not undone by rolling back, either. However, other side-effects caused by the cursor's query (such as side-effects of volatile functions called by the query) \u003cspan class=\"emphasis\"\u003e\u003cem\u003eare\u003c/em\u003e\u003c/span\u003e rolled back if they occur during a savepoint that is later rolled back. A cursor whose execution causes a transaction to abort is put in a cannot-execute state, so while the transaction can be restored using \u003ccode class=\"command\"\u003eROLLBACK TO SAVEPOINT\u003c/code\u003e, the cursor can no longer be used.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eTo undo the effects of the commands executed after \u003ccode class=\"literal\"\u003emy_savepoint\u003c/code\u003e was established:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eROLLBACK TO SAVEPOINT my_savepoint;\n\u003c/pre\u003e\u003cp\u003eCursor positions are not affected by savepoint rollback:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n\nDECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;\n\nSAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        1\n\nROLLBACK TO SAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        2\n\nCOMMIT;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003eThe \u003cacronym\u003eSQL\u003c/acronym\u003e standard specifies that the key word \u003ccode class=\"literal\"\u003eSAVEPOINT\u003c/code\u003e is mandatory, but \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e and \u003cspan class=\"productname\"\u003eOracle\u003c/span\u003e allow it to be omitted. SQL allows only \u003ccode class=\"literal\"\u003eWORK\u003c/code\u003e, not \u003ccode class=\"literal\"\u003eTRANSACTION\u003c/code\u003e, as a noise word after \u003ccode class=\"literal\"\u003eROLLBACK\u003c/code\u003e. Also, SQL has an optional clause \u003ccode class=\"literal\"\u003eAND [ NO ] CHAIN\u003c/code\u003e which is not currently supported by \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e. Otherwise, this command conforms to the SQL standard.\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/release-savepoint/?v=18\" title=\"RELEASE SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eRELEASE SAVEPOINT\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/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":"ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"rollback-to-savepoint","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ROLLBACK TO SAVEPOINT","Summary":"回滚到一个保存点","BodyHTML":"\u003cpre\u003eROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e回滚该保存点建立后执行的所有命令，然后在同一事务层级启动一个新的子事务。该保存点仍然有效，如有需要，之后还可以再次回滚到它。\u003c/p\u003e\u003cp\u003e\u003ccode\u003eROLLBACK TO 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使用\u003ca href=\"/docs/18/sql-release-savepoint.html\" title=\"RELEASE SAVEPOINT\" rel=\"nofollow\"\u003e\u003ccode\u003eRELEASE SAVEPOINT\u003c/code\u003e\u003c/a\u003e可以销毁一个保存点，而不丢弃在它建立之后执行的命令所产生的效果。\u003c/p\u003e\u003cp\u003e指定一个尚未建立的保存点名称是一种错误。\u003c/p\u003e\u003cp\u003e就保存点而言，游标带有一些非事务性的行为。凡是在某个保存点内打开的游标，在回滚该保存点时都会被关闭。如果先前打开的游标在某个随后又被回滚的保存点内受到了 \u003ccode\u003eFETCH\u003c/code\u003e或\u003ccode\u003eMOVE\u003c/code\u003e命令的影响，那么该游标会保留在\u003ccode\u003eFETCH\u003c/code\u003e使其指向的位置上（也就是说，由\u003ccode\u003eFETCH\u003c/code\u003e引起的游标移动不会被回滚）。关闭游标同样不会因回滚而撤销。不过，如果游标查询导致了其他副作用（例如该查询调用的易变函数带来的副作用），且这些副作用发生在后来被回滚的保存点期间，那么它们\u003cspan\u003e\u003cem\u003e会\u003c/em\u003e\u003c/span\u003e被回滚。如果某个游标的执行导致事务中止，该游标会进入不可执行状态，因此即使事务可以通过\u003ccode\u003eROLLBACK TO SAVEPOINT\u003c/code\u003e恢复，该游标也不能再使用。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e要撤销在\u003ccode\u003emy_savepoint\u003c/code\u003e建立后执行的命令的效果：\u003c/p\u003e\u003cpre\u003eROLLBACK TO SAVEPOINT my_savepoint;\n\u003c/pre\u003e\u003cp\u003e游标位置不受保存点回滚的影响：\u003c/p\u003e\u003cpre\u003eBEGIN;\n\nDECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;\n\nSAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        1\n\nROLLBACK TO SAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        2\n\nCOMMIT;\n\u003c/pre\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和\u003cspan\u003eOracle\u003c/span\u003e允许省略它。SQL 只允许在\u003ccode\u003eROLLBACK\u003c/code\u003e之后使用\u003ccode\u003eWORK\u003c/code\u003e作为噪声词，不允许使用\u003ccode\u003eTRANSACTION\u003c/code\u003e。此外，SQL 还有一个可选子句 \u003ccode\u003eAND [ NO ] CHAIN\u003c/code\u003e，而\u003cspan\u003ePostgreSQL\u003c/span\u003e当前尚不支持。除此之外，该命令符合 SQL 标准。\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/release-savepoint/?v=18\" title=\"RELEASE SAVEPOINT\" rel=\"nofollow\"\u003e\u003cspan\u003eRELEASE SAVEPOINT\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/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":"94d938f1ee282d4644121eb7fd7d233216b4fd8bf8602f25d00ffb3c86e433ae","Payload":{"purpose_zh":"回滚到一个保存点","sections":[{"html":"\u003cp\u003e回滚该保存点建立后执行的所有命令，然后在同一事务层级启动一个新的子事务。该保存点仍然有效，如有需要，之后还可以再次回滚到它。\u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003eROLLBACK TO 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使用\u003ca href=\"/docs/18/sql-release-savepoint.html\" title=\"RELEASE SAVEPOINT\"\u003e\u003ccode class=\"command\"\u003eRELEASE SAVEPOINT\u003c/code\u003e\u003c/a\u003e可以销毁一个保存点，而不丢弃在它建立之后执行的命令所产生的效果。\u003c/p\u003e\u003cp\u003e指定一个尚未建立的保存点名称是一种错误。\u003c/p\u003e\u003cp\u003e就保存点而言，游标带有一些非事务性的行为。凡是在某个保存点内打开的游标，在回滚该保存点时都会被关闭。如果先前打开的游标在某个随后又被回滚的保存点内受到了 \u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e或\u003ccode class=\"command\"\u003eMOVE\u003c/code\u003e命令的影响，那么该游标会保留在\u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e使其指向的位置上（也就是说，由\u003ccode class=\"command\"\u003eFETCH\u003c/code\u003e引起的游标移动不会被回滚）。关闭游标同样不会因回滚而撤销。不过，如果游标查询导致了其他副作用（例如该查询调用的易变函数带来的副作用），且这些副作用发生在后来被回滚的保存点期间，那么它们\u003cspan class=\"emphasis\"\u003e\u003cem\u003e会\u003c/em\u003e\u003c/span\u003e被回滚。如果某个游标的执行导致事务中止，该游标会进入不可执行状态，因此即使事务可以通过\u003ccode class=\"command\"\u003eROLLBACK TO SAVEPOINT\u003c/code\u003e恢复，该游标也不能再使用。\u003c/p\u003e","key":"notes","title":"注解"},{"html":"\u003cp\u003e要撤销在\u003ccode class=\"literal\"\u003emy_savepoint\u003c/code\u003e建立后执行的命令的效果：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eROLLBACK TO SAVEPOINT my_savepoint;\n\u003c/pre\u003e\u003cp\u003e游标位置不受保存点回滚的影响：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eBEGIN;\n\nDECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;\n\nSAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        1\n\nROLLBACK TO SAVEPOINT foo;\n\nFETCH 1 FROM foo;\n ?column?\n----------\n        2\n\nCOMMIT;\n\u003c/pre\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和\u003cspan class=\"productname\"\u003eOracle\u003c/span\u003e允许省略它。SQL 只允许在\u003ccode class=\"literal\"\u003eROLLBACK\u003c/code\u003e之后使用\u003ccode class=\"literal\"\u003eWORK\u003c/code\u003e作为噪声词，不允许使用\u003ccode class=\"literal\"\u003eTRANSACTION\u003c/code\u003e。此外，SQL 还有一个可选子句 \u003ccode class=\"literal\"\u003eAND [ NO ] CHAIN\u003c/code\u003e，而\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e当前尚不支持。除此之外，该命令符合 SQL 标准。\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/release-savepoint/?v=18\" title=\"RELEASE SAVEPOINT\"\u003e\u003cspan class=\"refentrytitle\"\u003eRELEASE SAVEPOINT\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/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":"ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003esavepoint_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ROLLBACK [ WORK | TRANSACTION ] TO [ 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}