Rollback sequence reset on TRUNCATE rollback patch

Steve Singer <ssinger@ca.afilias.info>

From: Steve Singer <ssinger@ca.afilias.info>

To: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>

Date: 2010-10-26T14:04:54Z

Lists: pgsql-hackers

Attachments

truncate_restart.diff (text/x-patch) 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