Re: TRUNCATE TABLE with IDENTITY

From: Decibel! <decibel(at)decibel(dot)org>
To: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: TRUNCATE TABLE with IDENTITY
Date: 2008-04-07 18:26:52
Message-ID: 7C3D84AC-E918-4D42-95E7-4AECBF0A3C52@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-04-07 18:31:51 Re: Feature freeze status
Previous Message Decibel! 2008-04-07 18:22:36 Re: New boxes available for QA

Browse pgsql-patches by date

  From Date Subject
Next Message Zdenek Kotala 2008-04-07 18:37:44 Re: Headers dependencies cleanup
Previous Message Tom Dunstan 2008-04-07 14:39:08 Re: [HACKERS] Database owner installable modules patch