how to alter sequence.
| От | raja kumar thatte |
|---|---|
| Тема | how to alter sequence. |
| Дата | |
| Msg-id | 20021204122900.96540.qmail@web20608.mail.yahoo.com обсуждение |
| Ответы |
Re: how to alter sequence.
Re: how to alter sequence. |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: