Postgres Pro
Downloads
Home   >   mailing lists

Sequence generating negative numbers - Mailing list pgsql-general

From Shantanu Shekhar
Subject Sequence generating negative numbers
Date
Msg-id 2073926122.3495277.1597875330242@mail.yahoo.com
Whole thread Raw
Responses Re: Sequence generating negative numbers  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Team,

I have a sequence definition in Postgres 9.6.11 like so:

CREATE SEQUENCE IF NOT EXISTS org.my_seq
  INCREMENT 1
  MINVALUE 1
  NO MAXVALUE
  START 1
  CACHE 20;

This sequence is used by a Java ORM framework to generate primary keys for one of our tables. The initial numbers generated by this sequence are as shown below:

-28 -27 -26 -25 -8 -7 1 2 52 53 72 92 93 94 112 113 132 133 152 172 192 193 212

I am unable to understand why the sequence would start with a negative number, particularly when the definition explicitly asks the sequence to start at 1. This has happened consistently in all of our environments. 

Thanks,

Shantanu

pgsql-general by date:

Previous
From: Philip Semanchuk
Date:
Subject: Understanding EXPLAIN ANALYZE estimates when loops != 1
Next
From: Adrian Klaver
Date:
Subject: Re: Sequence generating negative numbers