From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, raja kumar thatte <trajakumar(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to alter sequence. |
Date: | 2002-12-05 19:18:15 |
Message-ID: | 200212051918.gB5JIFT23020@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
I don't think you can drop/recreate the sequence because the dependency
code knows other tables depend on it.
---------------------------------------------------------------------------
Rajesh Kumar Mallah. wrote:
>
> Doesn't dropping and recreating the sequence suit the bill ?
>
> whats' the major advantage to implement em as a command?
>
> At least one thing from which all of us can benifit in PgSQL
> is replication. I just hope 7.4 give us some sort of master/slave replication.
>
>
> Regds
> Mallah.
>
>
> On Wednesday 04 December 2002 11:53 pm, Bruce Momjian wrote:
> > Oliver Elphick wrote:
> > > On Wed, 2002-12-04 at 12:29, raja kumar thatte wrote:
> > > > Hai friends,
> > > > I have a sequence called raj_seq with max value 3000.
> > >
> > > ...
> > >
> > > > now i wanted to increase the max value of the raj_seq
> > > > to 9999999.
> > > > How to do this change?
> > > > If i drop and recreate the raj_seq, then i have to
> > > > recreate the table and all triggers working on that
> > > > table.But it is not an acceptable solution.
> > > > So with out droping raj_seq , how do I solve this
> > > > problem.
> > >
> > > Unfortunately there doesn't seem to be any easy way to do this. There
> > > is no ALTER SEQUENCE command and you can't use UPDATE on a sequence.
> >
> > Gee, I thought they could just update the sequence table, but I see:
> >
> > test=> update yy set max_value = 100;
> > ERROR: You can't change sequence relation yy
> >
> > > Hackers: Could this be a TODO item for 7.4?
> >
> > Added to TODO:
> >
> > * Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-12-05 19:19:21 | Re: how to cancel a query ? |
Previous Message | Jie Liang | 2002-12-05 18:51:12 | list schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2002-12-05 19:21:34 | Re: 7.4 - TODO : alter table drop foreign key |
Previous Message | Tom Lane | 2002-12-05 19:17:08 | Re: [GENERAL] PostgreSQL Global Development Group Announces |