From: Scott Marlowe <scott.marlowe@gmail.com>
To: Claus Guttesen <kometen@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: change max_value in sequence
Date: Fri, 5 Sep 2008 07:52:08 -0600
Message-ID: <dcc563d10809050652n5a7a8dfdi6b15aad045616d09@mail.gmail.com> (raw)
In-Reply-To: <b41c75520809050558o541ac369w2a50fa47a2be2e99@mail.gmail.com>
References: <b41c75520809050558o541ac369w2a50fa47a2be2e99@mail.gmail.com>
On Fri, Sep 5, 2008 at 6:58 AM, Claus Guttesen <kometen@gmail.com> wrote:
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, kometen@gmail.com
Subject: Re: change max_value in sequence
In-Reply-To: <dcc563d10809050652n5a7a8dfdi6b15aad045616d09@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox