"Claus Guttesen" <kometen@xxxxxxxxx> 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
