From: | raja kumar thatte <trajakumar(at)yahoo(dot)com> |
---|---|
To: | Dan Langille <dan(at)langille(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to alter sequence. |
Date: | 2002-12-04 13:20:28 |
Message-ID: | 20021204132028.73250.qmail@web20605.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
Hai friend,
Thanks. But I wanted to change the maximum value but
not current value. How to change the maximum value of
a sequence
raja
--- Dan Langille <dan(at)langille(dot)org> wrote:
> On 4 Dec 2002 at 4:29, 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?
>
>
http://www.postgresql.org/idocs/index.php?functions-sequence.html
> Look for setval
> --
> Dan Langille : http://www.langille.org/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________________________
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 13:27:28 | Re: how to alter sequence. |
Previous Message | Dan Langille | 2002-12-04 12:44:25 | Re: how to alter sequence. |
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2002-12-04 13:27:28 | Re: how to alter sequence. |
Previous Message | Dan Langille | 2002-12-04 12:44:25 | Re: how to alter sequence. |