Commit2a972e0

committed

Fix TRUNCATE doc: ALTER SEQUENCE RESTART is now transactional.

ALTER SEQUENCE RESTART was made transactional in commit3d79013.Backpatch to v10, where that was introduced.Patch by Justin Pryzby, per Yaroslav Schekin's report.Discussion:https://www.postgresql.org/message-id/20201005191922.GE17626%40telsasoft.com

1 parentc0bc4c6 commit2a972e0Copy full SHA for 2a972e0

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -160,8 +160,7 @@ TRUNCATE [ TABLE ] [ ONLY ] <replaceable class="parameter">name</replaceable> [`
`160`	`160`	`When <literal>RESTART IDENTITY</literal> is specified, the implied`
`161`	`161`	`<command>ALTER SEQUENCE RESTART</command> operations are also done`
`162`	`162`	`transactionally; that is, they will be rolled back if the surrounding`
`163`		`- transaction does not commit. This is unlike the normal behavior of`
`164`		`- <command>ALTER SEQUENCE RESTART</command>. Be aware that if any additional`
	`163`	`+ transaction does not commit. Be aware that if any additional`
`165`	`164`	`sequence operations are done on the restarted sequences before the`
`166`	`165`	`transaction rolls back, the effects of these operations on the sequences`
`167`	`166`	`will be rolled back, but not their effects on <function>currval()</function>;`

Comments

(0)