Horton

Re: TRUNCATE TABLE with IDENTITY

Decibel! <decibel@decibel.org>

View thread View on postgr.es
From: Decibel! <decibel@decibel.org>
To: Zoltan Boszormenyi <zb@cybertec.at>
Cc: Simon Riggs <simon@2ndquadrant.com>, Steve Crawford <scrawford@pinpointresearch.com>, pgsql-hackers@postgresql.org
Date: 2008-04-07T18:26:52Z
Lists: pgsql-hackers 
On Apr 3, 2008, at 12:52 AM, Zoltan Boszormenyi wrote:
> Where is the info in the sequence to provide restarting with
> the _original_ start value?


There isn't any. If you want the sequence to start at some magic  
value, adjust the minimum value.
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828