how to alter sequence.
Raja Kumar Thatte <trajakumar@yahoo.com>
From: raja kumar thatte <trajakumar@yahoo.com>
To: pgsql-admin@postgresql.org
Date: 2002-12-04T12:29:00Z
Lists: pgsql-hackers
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?
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.
Thanks in advance.
have a nice time.
raja
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com