Postgres Pro
Downloads
Home   >   mailing lists

Re: change max_value in sequence - Mailing list pgsql-admin

From Tom Lane
Subject Re: change max_value in sequence
Date
Msg-id 24842.1220629150@sss.pgh.pa.us
Whole thread Raw
In response to change max_value in sequence  ("Claus Guttesen" <kometen@gmail.com>)
List pgsql-admin
Tree view 
"Claus Guttesen" <kometen@gmail.com> writes:
> I have a table with a serial field defined with an older version of
> postgresql (ver. 7). Back then max_value was 2147483647:
> How can I increase it? By updating the max_value-field?

I think you're looking for ALTER SEQUENCE.

Note that if the column it's feeding into is int4, you'd also need to
alter the column type ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Arctic Toucan
Date:
Subject: How can I avoid Frozenxid wraparound on failover to a standby(PITR) database?
Next
From: Brad Nicholson
Date:
Subject: Converting a Database from SQL_ASCII to UTF8