Rollback sequence reset on TRUNCATE rollback patch

From: Steve Singer <ssinger(at)ca(dot)afilias(dot)info>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Rollback sequence reset on TRUNCATE rollback patch
Date: 2010-10-26 14:04:54
Message-ID: 4CC6E006.7020403@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
truncate_restart.diff text/x-patch 10.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-10-26 14:15:28 Re: add label to enum syntax
Previous Message Andrew Dunstan 2010-10-26 13:54:59 Re: add label to enum syntax