From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | raja kumar thatte <trajakumar(at)yahoo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to alter sequence. |
Date: | 2002-12-04 14:06:52 |
Message-ID: | 1039010812.11433.75.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
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?
The easiest way to do this at present is probably to dump the database,
edit the dump to change the sequence max_value and then recreate the
database from the edited dump. I presume you used CREATE SEQUENCE in
order to get such a low max_value. If it were created from a SERIAL
datatype, you would also have to edit the table definition to use a
pre-created sequence. There is no means of specifying a max_value using
SERIAL.
--
Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
LFIX Limited
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Schmitz | 2002-12-04 14:47:25 | how to cancel a query ? |
Previous Message | raja kumar thatte | 2002-12-04 14:00:03 | Re: how to alter sequence. |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-04 14:09:46 | Re: Segmentation fault in 7.3 |
Previous Message | Vince Vielhaber | 2002-12-04 14:05:50 | Re: [GENERAL] PostgreSQL Global Development Group Announces |