Quick Links

Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache

From:	Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To:	val(dot)janeiko(at)gmail(dot)com, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject:	Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache
Date:	2020-05-12 22:15:48
Message-ID:	CAMkU=1xa0+0LKQj9JgpE8wsjp6X1-XdTCDvcJicEpbp_ocZE+g@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

On Tue, May 12, 2020 at 11:33 AM PG Bug reporting form <
noreply(at)postgresql(dot)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

	From	Date	Subject
Next Message	val.janeiko	2020-05-12 22:56:23	RE: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache
Previous Message	David G. Johnston	2020-05-12 15:47:35	Re: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache