Commitd348473

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 parent609fe21 commitd348473Copy full SHA for d348473

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 2 deletions

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

Comments

(0)