Re: TRUNCATE TABLE with IDENTITY

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TRUNCATE TABLE with IDENTITY
Date: 2008-03-25 16:08:40
Message-ID: 47E92388.2000404@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Simon Riggs wrote:
> RESTART IDENTITY will reset the SERIAL sequences back to the original
> start value.
>
Assuming this feature were to be added....

In cases where the same sequence has been used across multiple tables,
what will be the appropriate response when a user attempts to TRUNCATE
one of those tables with RESTART IDENTITY?

Cheers,
Steve

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2008-03-25 16:12:23 GiST opclass and varlena
Previous Message Simon Riggs 2008-03-25 16:02:25 Re: TRUNCATE TABLE with IDENTITY

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2008-03-25 16:18:50 Re: TRUNCATE TABLE with IDENTITY
Previous Message Simon Riggs 2008-03-25 16:02:25 Re: TRUNCATE TABLE with IDENTITY