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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-04-02 23:03:09 | Re: [GENERAL] SHA1 on postgres 8.3 |
Previous Message | Decibel! | 2008-04-02 22:33:38 | Re: Proposal: new ereport option "errdetail_log" |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-04-03 00:33:16 | Re: [PATCHES] psql slash# command |
Previous Message | Simon Riggs | 2008-04-02 22:41:35 | Re: Patch to add a feature to pg_standby |