Description:
I’ve encountered an issue with PostgreSQL sequences in Wappler, where the sequence values jump or have gaps. This happens when records are inserted, causing the sequence to increment beyond the expected value.
It seems that after inserting a record, the next inserted record may have a sequence value higher than expected, resulting in gaps in the sequence.
Is this issue related to wappler SC, or could it be a more general PostgreSQL behavior (possibly related to concurrent load or caching issues)? Has anybody else also faced the same?
For reference, here's a related article on PostgreSQL sequence gaps: Cybertec PostgreSQL Sequence Gaps.
