From: | Rod Taylor <rbt(at)rbt(dot)ca> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
Cc: | raja kumar thatte <trajakumar(at)yahoo(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [ADMIN] how to alter sequence. |
Date: | 2002-12-04 16:18:55 |
Message-ID: | 1039018735.35854.33.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
On Wed, 2002-12-04 at 09:06, Oliver Elphick wrote:
> On Wed, 2002-12-04 at 12:29, raja kumar thatte wrote:
> > Hai friends,
> > I have a sequence called raj_seq with max value 3000.
> ...
> > 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.
>
> Unfortunately there doesn't seem to be any easy way to do this. There
> is no ALTER SEQUENCE command and you can't use UPDATE on a sequence.
>
> Hackers: Could this be a TODO item for 7.4?
I'm hoping to do that one sooner than later, unless Neil beats me to it.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-04 16:47:21 | Re: how to cancel a query ? |
Previous Message | Hannu Krosing | 2002-12-04 15:57:26 | Re: [ADMIN] how to alter sequence. |
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Weilguni | 2002-12-04 16:21:50 | interesting difference for queries... |
Previous Message | Hannu Krosing | 2002-12-04 15:57:26 | Re: [ADMIN] how to alter sequence. |