Thanks everybody.
--- Bruce Momjian <[EMAIL PROTECTED]> 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 > > -- > Bruce Momjian | > http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) > 359-1001 > + If your life is a hard drive, | 13 Roberts > Road > + Christ can be your backup. | Newtown > Square, Pennsylvania 19073 > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
