From: | Egon Reetz <reetz(at)usco(dot)de> |
---|---|
To: | raja kumar thatte <trajakumar(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to alter sequence. |
Date: | 2002-12-04 13:38:18 |
Message-ID: | 3DEE054A.A157C1B6@usco.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
Drop the sequence and recreate with a min. value greater your last value and
the new max. value.
Egon
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?
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Egon Reetz | 2002-12-04 13:47:43 | Re: how to alter sequence. |
Previous Message | Dan Langille | 2002-12-04 13:27:28 | Re: how to alter sequence. |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2002-12-04 13:41:08 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
Previous Message | Marc G. Fournier | 2002-12-04 13:37:33 | Re: [GENERAL] PostgreSQL Global Development Group Announces |