On Friday, December 15, 2017, john snow <ofbizfanster(at)gmail(dot)com> wrote:
> anything we can do or configure so that failed inserts wont advance the
> nextval for the primary key?
>
No. PostgreSQL favors concurrency in this. If you want to go gap-less you
will need to write it up yourself.
David J.