Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache
Date
Msg-id CAMkU=1xa0+0LKQj9JgpE8wsjp6X1-XdTCDvcJicEpbp_ocZE+g@mail.gmail.com
Whole thread Raw
In response to BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Tue, May 12, 2020 at 11:33 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

        MINVALUE 0
        MAXVALUE 79999
        CYCLE

... 
 
Additionally if CACHE is set to > 80000 (e.g. 100000) the query always
returns 0.

Since you told it the maxval was 79999 and to CYCLE, were you expecting something else to happen?  What do you think the desired behavior would be?

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache
Next
From:
Date:
Subject: RE: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache