Skip site navigation (1) Skip section navigation (2)

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-02 22:53:10
Message-ID: 207EDE13-F000-4090-8FC6-77560736B60D@decibel.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Mar 25, 2008, at 11:40 AM, Zoltan Boszormenyi wrote:
> All of them? PostgreSQL allow multiple SERIALs to be present,
> the standard allows only one IDENTITY column in a table.
> And what about this case below?
>
> CREATE TABLE t1 (id1 serial, ...);
> ALTER SEQUENCE seq_t1_id1 RESTART WITH 5432 CYCLE;
>
> or the equivalent
>
> CREATE SEQUENCE seq_t1_id1 START WITH 5432 CYCLE;
> CREATE TABLE t1 (id1 serial, ...);
> ALTER SEQUENCE seq_t1_id1 OWNED BY t1.id1;
>
> PostgreSQL doesn't keep the START WITH information.
> But it should to perform a "restart" on the sequence,
> using the minval in this case wouldn't be correct.


I think you misunderstand what ALTER SEQUENCE RESTART does; it only  
changes the current value of the sequence.
-- 
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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-04-02 23:03:09
Subject: Re: [GENERAL] SHA1 on postgres 8.3
Previous:From: Decibel!Date: 2008-04-02 22:33:38
Subject: Re: Proposal: new ereport option "errdetail_log"

pgsql-patches by date

Next:From: Bruce MomjianDate: 2008-04-03 00:33:16
Subject: Re: [PATCHES] psql slash# command
Previous:From: Simon RiggsDate: 2008-04-02 22:41:35
Subject: Re: Patch to add a feature to pg_standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group