Re: additional question about postgresql 10 's new identity column

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: john snow <ofbizfanster(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: additional question about postgresql 10 's new identity column
Date: 2017-12-16 03:27:11
Message-ID: CAKFQuwacFo5J+5u7FfLEdAxfW+10jrnZm2n_PLdNpKS=Oesrcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message john snow 2017-12-16 04:26:38 Re: additional question about postgresql 10 's new identity column
Previous Message john snow 2017-12-16 02:33:42 additional question about postgresql 10 's new identity column