"Claus Guttesen" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
