Horton

Re: TRUNCATE TABLE with IDENTITY

Steve Crawford <scrawford@pinpointresearch.com>

View thread View on postgr.es
From: Steve Crawford <scrawford@pinpointresearch.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2008-03-25T16:08:40Z
Lists: pgsql-hackers 
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