Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY
Date
Msg-id AANLkTin03-GWB2R9mfWzp1tBQpFrHxv6e6fNLyhOtzas@mail.gmail.com
Whole thread Raw
In response to Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY  (Marc Cousin <cousinmarc@gmail.com>)
Responses Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY
List pgsql-hackers
On Wed, Nov 17, 2010 at 8:13 AM, Marc Cousin <cousinmarc@gmail.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


pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: changing MyDatabaseId
Next
From: Marc Cousin
Date:
Subject: Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY