| From: | raja kumar thatte <trajakumar(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | how to alter sequence. |
| Date: | 2002-12-04 12:29:00 |
| Message-ID: | 20021204122900.96540.qmail@web20608.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-12-04 12:44:25 | Re: how to alter sequence. |
| Previous Message | Mauro Goncalves de Oliveria | 2002-12-04 11:18:44 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-12-04 12:37:46 | Re: "unofficial" 7.3 RPMs |
| Previous Message | Dave Page | 2002-12-04 11:38:39 | Re: [GENERAL] PostgreSQL Global Development Group Announces |