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