Thread: Rollback sequence reset on TRUNCATE rollback patch

The attached patch modifies TRUNCATE ... RESTART IDENTITY so that if the
transaction rolls back the restart of the sequence will also be rolled back.

It follows the general outline discussed at
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00550.php of
assigning a new reffilenode to the sequence.


I will add this to the next commitfest.


Steve

Steve Singer <ssinger@ca.afilias.info> writes:
> The attached patch modifies TRUNCATE ... RESTART IDENTITY so that if the 
> transaction rolls back the restart of the sequence will also be rolled back.

Applied with significant editorialization (didn't much like the
refactoring you'd chosen for DefineSequence, and there were some
other issues).
        regards, tom lane