Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache
| От | David G. Johnston |
|---|---|
| Тема | Re: BUG #16430: Sequence with cache > 1 makes it increment by numberspecified as cache |
| Дата | |
| Msg-id | CAKFQuwYeiR4WUg_3+=qrigDF=BfW1bsfD1tGf_Xs0Mj-R5koeQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
RE: BUG #16430: Sequence with cache > 1 makes it increment by number specified as cache
|
| Список | pgsql-bugs |
On Tuesday, May 12, 2020, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 16430
Logged by: Valentinas
Email address: val.janeiko@gmail.com
PostgreSQL version: 12.2
Operating system: Alpine (container)
Description:
When using Sequence inside a plpgsql function called using SELECT func()
using Npgsql library a sequence is incremented by the value specified in
CACHE.
That is a perfectly valid outcome per the meaning and documented usage of cache in the server.
Additionally if CACHE is set to > 80000 (e.g. 100000) the query always
returns 0.
Interesting...probably worth looking into even if a cache value that large doesn’t make much sense usually. Doing and posting some tests using just sql and psql would be a good start in isolating where the discrepancy lies.
David J.
В списке pgsql-bugs по дате отправления: