From: Claus Guttesen <kometen@gmail.com>
To: pgsql-admin@postgresql.org
Subject: change max_value in sequence
Date: Fri, 5 Sep 2008 14:58:21 +0200
Message-ID: <b41c75520809050558o541ac369w2a50fa47a2be2e99@mail.gmail.com> (raw)
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
I'm running postgresql 8.3.1.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.
Shakespeare
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: kometen@gmail.com
Subject: Re: change max_value in sequence
In-Reply-To: <b41c75520809050558o541ac369w2a50fa47a2be2e99@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