Postgres Pro
Downloads
Home   >   mailing lists

BUG #15010: Sequence ID is getting skipped - Mailing list pgsql-bugs

From David G. Johnston
Subject BUG #15010: Sequence ID is getting skipped
Date
Msg-id CAKFQuwbn=KdJz=E-=R-VMyVpWuUu6Ak1fwzQxtDxf7=1Fa2ecg@mail.gmail.com
Whole thread Raw
In response to BUG #15010: Sequence ID is getting skipped  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15010: Sequence ID is getting skipped
List pgsql-bugs
Tree view
On Sunday, January 14, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15010
Logged by:          Anil Kumar G V
Email address:      anilkumar.gv@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Ubuntu
Description:

Sometime sequence ID is getting skipped by 32 numbers. Here is some sample
sequence definition.

I don't think the exact cause of this particular skipping is documented (it's database startup, maybe crash, related I think) but sequences are not promised to be gap-less.

David J.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14999: pg_rewind corrupts control file global/pg_control
Next
From: Daniel Gustafsson
Date:
Subject: Re: BUG #15010: Sequence ID is getting skipped