Postgres Pro
Downloads
Home   >   mailing lists

Re: TRUNCATE TABLE with IDENTITY - Mailing list pgsql-hackers

From Steve Crawford
Subject Re: TRUNCATE TABLE with IDENTITY
Date
Msg-id 47E92388.2000404@pinpointresearch.com
Whole thread Raw
In response to TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: TRUNCATE TABLE with IDENTITY
Next
From: Dimitri Fontaine
Date:
Subject: GiST opclass and varlena