Sequence id NOT incremented as expected

From: SINGHAL Harsh <harsh(dot)singhal(at)cy-play(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sequence id NOT incremented as expected
Date: 2012-07-20 08:19:00
Message-ID: 50091474.6030908@cy-play.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

FACTS :

1. Sequences are based on bigint arithmetic, so the range cannot exceed
the range of an eight-byte integer (-9223372036854775808 to
9223372036854775807). On some older platforms, there may be no
compiler support for eight-byte integers, in which case sequences
use regular integer arithmetic (range -2147483648 to +2147483647).
2. The CYCLE option allows the sequence to wrap around when the
maxvalue or minvalue has been reached by an ascending or descending
sequence respectively. If the limit is reached, the next number
generated will be the minvalue or maxvalue, respectively.

Reality :

* version
PostgreSQL 8.4.12 on x86_64-pc-linux-gnu, compiled by GCC
gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit

* Colonne|Type|Valeur
sequence_name|name|xxx_id_seq
last_value|bigint|1
start_value|bigint|1
increment_by|bigint|1
max_value|bigint|9223372036854775807
min_value|bigint|1
cache_value|bigint|1
log_cnt|bigint|32
is_cycled|boolean|t
is_called|boolean|t

* In an increasing sequence whose max value is set to
9223372036854775807 and cycle option is activated, as shown above,
from 2147483647 to 9223372036854775807 it is displaying error
"ERREUR: entier en dehors des limites" and after that it resets it
to 1 which is normal for any sequence whose cycle option is activated.
* Can you please tell what to do during the interval (2147483647 to
9223372036854775807) or How to restart the sequence at 2147483647 ?

--
--
Harsh Raj SINGHAL
Cy-Play

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2012-07-20 12:57:43 Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table
Previous Message Amit Kapila 2012-07-20 02:57:04 Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table