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

• Re: TRUNCATE TABLE with IDENTITY at 2008-03-25 16:40:49 from Zoltan Boszormenyi

Responses

• Re: TRUNCATE TABLE with IDENTITY at 2008-04-03 05:52:25 from Zoltan Boszormenyi

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 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 Momjian	Date: 2008-04-03 00:33:16
	Subject: Re: [PATCHES] psql slash# command
Previous:	From: Simon Riggs	Date: 2008-04-02 22:41:35
	Subject: Re: Patch to add a feature to pg_standby