From: | Egon Reetz <reetz(at)usco(dot)de> |
---|---|
To: | raja kumar thatte <trajakumar(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to alter sequence. |
Date: | 2002-12-04 13:47:43 |
Message-ID: | 3DEE077F.8F083C9E@usco.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
I meant start value (inst. min.).
Egon Reetz wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | raja kumar thatte | 2002-12-04 13:59:54 | Re: how to alter sequence. |
Previous Message | Egon Reetz | 2002-12-04 13:38:18 | Re: how to alter sequence. |
From | Date | Subject | |
---|---|---|---|
Next Message | Vince Vielhaber | 2002-12-04 13:47:53 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
Previous Message | Justin Clift | 2002-12-04 13:42:11 | Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces |