> Hi.
>
> I have a table with a serial field defined with an older version of
> postgresql (ver. 7). Back then max_value was 2147483647:
>
> select max_value from my_bid_seq ;
> max_value
> ------------
> 2147483647
>
> How can I increase it? By updating the max_value-field? This is an
> older thread and may have changed:
> http://archives.postgresql.org/pgsql-admin/2002-12/msg00033.php
That's the max for a regular int / serial type. You'll need to change
it to bigserial / bigint which is 64 bits/
>
> I'm running postgresql 8.3.1.
Please update to 8.3.3
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
No comments:
Post a Comment