Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Marc Cousin <cousinmarc(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY
Date: 2010-11-17 14:50:36
Message-ID: AANLkTin03-GWB2R9mfWzp1tBQpFrHxv6e6fNLyhOtzas@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 17, 2010 at 8:13 AM, Marc Cousin <cousinmarc(at)gmail(dot)com> wrote:
>
> - Does the feature work as advertised?
>
> Yes. It works consistently, isn't fooled by savepoints or multiple serials
> in a table, or concurrent transactions
>

i haven't tested this nor readed the patch but i wondering what
happens in the presence of a prepared transaction (2PC), did you try
with concurrent transactions with different serialization levels?

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Cousin 2010-11-17 15:00:46 Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY
Previous Message Markus Wanner 2010-11-17 13:56:23 Re: changing MyDatabaseId