Re: Rollback sequence reset on TRUNCATE rollback patch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Singer <ssinger(at)ca(dot)afilias(dot)info>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Rollback sequence reset on TRUNCATE rollback patch
Date: 2010-11-17 21:45:49
Message-ID: 24612.1290030349@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Steve Singer <ssinger(at)ca(dot)afilias(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2010-11-17 21:46:21 We need to log aborted autovacuums
Previous Message Joshua D. Drake 2010-11-17 21:43:32 Re: unlogged tables