Hai friend, Thanks. But I wanted to change the maximum value but not current value. How to change the maximum value of a sequence
raja --- Dan Langille <[EMAIL PROTECTED]> wrote: > On 4 Dec 2002 at 4:29, raja kumar thatte wrote: > > > Hai friends, > > I have a sequence called raj_seq with max value > 3000. > > I have a table, with one field haveing > > nextvalu('raj_seq') as default value.; > > now i wanted to increase the max value of the > raj_seq > > to 9999999. > > How to do this change? > > http://www.postgresql.org/idocs/index.php?functions-sequence.html > Look for setval > -- > Dan Langille : http://www.langille.org/ > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly