Thread

1. Rollback sequence reset on TRUNCATE rollback patch

   Steve Singer <ssinger@ca.afilias.info> — 2010-10-26T14:04:54Z

   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
   

2. Re: Rollback sequence reset on TRUNCATE rollback patch

   Tom Lane <tgl@sss.pgh.pa.us> — 2010-11-17T21:45:49Z

   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